PREVIEW / stock_1hour / 2019-10-17

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-10-17.parquet
  size:    1.1 MB
  rows:    48,976
  symbols: 2,507

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
2019-10-17 04:00:00	AAPL	Stock	58.6925	58.7925	58.6225	58.7	10844.0
2019-10-17 05:00:00	AAPL	Stock	58.6875	58.965	58.6875	58.9375	29020.0
2019-10-17 06:00:00	AAPL	Stock	58.925	58.96	58.89	58.9125	40432.0
2019-10-17 07:00:00	AAPL	Stock	58.9725	58.9975	58.8275	58.9775	216116.0
2019-10-17 08:00:00	AAPL	Stock	58.9	58.99	58.8125	58.8975	293560.0
2019-10-17 09:00:00	AAPL	Stock	58.8775	59.0375	58.6812	58.9608	8461232.0
2019-10-17 10:00:00	AAPL	Stock	58.965	59.01	58.555	58.6175	10191628.0
2019-10-17 11:00:00	AAPL	Stock	58.6218	58.655	58.388	58.48	8154708.0
2019-10-17 12:00:00	AAPL	Stock	58.48	58.605	58.38	58.5995	4887228.0
2019-10-17 13:00:00	AAPL	Stock	58.597	58.8125	58.5575	58.7275	4915668.0
2019-10-17 14:00:00	AAPL	Stock	58.73	58.7875	58.5908	58.7775	5207476.0
2019-10-17 15:00:00	AAPL	Stock	58.7825	58.875	58.7125	58.8225	8247728.0
2019-10-17 16:00:00	AAPL	Stock	58.82	58.8725	58.82	58.845	4637288.0
2019-10-17 17:00:00	AAPL	Stock	58.8475	58.8475	58.82	58.8375	15948.0
2019-10-17 18:00:00	AAPL	Stock	58.825	58.8275	58.7875	58.8	25020.0
2019-10-17 19:00:00	AAPL	Stock	58.8125	58.8375	58.7875	58.8025	47068.0
2019-10-17 04:00:00	MSFT	Stock	140.43	140.8	140.43	140.8	500.0
2019-10-17 05:00:00	MSFT	Stock	140.62	141.05	140.2	141.0	39358.0
2019-10-17 06:00:00	MSFT	Stock	141.09	141.15	140.84	140.98	9715.0
2019-10-17 07:00:00	MSFT	Stock	140.9	141.18	140.72	141.15	55039.0
2019-10-17 08:00:00	MSFT	Stock	140.85	141.198	140.75	141.12	36911.0
2019-10-17 09:00:00	MSFT	Stock	141.08	141.42	140.59	140.96	1922087.0
2019-10-17 10:00:00	MSFT	Stock	140.95	140.97	139.47	139.62	3908988.0
2019-10-17 11:00:00	MSFT	Stock	139.62	139.8	139.05	139.31	2821625.0
2019-10-17 12:00:00	MSFT	Stock	139.32	139.54	139.02	139.49	1695677.0
2019-10-17 13:00:00	MSFT	Stock	139.495	139.7	139.32	139.6	1238102.0
2019-10-17 14:00:00	MSFT	Stock	139.61	139.99	139.38	139.84	1546859.0
2019-10-17 15:00:00	MSFT	Stock	139.85	139.94	139.54	139.67	2706269.0
2019-10-17 16:00:00	MSFT	Stock	139.69	139.802	139.375	139.64	3177113.0
2019-10-17 17:00:00	MSFT	Stock	139.6	139.76	139.6	139.7	3541.0
2019-10-17 18:00:00	MSFT	Stock	139.6	139.7	139.57	139.68	4764.0
2019-10-17 19:00:00	MSFT	Stock	139.65	139.69	139.62	139.68	9549.0
2019-10-17 04:00:00	NVDA	Stock	4.8625	4.8828	4.8625	4.8828	32000.0
2019-10-17 05:00:00	NVDA	Stock	4.8828	4.9058	4.8722	4.905	52640.0
2019-10-17 06:00:00	NVDA	Stock	4.905	4.915	4.905	4.915	98760.0
2019-10-17 07:00:00	NVDA	Stock	4.91	4.9213	4.905	4.91	670560.0
2019-10-17 08:00:00	NVDA	Stock	4.9202	4.921	4.8884	4.9125	1254320.0
2019-10-17 09:00:00	NVDA	Stock	4.9172	4.9454	4.8784	4.8863	46267600.0
2019-10-17 10:00:00	NVDA	Stock	4.8852	4.9045	4.8383	4.8527	41316160.0
2019-10-17 11:00:00	NVDA	Stock	4.8515	4.861	4.8088	4.824	31961200.0
2019-10-17 12:00:00	NVDA	Stock	4.825	4.833	4.8115	4.819	23590760.0
2019-10-17 13:00:00	NVDA	Stock	4.8182	4.8425	4.8025	4.8395	30189080.0
2019-10-17 14:00:00	NVDA	Stock	4.8398	4.8553	4.828	4.853	18593360.0
2019-10-17 15:00:00	NVDA	Stock	4.8538	4.8588	4.837	4.8573	37680520.0
2019-10-17 16:00:00	NVDA	Stock	4.8573	4.858	4.8196	4.858	2333720.0
2019-10-17 17:00:00	NVDA	Stock	4.8573	4.8598	4.8553	4.8595	92480.0
2019-10-17 18:00:00	NVDA	Stock	4.8553	4.8553	4.8475	4.8525	95440.0
2019-10-17 19:00:00	NVDA	Stock	4.853	4.8573	4.8515	4.8573	152440.0
2019-10-17 06:00:00	AMZN	Stock	89.7	89.75	89.6	89.75	37120.0
2019-10-17 07:00:00	AMZN	Stock	89.7	89.9	89.6505	89.9	85520.0

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

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