PREVIEW / stock_1hour / 2011-10-31

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-10-31.parquet
  size:    932 KB
  rows:    44,538
  symbols: 3,524

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2011-10-31 04:00:00	AAPL	Stock	14.3929	14.4046	14.3818	14.3818	15400.0
2011-10-31 05:00:00	AAPL	Stock	14.3571	14.3571	14.3268	14.3275	42000.0
2011-10-31 06:00:00	AAPL	Stock	14.3143	14.3321	14.3125	14.3321	41104.0
2011-10-31 07:00:00	AAPL	Stock	14.3318	14.3661	14.3318	14.3618	193564.0
2011-10-31 08:00:00	AAPL	Stock	14.3636	14.4061	14.3529	14.3746	1030792.0
2011-10-31 09:00:00	AAPL	Stock	14.3714	14.4286	14.3232	14.4271	48036548.0
2011-10-31 10:00:00	AAPL	Stock	14.4284	14.6189	14.4114	14.5575	90236244.0
2011-10-31 11:00:00	AAPL	Stock	14.5621	14.5832	14.5121	14.5471	45211124.0
2011-10-31 12:00:00	AAPL	Stock	14.5464	14.5607	14.465	14.52	35291228.0
2011-10-31 13:00:00	AAPL	Stock	14.5182	14.5636	14.5171	14.5611	25215848.0
2011-10-31 14:00:00	AAPL	Stock	14.56	14.5689	14.5	14.5339	33601820.0
2011-10-31 15:00:00	AAPL	Stock	14.5307	14.5332	14.4368	14.4571	81077640.0
2011-10-31 16:00:00	AAPL	Stock	14.4771	14.5338	14.3934	14.4464	19636092.0
2011-10-31 17:00:00	AAPL	Stock	14.4446	14.4464	14.4343	14.4389	165732.0
2011-10-31 18:00:00	AAPL	Stock	14.4343	14.4564	14.4286	14.4354	83944.0
2011-10-31 19:00:00	AAPL	Stock	14.4389	14.4457	14.4339	14.4414	105000.0
2011-10-31 04:00:00	MSFT	Stock	26.9	26.9	26.9	26.9	10000.0
2011-10-31 08:00:00	MSFT	Stock	26.86	26.86	26.72	26.84	11415.0
2011-10-31 09:00:00	MSFT	Stock	26.83	26.88	26.72	26.8	2453186.0
2011-10-31 10:00:00	MSFT	Stock	26.8	27.0	26.79	26.955	4561111.0
2011-10-31 11:00:00	MSFT	Stock	26.95	26.955	26.81	26.81	5489710.0
2011-10-31 12:00:00	MSFT	Stock	26.81	26.83	26.72	26.805	5933920.0
2011-10-31 13:00:00	MSFT	Stock	26.81	26.86	26.74	26.85	3870264.0
2011-10-31 14:00:00	MSFT	Stock	26.844	26.86	26.735	26.767	3638358.0
2011-10-31 15:00:00	MSFT	Stock	26.77	26.82	26.62	26.65	12350920.0
2011-10-31 16:00:00	MSFT	Stock	26.65	26.952	26.59	26.63	6283347.0
2011-10-31 17:00:00	MSFT	Stock	26.6	26.61	26.59	26.61	5600.0
2011-10-31 18:00:00	MSFT	Stock	26.61	26.63	26.57	26.57	11600.0
2011-10-31 19:00:00	MSFT	Stock	26.59	26.6	26.57	26.6	4570.0
2011-10-31 04:00:00	NVDA	Stock	0.39	0.39	0.39	0.39	8000.0
2011-10-31 08:00:00	NVDA	Stock	0.3885	0.3885	0.3788	0.3808	321920.0
2011-10-31 09:00:00	NVDA	Stock	0.3818	0.3818	0.37	0.3745	105707680.0
2011-10-31 10:00:00	NVDA	Stock	0.3748	0.3775	0.371	0.374	75550200.0
2011-10-31 11:00:00	NVDA	Stock	0.3743	0.3773	0.3718	0.3745	77660120.0
2011-10-31 12:00:00	NVDA	Stock	0.3748	0.375	0.3715	0.3733	38535440.0
2011-10-31 13:00:00	NVDA	Stock	0.373	0.3761	0.372	0.376	35382400.0
2011-10-31 14:00:00	NVDA	Stock	0.3758	0.376	0.3723	0.3743	40794400.0
2011-10-31 15:00:00	NVDA	Stock	0.3741	0.3741	0.37	0.37	119104160.0
2011-10-31 16:00:00	NVDA	Stock	0.37	0.3737	0.3695	0.3695	22869720.0
2011-10-31 17:00:00	NVDA	Stock	0.3695	0.372	0.3695	0.372	14000.0
2011-10-31 18:00:00	NVDA	Stock	0.37	0.3703	0.37	0.3703	207000.0
2011-10-31 19:00:00	NVDA	Stock	0.37	0.3733	0.37	0.3733	62800.0
2011-10-31 04:00:00	AMZN	Stock	10.9615	11.2235	10.799	10.799	49140.0
2011-10-31 05:00:00	AMZN	Stock	10.799	10.8	10.791	10.8	16300.0
2011-10-31 06:00:00	AMZN	Stock	10.8	10.823	10.7885	10.7885	28080.0
2011-10-31 07:00:00	AMZN	Stock	10.8025	10.8055	10.7655	10.795	102220.0
2011-10-31 08:00:00	AMZN	Stock	10.772	10.8	10.7495	10.75	504740.0
2011-10-31 09:00:00	AMZN	Stock	10.75	10.9445	10.739	10.8534	27323300.0
2011-10-31 10:00:00	AMZN	Stock	10.852	10.8585	10.7835	10.812	23913740.0
2011-10-31 11:00:00	AMZN	Stock	10.81	10.865	10.7091	10.721	21591740.0

> showing 50 of 44,538 rows — these rows as CSV

> unlock the full archive -- $79 one-time