PREVIEW / stock_1hour / 2016-01-21

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-01-21.parquet
  size:    1.0 MB
  rows:    49,108
  symbols: 3,394

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
2016-01-21 04:00:00	AAPL	Stock	22.755	24.1225	22.755	24.075	45880.0
2016-01-21 05:00:00	AAPL	Stock	24.0925	24.15	24.0825	24.0875	32696.0
2016-01-21 06:00:00	AAPL	Stock	24.1	24.1025	24.0	24.0	24604.0
2016-01-21 07:00:00	AAPL	Stock	24.05	24.19	23.8925	24.1525	68284.0
2016-01-21 08:00:00	AAPL	Stock	24.1525	24.4025	24.04	24.225	794180.0
2016-01-21 09:00:00	AAPL	Stock	24.2175	24.3225	23.735	23.7975	25335984.0
2016-01-21 10:00:00	AAPL	Stock	23.81	24.27	23.795	24.11	34336532.0
2016-01-21 11:00:00	AAPL	Stock	24.1125	24.445	24.0675	24.425	26624520.0
2016-01-21 12:00:00	AAPL	Stock	24.4248	24.47	24.29	24.34	20902044.0
2016-01-21 13:00:00	AAPL	Stock	24.3412	24.3975	24.1775	24.2075	18808692.0
2016-01-21 14:00:00	AAPL	Stock	24.205	24.2475	23.9625	24.2308	21675128.0
2016-01-21 15:00:00	AAPL	Stock	24.2325	24.2375	24.04	24.065	24477912.0
2016-01-21 16:00:00	AAPL	Stock	24.075	24.2112	24.0348	24.075	11961400.0
2016-01-21 17:00:00	AAPL	Stock	24.08	24.1875	24.075	24.115	148896.0
2016-01-21 18:00:00	AAPL	Stock	24.1225	24.1225	24.0775	24.09	59780.0
2016-01-21 19:00:00	AAPL	Stock	24.105	24.155	24.08	24.1125	38856.0
2016-01-21 04:00:00	MSFT	Stock	50.43	50.43	50.43	50.43	800.0
2016-01-21 06:00:00	MSFT	Stock	50.54	50.54	50.3	50.54	5300.0
2016-01-21 07:00:00	MSFT	Stock	50.54	50.75	50.54	50.7	5200.0
2016-01-21 08:00:00	MSFT	Stock	50.85	51.44	50.85	51.1	45155.0
2016-01-21 09:00:00	MSFT	Stock	51.12	51.34	50.42	50.59	3806213.0
2016-01-21 10:00:00	MSFT	Stock	50.595	51.44	50.545	51.11	6602462.0
2016-01-21 11:00:00	MSFT	Stock	51.11	51.51	51.04	51.49	4874496.0
2016-01-21 12:00:00	MSFT	Stock	51.5	51.58	51.0	51.01	3341254.0
2016-01-21 13:00:00	MSFT	Stock	51.02	51.28	50.7	50.804	4144956.0
2016-01-21 14:00:00	MSFT	Stock	50.82	51.3	50.3	50.76	5376268.0
2016-01-21 15:00:00	MSFT	Stock	50.76	51.09	50.39	50.45	6981184.0
2016-01-21 16:00:00	MSFT	Stock	50.48	50.56	50.4	50.4	2368663.0
2016-01-21 17:00:00	MSFT	Stock	50.4	50.48	50.4	50.4	4080.0
2016-01-21 18:00:00	MSFT	Stock	50.38	50.46	50.38	50.46	1123.0
2016-01-21 19:00:00	MSFT	Stock	50.47	50.59	50.47	50.51	3791.0
2016-01-21 08:00:00	NVDA	Stock	0.6892	0.7	0.6892	0.7	54000.0
2016-01-21 09:00:00	NVDA	Stock	0.69	0.6945	0.6802	0.6832	27455360.0
2016-01-21 10:00:00	NVDA	Stock	0.6832	0.7015	0.6832	0.6992	64431480.0
2016-01-21 11:00:00	NVDA	Stock	0.6992	0.7058	0.697	0.7018	77871560.0
2016-01-21 12:00:00	NVDA	Stock	0.702	0.7049	0.6995	0.7015	37941880.0
2016-01-21 13:00:00	NVDA	Stock	0.7018	0.7046	0.6968	0.6995	57875920.0
2016-01-21 14:00:00	NVDA	Stock	0.6998	0.7009	0.6935	0.6989	40329720.0
2016-01-21 15:00:00	NVDA	Stock	0.6988	0.7005	0.6935	0.6948	66173240.0
2016-01-21 16:00:00	NVDA	Stock	0.695	0.6968	0.695	0.695	18545920.0
2016-01-21 04:00:00	AMZN	Stock	28.25	28.25	28.0	28.0785	28540.0
2016-01-21 06:00:00	AMZN	Stock	28.4855	28.4855	28.45	28.455	6000.0
2016-01-21 07:00:00	AMZN	Stock	28.4195	28.651	28.35	28.65	102920.0
2016-01-21 08:00:00	AMZN	Stock	28.68	29.0895	28.6505	28.86	620340.0
2016-01-21 09:00:00	AMZN	Stock	28.8415	28.9495	28.411	28.476	13786720.0
2016-01-21 10:00:00	AMZN	Stock	28.5005	29.3797	28.4835	29.152	17606660.0
2016-01-21 11:00:00	AMZN	Stock	29.168	29.297	29.05	29.21	9222240.0
2016-01-21 12:00:00	AMZN	Stock	29.208	29.4405	29.196	29.2585	10870840.0
2016-01-21 13:00:00	AMZN	Stock	29.271	29.3195	28.9515	29.1005	8706000.0
2016-01-21 14:00:00	AMZN	Stock	29.121	29.385	28.7605	28.9035	10525260.0

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

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