PREVIEW / stock_1hour / 2017-10-06

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-10-06.parquet
  size:    1.1 MB
  rows:    48,505
  symbols: 2,961

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
2017-10-06 04:00:00	AAPL	Stock	38.825	38.825	38.75	38.75	3764.0
2017-10-06 05:00:00	AAPL	Stock	38.7475	38.7625	38.7475	38.7625	3788.0
2017-10-06 06:00:00	AAPL	Stock	38.76	38.8175	38.76	38.8175	22192.0
2017-10-06 07:00:00	AAPL	Stock	38.7875	38.82	38.75	38.75	51248.0
2017-10-06 08:00:00	AAPL	Stock	38.805	38.93	38.665	38.6675	484768.0
2017-10-06 09:00:00	AAPL	Stock	38.665	38.8725	38.64	38.685	9821740.0
2017-10-06 10:00:00	AAPL	Stock	38.6825	38.79	38.6575	38.6925	7939116.0
2017-10-06 11:00:00	AAPL	Stock	38.6925	38.7938	38.6825	38.6888	5953248.0
2017-10-06 12:00:00	AAPL	Stock	38.6888	38.7775	38.6525	38.76	5598296.0
2017-10-06 13:00:00	AAPL	Stock	38.7575	38.8125	38.7275	38.7798	5376792.0
2017-10-06 14:00:00	AAPL	Stock	38.7775	38.8	38.7375	38.7725	3729780.0
2017-10-06 15:00:00	AAPL	Stock	38.7725	38.835	38.7475	38.8225	14974800.0
2017-10-06 16:00:00	AAPL	Stock	38.825	38.845	38.8175	38.83	5378488.0
2017-10-06 17:00:00	AAPL	Stock	38.83	38.85	38.825	38.8325	164956.0
2017-10-06 18:00:00	AAPL	Stock	38.8325	38.8425	38.8275	38.8275	45296.0
2017-10-06 19:00:00	AAPL	Stock	38.835	38.8425	38.825	38.8425	21300.0
2017-10-06 06:00:00	MSFT	Stock	75.88	75.88	75.88	75.88	200.0
2017-10-06 07:00:00	MSFT	Stock	76.04	76.04	75.99	75.99	420.0
2017-10-06 08:00:00	MSFT	Stock	75.97	75.97	75.7	75.72	9653.0
2017-10-06 09:00:00	MSFT	Stock	75.79	75.92	75.56	75.78	1539723.0
2017-10-06 10:00:00	MSFT	Stock	75.78	76.03	75.54	75.64	1900911.0
2017-10-06 11:00:00	MSFT	Stock	75.64	75.849	75.64	75.83	953948.0
2017-10-06 12:00:00	MSFT	Stock	75.82	75.93	75.747	75.795	840634.0
2017-10-06 13:00:00	MSFT	Stock	75.795	75.8	75.673	75.72	652663.0
2017-10-06 14:00:00	MSFT	Stock	75.724	75.73	75.57	75.665	993735.0
2017-10-06 15:00:00	MSFT	Stock	75.665	76.0	75.64	75.99	2906725.0
2017-10-06 16:00:00	MSFT	Stock	76.0	76.01	75.9	75.99	2505959.0
2017-10-06 17:00:00	MSFT	Stock	75.95	75.95	75.95	75.95	100.0
2017-10-06 18:00:00	MSFT	Stock	75.99	75.99	75.96	75.97	2000.0
2017-10-06 19:00:00	MSFT	Stock	75.96	76.0	75.96	75.99	3135.0
2017-10-06 04:00:00	NVDA	Stock	4.5225	4.5225	4.5225	4.5225	12000.0
2017-10-06 06:00:00	NVDA	Stock	4.53	4.53	4.53	4.53	12000.0
2017-10-06 07:00:00	NVDA	Stock	4.53	4.53	4.5225	4.5225	368000.0
2017-10-06 08:00:00	NVDA	Stock	4.53	4.535	4.4918	4.4958	1793880.0
2017-10-06 09:00:00	NVDA	Stock	4.4932	4.523	4.475	4.4955	59677080.0
2017-10-06 10:00:00	NVDA	Stock	4.4953	4.511	4.4942	4.5028	39387240.0
2017-10-06 11:00:00	NVDA	Stock	4.5025	4.5338	4.5	4.5235	48973040.0
2017-10-06 12:00:00	NVDA	Stock	4.5228	4.546	4.5202	4.5333	41019520.0
2017-10-06 13:00:00	NVDA	Stock	4.5325	4.5349	4.516	4.5285	21414800.0
2017-10-06 14:00:00	NVDA	Stock	4.528	4.5325	4.523	4.5286	19797920.0
2017-10-06 15:00:00	NVDA	Stock	4.528	4.535	4.519	4.5325	40716560.0
2017-10-06 16:00:00	NVDA	Stock	4.5325	4.5342	4.5211	4.5333	10382040.0
2017-10-06 17:00:00	NVDA	Stock	4.5325	4.5338	4.5318	4.5325	148080.0
2017-10-06 18:00:00	NVDA	Stock	4.5322	4.5325	4.5318	4.5318	361520.0
2017-10-06 19:00:00	NVDA	Stock	4.5325	4.5325	4.5318	4.5322	274440.0
2017-10-06 07:00:00	AMZN	Stock	49.004	49.004	49.0	49.0	4320.0
2017-10-06 08:00:00	AMZN	Stock	49.075	49.075	48.8	48.8	221300.0
2017-10-06 09:00:00	AMZN	Stock	48.842	49.436	48.782	49.3165	14721300.0
2017-10-06 10:00:00	AMZN	Stock	49.3075	49.434	49.202	49.3033	7996680.0
2017-10-06 11:00:00	AMZN	Stock	49.2952	49.6234	49.2937	49.6089	7608020.0

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

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