PREVIEW / stock_1hour / 2015-01-29

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-01-29.parquet
  size:    1.0 MB
  rows:    48,723
  symbols: 3,513

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
2015-01-29 04:00:00	AAPL	Stock	28.9275	29.0875	28.9275	29.05	11440.0
2015-01-29 05:00:00	AAPL	Stock	29.05	29.05	29.0	29.0	45036.0
2015-01-29 06:00:00	AAPL	Stock	29.0475	29.05	29.025	29.0425	180508.0
2015-01-29 07:00:00	AAPL	Stock	29.0475	29.125	29.005	29.0175	341528.0
2015-01-29 08:00:00	AAPL	Stock	29.025	29.115	28.775	29.075	1562528.0
2015-01-29 09:00:00	AAPL	Stock	29.08	29.2475	28.89	29.235	44796216.0
2015-01-29 10:00:00	AAPL	Stock	29.235	29.33	29.065	29.215	55850296.0
2015-01-29 11:00:00	AAPL	Stock	29.215	29.3675	29.1612	29.325	35901748.0
2015-01-29 12:00:00	AAPL	Stock	29.3252	29.3725	29.2525	29.315	24365484.0
2015-01-29 13:00:00	AAPL	Stock	29.3128	29.53	29.275	29.49	33411112.0
2015-01-29 14:00:00	AAPL	Stock	29.4925	29.7375	29.4575	29.735	50092248.0
2015-01-29 15:00:00	AAPL	Stock	29.735	29.7975	29.5472	29.735	55410960.0
2015-01-29 16:00:00	AAPL	Stock	29.725	29.7675	29.0842	29.7475	9988800.0
2015-01-29 17:00:00	AAPL	Stock	29.7475	29.7975	29.7475	29.7875	646260.0
2015-01-29 18:00:00	AAPL	Stock	29.795	29.8325	29.725	29.8025	595188.0
2015-01-29 19:00:00	AAPL	Stock	29.8025	29.8025	29.73	29.7625	221252.0
2015-01-29 04:00:00	MSFT	Stock	41.11	41.15	40.95	41.15	4550.0
2015-01-29 05:00:00	MSFT	Stock	41.01	41.15	41.01	41.15	1994.0
2015-01-29 06:00:00	MSFT	Stock	41.1	41.25	41.1	41.25	4400.0
2015-01-29 07:00:00	MSFT	Stock	41.19	41.22	41.17	41.22	5358.0
2015-01-29 08:00:00	MSFT	Stock	41.24	41.25	41.1	41.14	51414.0
2015-01-29 09:00:00	MSFT	Stock	41.15	41.35	40.79	41.31	10263201.0
2015-01-29 10:00:00	MSFT	Stock	41.3	41.435	41.04	41.19	9366245.0
2015-01-29 11:00:00	MSFT	Stock	41.18	41.315	40.99	41.16	5893353.0
2015-01-29 12:00:00	MSFT	Stock	41.17	41.375	41.1	41.255	4098039.0
2015-01-29 13:00:00	MSFT	Stock	41.26	41.76	41.2	41.66	5096534.0
2015-01-29 14:00:00	MSFT	Stock	41.66	41.93	41.63	41.86	5634249.0
2015-01-29 15:00:00	MSFT	Stock	41.86	42.12	41.81	42.02	8403656.0
2015-01-29 16:00:00	MSFT	Stock	42.01	42.1	41.17	41.442	7273018.0
2015-01-29 17:00:00	MSFT	Stock	42.01	42.05	41.98	42.05	3808.0
2015-01-29 18:00:00	MSFT	Stock	42.04	42.1	42.01	42.1	23189.0
2015-01-29 19:00:00	MSFT	Stock	42.11	42.11	42.01	42.05	6295.0
2015-01-29 09:00:00	NVDA	Stock	0.483	0.4902	0.4825	0.4879	21629880.0
2015-01-29 10:00:00	NVDA	Stock	0.4878	0.4878	0.4808	0.4849	36720360.0
2015-01-29 11:00:00	NVDA	Stock	0.4848	0.4865	0.4828	0.485	20385760.0
2015-01-29 12:00:00	NVDA	Stock	0.4848	0.4888	0.4845	0.4888	33952720.0
2015-01-29 13:00:00	NVDA	Stock	0.4885	0.4946	0.4875	0.4928	18021600.0
2015-01-29 14:00:00	NVDA	Stock	0.493	0.4935	0.4908	0.4925	22937240.0
2015-01-29 15:00:00	NVDA	Stock	0.4924	0.4972	0.4921	0.4945	53026080.0
2015-01-29 16:00:00	NVDA	Stock	0.4945	0.4946	0.4888	0.4888	3713960.0
2015-01-29 17:00:00	NVDA	Stock	0.4835	0.4835	0.4835	0.4835	5110440.0
2015-01-29 07:00:00	AMZN	Stock	15.2155	15.25	15.175	15.25	96740.0
2015-01-29 08:00:00	AMZN	Stock	15.211	15.26	15.21	15.225	50220.0
2015-01-29 09:00:00	AMZN	Stock	15.21	15.2995	15.0535	15.1178	11470920.0
2015-01-29 10:00:00	AMZN	Stock	15.118	15.184	14.9665	15.0728	11665920.0
2015-01-29 11:00:00	AMZN	Stock	15.067	15.2185	15.04	15.1375	6936680.0
2015-01-29 12:00:00	AMZN	Stock	15.1325	15.244	15.1325	15.2315	7507560.0
2015-01-29 13:00:00	AMZN	Stock	15.235	15.3192	15.2345	15.2754	8929940.0
2015-01-29 14:00:00	AMZN	Stock	15.2774	15.45	15.255	15.4152	15377560.0
2015-01-29 15:00:00	AMZN	Stock	15.4145	15.64	15.4095	15.589	39845160.0

> showing 50 of 48,723 rows — these rows as CSV

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