PREVIEW / stock_1hour / 2015-07-08

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-07-08.parquet
  size:    1.0 MB
  rows:    49,073
  symbols: 3,489

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-07-08 04:00:00	AAPL	Stock	31.1175	31.1525	31.0	31.0525	109264.0
2015-07-08 05:00:00	AAPL	Stock	31.075	31.1	31.0525	31.1	32260.0
2015-07-08 06:00:00	AAPL	Stock	31.1225	31.175	31.0875	31.175	43008.0
2015-07-08 07:00:00	AAPL	Stock	31.2125	31.3	31.19	31.205	143380.0
2015-07-08 08:00:00	AAPL	Stock	31.2025	31.3125	31.0875	31.1575	623808.0
2015-07-08 09:00:00	AAPL	Stock	31.1625	31.1675	30.84	30.9182	40339352.0
2015-07-08 10:00:00	AAPL	Stock	30.92	31.07	30.7525	31.0348	54839312.0
2015-07-08 11:00:00	AAPL	Stock	31.034	31.0375	30.7775	30.81	26169156.0
2015-07-08 12:00:00	AAPL	Stock	30.8125	30.8925	30.8025	30.8775	16565728.0
2015-07-08 13:00:00	AAPL	Stock	30.8788	30.975	30.8125	30.97	15026180.0
2015-07-08 14:00:00	AAPL	Stock	30.9712	30.99	30.7025	30.7475	28224672.0
2015-07-08 15:00:00	AAPL	Stock	30.7472	30.845	30.635	30.6475	40079320.0
2015-07-08 16:00:00	AAPL	Stock	30.6475	30.862	30.625	30.645	5253600.0
2015-07-08 17:00:00	AAPL	Stock	30.6458	30.66	30.635	30.635	249456.0
2015-07-08 18:00:00	AAPL	Stock	30.635	30.6625	30.6275	30.6508	202728.0
2015-07-08 19:00:00	AAPL	Stock	30.66	30.6725	30.6475	30.6525	189284.0
2015-07-08 04:00:00	MSFT	Stock	43.95	43.95	43.65	43.75	4100.0
2015-07-08 07:00:00	MSFT	Stock	43.9	44.04	43.89	43.99	16063.0
2015-07-08 08:00:00	MSFT	Stock	43.81	44.11	43.81	44.1	20280.0
2015-07-08 09:00:00	MSFT	Stock	44.1	44.83	43.94	44.27	6341810.0
2015-07-08 10:00:00	MSFT	Stock	44.265	44.9	44.14	44.77	8289946.0
2015-07-08 11:00:00	MSFT	Stock	44.77	44.78	44.22	44.31	4925508.0
2015-07-08 12:00:00	MSFT	Stock	44.31	44.6	44.28	44.561	2764920.0
2015-07-08 13:00:00	MSFT	Stock	44.565	44.68	44.44	44.61	2636937.0
2015-07-08 14:00:00	MSFT	Stock	44.61	44.63	44.11	44.15	4446649.0
2015-07-08 15:00:00	MSFT	Stock	44.16	44.4	44.13	44.25	7126436.0
2015-07-08 16:00:00	MSFT	Stock	44.25	44.455	44.24	44.3	1613401.0
2015-07-08 17:00:00	MSFT	Stock	44.3	44.3	44.3	44.3	4200.0
2015-07-08 18:00:00	MSFT	Stock	44.303	44.303	44.303	44.303	1100.0
2015-07-08 19:00:00	MSFT	Stock	44.3	44.33	44.3	44.33	501.0
2015-07-08 08:00:00	NVDA	Stock	0.4912	0.494	0.4912	0.494	159600.0
2015-07-08 09:00:00	NVDA	Stock	0.4925	0.495	0.488	0.4905	33800800.0
2015-07-08 10:00:00	NVDA	Stock	0.4902	0.4923	0.4884	0.492	55530400.0
2015-07-08 11:00:00	NVDA	Stock	0.492	0.492	0.4872	0.4898	32991960.0
2015-07-08 12:00:00	NVDA	Stock	0.4898	0.4923	0.4891	0.492	33223000.0
2015-07-08 13:00:00	NVDA	Stock	0.492	0.4948	0.4908	0.4942	26590680.0
2015-07-08 14:00:00	NVDA	Stock	0.4945	0.4946	0.4912	0.4923	43875480.0
2015-07-08 15:00:00	NVDA	Stock	0.4923	0.4945	0.4905	0.4912	75849440.0
2015-07-08 16:00:00	NVDA	Stock	0.4912	0.4912	0.4908	0.4912	16443400.0
2015-07-08 04:00:00	AMZN	Stock	21.575	21.575	21.575	21.575	2000.0
2015-07-08 07:00:00	AMZN	Stock	21.725	21.725	21.725	21.725	4000.0
2015-07-08 08:00:00	AMZN	Stock	21.7022	21.7485	21.6975	21.7075	69020.0
2015-07-08 09:00:00	AMZN	Stock	21.7075	21.7995	21.6185	21.699	9063240.0
2015-07-08 10:00:00	AMZN	Stock	21.7145	21.7145	21.5375	21.6028	8271340.0
2015-07-08 11:00:00	AMZN	Stock	21.6141	21.6178	21.471	21.5155	5244640.0
2015-07-08 12:00:00	AMZN	Stock	21.5087	21.6028	21.507	21.5885	2758460.0
2015-07-08 13:00:00	AMZN	Stock	21.5935	21.659	21.534	21.634	2693580.0
2015-07-08 14:00:00	AMZN	Stock	21.627	21.6375	21.451	21.4855	4036260.0
2015-07-08 15:00:00	AMZN	Stock	21.47	21.562	21.4415	21.481	6348820.0
2015-07-08 16:00:00	AMZN	Stock	21.485	21.518	21.4845	21.485	1716040.0

> showing 50 of 49,073 rows — these rows as CSV

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