PREVIEW / stock_1hour / 2021-02-01

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-02-01.parquet
  size:    1.5 MB
  rows:    69,033
  symbols: 2,748

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
2021-02-01 04:00:00	AAPL	Stock	133.52	135.0	133.51	134.8	140767.0
2021-02-01 05:00:00	AAPL	Stock	134.82	134.9	134.05	134.31	90530.0
2021-02-01 06:00:00	AAPL	Stock	134.32	134.92	134.01	134.45	52680.0
2021-02-01 07:00:00	AAPL	Stock	134.45	134.53	133.5	133.91	654563.0
2021-02-01 08:00:00	AAPL	Stock	133.91	134.36	133.52	133.94	814866.0
2021-02-01 09:00:00	AAPL	Stock	133.94	134.8	130.93	132.3	16356838.0
2021-02-01 10:00:00	AAPL	Stock	132.27	133.84	131.2	132.97	15654661.0
2021-02-01 11:00:00	AAPL	Stock	132.961	134.43	132.29	133.77	12004117.0
2021-02-01 12:00:00	AAPL	Stock	133.77	134.95	133.76	134.82	10190430.0
2021-02-01 13:00:00	AAPL	Stock	134.83	135.38	134.27	134.738	9825981.0
2021-02-01 14:00:00	AAPL	Stock	134.74	134.775	133.88	134.23	7642541.0
2021-02-01 15:00:00	AAPL	Stock	134.23	134.84	134.04	134.1	12275707.0
2021-02-01 16:00:00	AAPL	Stock	134.14	134.22	133.67	134.0	7346381.0
2021-02-01 17:00:00	AAPL	Stock	134.0	134.15	133.98	134.12	136726.0
2021-02-01 18:00:00	AAPL	Stock	134.12	134.49	134.11	134.31	128096.0
2021-02-01 19:00:00	AAPL	Stock	134.31	134.31	133.95	134.05	133774.0
2021-02-01 04:00:00	MSFT	Stock	234.5	234.88	233.8	234.44	69576.0
2021-02-01 05:00:00	MSFT	Stock	234.53	234.67	234.33	234.45	40466.0
2021-02-01 06:00:00	MSFT	Stock	234.53	235.1	234.43	234.95	78661.0
2021-02-01 07:00:00	MSFT	Stock	235.0	235.06	234.1	234.42	114524.0
2021-02-01 08:00:00	MSFT	Stock	234.62	235.08	231.39	235.0	80715.0
2021-02-01 09:00:00	MSFT	Stock	235.07	235.65	232.43	233.74	3242267.0
2021-02-01 10:00:00	MSFT	Stock	233.66	237.6	233.04	236.74	3724519.0
2021-02-01 11:00:00	MSFT	Stock	236.75	240.28	235.95	239.88	3925733.0
2021-02-01 12:00:00	MSFT	Stock	239.88	242.5	239.88	241.25	3893478.0
2021-02-01 13:00:00	MSFT	Stock	241.27	241.81	240.57	241.225	1866788.0
2021-02-01 14:00:00	MSFT	Stock	241.22	241.68	240.24	240.71	1790951.0
2021-02-01 15:00:00	MSFT	Stock	240.73	241.4	239.43	239.59	3620630.0
2021-02-01 16:00:00	MSFT	Stock	239.65	239.89	239.31	239.54	2962480.0
2021-02-01 17:00:00	MSFT	Stock	239.65	239.76	239.48	239.75	13680.0
2021-02-01 18:00:00	MSFT	Stock	239.8	240.44	239.66	240.44	10719.0
2021-02-01 19:00:00	MSFT	Stock	240.26	240.26	240.0	240.0	11868.0
2021-02-01 04:00:00	NVDA	Stock	13.125	13.125	13.125	13.125	12120.0
2021-02-01 05:00:00	NVDA	Stock	13.125	13.125	13.075	13.075	102640.0
2021-02-01 06:00:00	NVDA	Stock	13.0528	13.1248	13.0528	13.0875	38320.0
2021-02-01 07:00:00	NVDA	Stock	13.0945	13.1075	13.0637	13.0875	664840.0
2021-02-01 08:00:00	NVDA	Stock	13.0705	13.125	13.0705	13.125	828480.0
2021-02-01 09:00:00	NVDA	Stock	13.123	13.1387	12.9028	12.9783	26130480.0
2021-02-01 10:00:00	NVDA	Stock	12.9744	13.0465	12.92	12.9722	16738720.0
2021-02-01 11:00:00	NVDA	Stock	12.9653	13.1849	12.9173	13.1178	16915480.0
2021-02-01 12:00:00	NVDA	Stock	13.121	13.2248	13.1184	13.2235	14816160.0
2021-02-01 13:00:00	NVDA	Stock	13.2248	13.2708	13.1678	13.2435	23378440.0
2021-02-01 14:00:00	NVDA	Stock	13.2485	13.2485	13.172	13.1925	11963200.0
2021-02-01 15:00:00	NVDA	Stock	13.1962	13.2625	13.1835	13.237	30627080.0
2021-02-01 16:00:00	NVDA	Stock	13.237	13.237	13.2188	13.2188	21116520.0
2021-02-01 17:00:00	NVDA	Stock	13.2188	13.2225	13.2133	13.2212	47520.0
2021-02-01 18:00:00	NVDA	Stock	13.225	13.275	13.225	13.275	419920.0
2021-02-01 19:00:00	NVDA	Stock	13.267	13.275	13.2445	13.275	205240.0
2021-02-01 04:00:00	AMZN	Stock	161.7615	162.9	161.7615	162.65	28980.0
2021-02-01 06:00:00	AMZN	Stock	162.65	162.65	162.35	162.35	5080.0

> showing 50 of 69,033 rows — these rows as CSV

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