PREVIEW / stock_1hour / 2020-12-23

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-12-23.parquet
  size:    1.4 MB
  rows:    65,346
  symbols: 2,682

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-12-23 04:00:00	AAPL	Stock	131.75	132.68	131.66	132.67	54609.0
2020-12-23 05:00:00	AAPL	Stock	132.65	132.75	132.41	132.6	20251.0
2020-12-23 06:00:00	AAPL	Stock	132.6	132.6	131.65	131.8	34849.0
2020-12-23 07:00:00	AAPL	Stock	131.82	132.189	131.16	132.189	405635.0
2020-12-23 08:00:00	AAPL	Stock	131.42	132.59	131.16	132.28	762363.0
2020-12-23 09:00:00	AAPL	Stock	132.28	132.43	130.78	132.15	15262439.0
2020-12-23 10:00:00	AAPL	Stock	132.15	132.2	131.162	131.44	11964995.0
2020-12-23 11:00:00	AAPL	Stock	131.43	131.83	131.21	131.56	8289442.0
2020-12-23 12:00:00	AAPL	Stock	131.55	132.12	131.5	131.955	7375829.0
2020-12-23 13:00:00	AAPL	Stock	131.955	132.26	131.84	132.06	5596078.0
2020-12-23 14:00:00	AAPL	Stock	132.05	132.07	131.56	131.735	5436996.0
2020-12-23 15:00:00	AAPL	Stock	131.735	131.88	130.92	130.96	11852762.0
2020-12-23 16:00:00	AAPL	Stock	130.95	131.06	130.78	130.92	10506525.0
2020-12-23 17:00:00	AAPL	Stock	130.94	131.16	130.9	131.14	134257.0
2020-12-23 18:00:00	AAPL	Stock	131.07	131.14	130.88	130.92	72755.0
2020-12-23 19:00:00	AAPL	Stock	130.9	131.05	130.89	131.05	79677.0
2020-12-23 04:00:00	MSFT	Stock	224.0	224.7	224.0	224.7	1820.0
2020-12-23 05:00:00	MSFT	Stock	224.7	224.84	224.57	224.8	2116.0
2020-12-23 06:00:00	MSFT	Stock	224.68	224.68	224.4	224.4	684.0
2020-12-23 07:00:00	MSFT	Stock	224.39	224.39	223.9	224.02	10848.0
2020-12-23 08:00:00	MSFT	Stock	224.145	224.25	223.49	223.8	28745.0
2020-12-23 09:00:00	MSFT	Stock	223.8	223.9	222.08	222.94	1937809.0
2020-12-23 10:00:00	MSFT	Stock	222.94	223.36	222.15	222.46	1940338.0
2020-12-23 11:00:00	MSFT	Stock	222.46	222.73	221.95	222.5	1467659.0
2020-12-23 12:00:00	MSFT	Stock	222.54	223.09	222.34	222.84	1059086.0
2020-12-23 13:00:00	MSFT	Stock	222.83	223.36	222.722	222.99	1144213.0
2020-12-23 14:00:00	MSFT	Stock	222.99	223.0	222.31	222.44	1124962.0
2020-12-23 15:00:00	MSFT	Stock	222.42	222.5	220.8	221.02	3041771.0
2020-12-23 16:00:00	MSFT	Stock	221.02	221.47	220.68	221.22	2904972.0
2020-12-23 17:00:00	MSFT	Stock	221.38	221.4	221.02	221.36	73307.0
2020-12-23 18:00:00	MSFT	Stock	221.36	221.44	221.24	221.3	1651.0
2020-12-23 19:00:00	MSFT	Stock	221.32	221.44	221.25	221.33	1268.0
2020-12-23 06:00:00	NVDA	Stock	13.225	13.2493	13.225	13.228	20520.0
2020-12-23 07:00:00	NVDA	Stock	13.241	13.241	13.2132	13.2132	162080.0
2020-12-23 08:00:00	NVDA	Stock	13.23	13.275	13.2245	13.2609	545520.0
2020-12-23 09:00:00	NVDA	Stock	13.26	13.275	13.0405	13.1188	28037600.0
2020-12-23 10:00:00	NVDA	Stock	13.1213	13.1669	13.0898	13.1406	17837320.0
2020-12-23 11:00:00	NVDA	Stock	13.137	13.1705	13.1049	13.13	10032560.0
2020-12-23 12:00:00	NVDA	Stock	13.1303	13.1352	13.0713	13.1105	17705520.0
2020-12-23 13:00:00	NVDA	Stock	13.1093	13.1572	13.1068	13.1382	8995560.0
2020-12-23 14:00:00	NVDA	Stock	13.1385	13.159	13.1194	13.1309	8173120.0
2020-12-23 15:00:00	NVDA	Stock	13.1295	13.1378	13.005	13.005	30841840.0
2020-12-23 16:00:00	NVDA	Stock	13.0093	13.0178	13.0	13.008	22510360.0
2020-12-23 17:00:00	NVDA	Stock	13.0072	13.024	13.0063	13.024	253480.0
2020-12-23 18:00:00	NVDA	Stock	13.02	13.025	13.01	13.0145	170640.0
2020-12-23 19:00:00	NVDA	Stock	13.0198	13.0198	13.0098	13.0175	96800.0
2020-12-23 06:00:00	AMZN	Stock	160.297	160.2975	160.297	160.2975	4520.0
2020-12-23 07:00:00	AMZN	Stock	160.2445	160.25	160.15	160.15	8000.0
2020-12-23 08:00:00	AMZN	Stock	160.25	160.2505	160.1525	160.1525	47080.0
2020-12-23 09:00:00	AMZN	Stock	160.15	160.275	159.2085	160.0055	6104440.0

> showing 50 of 65,346 rows — these rows as CSV

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