PREVIEW / stock_1hour / 2019-07-23

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-07-23.parquet
  size:    1.1 MB
  rows:    49,582
  symbols: 2,576

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-07-23 04:00:00	AAPL	Stock	52.0	52.0	51.875	51.9075	34564.0
2019-07-23 05:00:00	AAPL	Stock	51.9075	51.93	51.8875	51.93	4816.0
2019-07-23 06:00:00	AAPL	Stock	51.975	52.0475	51.975	51.975	15880.0
2019-07-23 07:00:00	AAPL	Stock	52.0	52.0625	51.96	52.015	166520.0
2019-07-23 08:00:00	AAPL	Stock	52.0	52.17	51.6775	52.0918	407368.0
2019-07-23 09:00:00	AAPL	Stock	52.09	52.1975	51.8575	51.96	11212544.0
2019-07-23 10:00:00	AAPL	Stock	51.96	52.12	51.885	52.03	9170556.0
2019-07-23 11:00:00	AAPL	Stock	52.03	52.065	51.8225	51.9025	6544840.0
2019-07-23 12:00:00	AAPL	Stock	51.9068	51.97	51.8425	51.93	4308368.0
2019-07-23 13:00:00	AAPL	Stock	51.93	52.0875	51.855	52.0575	5453952.0
2019-07-23 14:00:00	AAPL	Stock	52.06	52.1175	51.996	52.1138	5606708.0
2019-07-23 15:00:00	AAPL	Stock	52.115	52.2275	52.065	52.2062	8428996.0
2019-07-23 16:00:00	AAPL	Stock	52.21	52.2925	51.69	51.8625	4310072.0
2019-07-23 17:00:00	AAPL	Stock	51.8625	52.0625	51.825	52.0	230144.0
2019-07-23 18:00:00	AAPL	Stock	52.0025	52.0375	51.9525	52.0	56224.0
2019-07-23 19:00:00	AAPL	Stock	52.0	52.0	51.925	51.9825	44720.0
2019-07-23 04:00:00	MSFT	Stock	138.47	139.0	138.47	139.0	798.0
2019-07-23 05:00:00	MSFT	Stock	138.99	139.0	138.99	139.0	893.0
2019-07-23 06:00:00	MSFT	Stock	139.02	139.25	139.02	139.25	1978.0
2019-07-23 07:00:00	MSFT	Stock	139.04	139.25	138.95	139.0	12447.0
2019-07-23 08:00:00	MSFT	Stock	139.108	139.22	138.77	139.0	72980.0
2019-07-23 09:00:00	MSFT	Stock	138.9	140.12	138.15	138.26	3025962.0
2019-07-23 10:00:00	MSFT	Stock	138.255	138.97	138.03	138.85	2263654.0
2019-07-23 11:00:00	MSFT	Stock	138.85	138.94	138.46	138.56	1458839.0
2019-07-23 12:00:00	MSFT	Stock	138.555	138.605	138.2	138.56	1202879.0
2019-07-23 13:00:00	MSFT	Stock	138.575	139.13	138.5	139.075	1651410.0
2019-07-23 14:00:00	MSFT	Stock	139.08	139.148	138.825	139.09	1277026.0
2019-07-23 15:00:00	MSFT	Stock	139.09	139.29	138.93	139.29	2716985.0
2019-07-23 16:00:00	MSFT	Stock	139.28	139.3	138.56	138.6	1721913.0
2019-07-23 17:00:00	MSFT	Stock	138.78	138.84	138.68	138.75	13662.0
2019-07-23 18:00:00	MSFT	Stock	138.75	138.96	138.73	138.85	5527.0
2019-07-23 19:00:00	MSFT	Stock	138.86	139.18	138.86	139.17	16653.0
2019-07-23 04:00:00	NVDA	Stock	4.3052	4.3052	4.3052	4.3052	4000.0
2019-07-23 05:00:00	NVDA	Stock	4.3055	4.308	4.3055	4.308	19560.0
2019-07-23 06:00:00	NVDA	Stock	4.311	4.3145	4.311	4.3145	16000.0
2019-07-23 07:00:00	NVDA	Stock	4.3088	4.3153	4.3	4.3138	312440.0
2019-07-23 08:00:00	NVDA	Stock	4.3112	4.3248	4.3062	4.3188	821360.0
2019-07-23 09:00:00	NVDA	Stock	4.3222	4.375	4.3155	4.3495	101886680.0
2019-07-23 10:00:00	NVDA	Stock	4.3508	4.3525	4.3068	4.3478	61793240.0
2019-07-23 11:00:00	NVDA	Stock	4.3475	4.3635	4.328	4.333	42527040.0
2019-07-23 12:00:00	NVDA	Stock	4.3331	4.3525	4.3282	4.3488	25273800.0
2019-07-23 13:00:00	NVDA	Stock	4.349	4.3645	4.3386	4.3604	25122840.0
2019-07-23 14:00:00	NVDA	Stock	4.3605	4.3843	4.3578	4.3655	48694080.0
2019-07-23 15:00:00	NVDA	Stock	4.3661	4.3935	4.3618	4.3928	59550960.0
2019-07-23 16:00:00	NVDA	Stock	4.3915	4.4619	4.3888	4.43	20022320.0
2019-07-23 17:00:00	NVDA	Stock	4.4338	4.4635	4.43	4.4545	1488280.0
2019-07-23 18:00:00	NVDA	Stock	4.4513	4.4562	4.45	4.4518	610200.0
2019-07-23 19:00:00	NVDA	Stock	4.4525	4.4622	4.4508	4.4622	672680.0
2019-07-23 05:00:00	AMZN	Stock	99.69	99.69	99.676	99.676	5840.0
2019-07-23 07:00:00	AMZN	Stock	99.755	99.845	99.6755	99.7	102120.0

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

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