PREVIEW / stock_1hour / 2020-11-25

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-11-25.parquet
  size:    1.3 MB
  rows:    60,992
  symbols: 2,594

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
2020-11-25 04:00:00	AAPL	Stock	115.54	115.59	115.0	115.59	20634.0
2020-11-25 05:00:00	AAPL	Stock	115.56	115.66	115.11	115.25	18425.0
2020-11-25 06:00:00	AAPL	Stock	115.27	115.68	115.19	115.42	25910.0
2020-11-25 07:00:00	AAPL	Stock	115.5	115.67	115.16	115.23	210439.0
2020-11-25 08:00:00	AAPL	Stock	115.23	115.64	114.9	115.2	494673.0
2020-11-25 09:00:00	AAPL	Stock	115.2	116.61	115.04	116.35	14263585.0
2020-11-25 10:00:00	AAPL	Stock	116.354	116.53	115.53	116.5	11841848.0
2020-11-25 11:00:00	AAPL	Stock	116.492	116.75	115.89	116.02	8887202.0
2020-11-25 12:00:00	AAPL	Stock	116.03	116.33	115.7	116.21	5781508.0
2020-11-25 13:00:00	AAPL	Stock	116.215	116.34	115.87	115.99	4757999.0
2020-11-25 14:00:00	AAPL	Stock	115.986	116.139	115.731	116.122	5471142.0
2020-11-25 15:00:00	AAPL	Stock	116.12	116.47	115.95	116.02	10274800.0
2020-11-25 16:00:00	AAPL	Stock	116.03	116.41	116.01	116.21	6354303.0
2020-11-25 17:00:00	AAPL	Stock	116.2	116.21	116.11	116.13	41710.0
2020-11-25 18:00:00	AAPL	Stock	116.13	116.28	116.13	116.28	60723.0
2020-11-25 19:00:00	AAPL	Stock	116.28	116.3	116.19	116.27	60058.0
2020-11-25 04:00:00	MSFT	Stock	214.19	214.2	214.16	214.16	3086.0
2020-11-25 05:00:00	MSFT	Stock	214.25	214.55	214.25	214.47	5516.0
2020-11-25 06:00:00	MSFT	Stock	214.78	214.97	214.32	214.75	4410.0
2020-11-25 07:00:00	MSFT	Stock	214.6	214.98	214.51	214.69	13939.0
2020-11-25 08:00:00	MSFT	Stock	214.75	215.2	213.33	214.715	59554.0
2020-11-25 09:00:00	MSFT	Stock	214.71	215.5	213.5	213.93	2923480.0
2020-11-25 10:00:00	MSFT	Stock	213.91	214.11	213.13	213.67	2230892.0
2020-11-25 11:00:00	MSFT	Stock	213.675	213.96	212.46	212.83	2219343.0
2020-11-25 12:00:00	MSFT	Stock	212.82	213.68	212.7	213.59	1248196.0
2020-11-25 13:00:00	MSFT	Stock	213.59	213.99	213.104	213.821	1162987.0
2020-11-25 14:00:00	MSFT	Stock	213.81	214.112	213.3	213.97	1244116.0
2020-11-25 15:00:00	MSFT	Stock	213.97	214.5	213.44	213.75	2903029.0
2020-11-25 16:00:00	MSFT	Stock	213.75	214.3	213.74	214.1	2800890.0
2020-11-25 17:00:00	MSFT	Stock	214.01	214.16	214.0	214.1	6129.0
2020-11-25 18:00:00	MSFT	Stock	214.08	214.43	214.08	214.42	3422.0
2020-11-25 19:00:00	MSFT	Stock	214.3	214.3	213.9	213.9	17804.0
2020-11-25 04:00:00	NVDA	Stock	12.89	12.89	12.89	12.89	51120.0
2020-11-25 05:00:00	NVDA	Stock	12.9325	12.9325	12.9325	12.9325	4000.0
2020-11-25 07:00:00	NVDA	Stock	12.9755	13.0258	12.9755	12.9975	359960.0
2020-11-25 08:00:00	NVDA	Stock	12.977	13.038	12.9757	13.0225	2140960.0
2020-11-25 09:00:00	NVDA	Stock	13.0225	13.1978	13.013	13.1945	49623200.0
2020-11-25 10:00:00	NVDA	Stock	13.1945	13.21	13.0788	13.1621	27507040.0
2020-11-25 11:00:00	NVDA	Stock	13.159	13.2488	13.1225	13.1375	31196560.0
2020-11-25 12:00:00	NVDA	Stock	13.1362	13.2222	13.11	13.2078	15839960.0
2020-11-25 13:00:00	NVDA	Stock	13.2091	13.2625	13.1902	13.2438	23160280.0
2020-11-25 14:00:00	NVDA	Stock	13.2455	13.2645	13.215	13.2625	16363560.0
2020-11-25 15:00:00	NVDA	Stock	13.263	13.2694	13.2052	13.235	29318720.0
2020-11-25 16:00:00	NVDA	Stock	13.235	13.2493	13.2236	13.244	12895240.0
2020-11-25 17:00:00	NVDA	Stock	13.2475	13.25	13.2348	13.24	340720.0
2020-11-25 18:00:00	NVDA	Stock	13.2498	13.2498	13.2348	13.2375	173720.0
2020-11-25 19:00:00	NVDA	Stock	13.2375	13.242	13.23	13.23	116240.0
2020-11-25 04:00:00	AMZN	Stock	156.35	156.35	156.3	156.3	6340.0
2020-11-25 05:00:00	AMZN	Stock	156.25	156.25	156.25	156.25	3620.0
2020-11-25 06:00:00	AMZN	Stock	156.2	156.4	156.2	156.4	4000.0

> showing 50 of 60,992 rows — these rows as CSV

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