PREVIEW / stock_1hour / 2020-11-23

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-11-23.parquet
  size:    1.4 MB
  rows:    62,497
  symbols: 2,589

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-23 04:00:00	AAPL	Stock	117.31	117.91	117.31	117.67	21716.0
2020-11-23 05:00:00	AAPL	Stock	117.67	117.7	117.5	117.5	12040.0
2020-11-23 06:00:00	AAPL	Stock	117.48	117.66	117.3	117.45	19713.0
2020-11-23 07:00:00	AAPL	Stock	117.6	117.7	117.45	117.62	215040.0
2020-11-23 08:00:00	AAPL	Stock	117.47	117.65	117.1	117.39	444512.0
2020-11-23 09:00:00	AAPL	Stock	117.352	117.62	116.73	117.01	13317503.0
2020-11-23 10:00:00	AAPL	Stock	117.01	117.07	115.1	115.43	19046216.0
2020-11-23 11:00:00	AAPL	Stock	115.435	115.445	113.8	114.49	18744330.0
2020-11-23 12:00:00	AAPL	Stock	114.5	115.329	114.27	115.3	10088557.0
2020-11-23 13:00:00	AAPL	Stock	115.291	115.36	114.595	114.615	8365973.0
2020-11-23 14:00:00	AAPL	Stock	114.616	114.68	114.0	114.2	13434035.0
2020-11-23 15:00:00	AAPL	Stock	114.205	114.47	113.75	113.88	19939765.0
2020-11-23 16:00:00	AAPL	Stock	113.85	114.14	113.85	114.05	6297513.0
2020-11-23 17:00:00	AAPL	Stock	114.05	114.07	113.85	114.0	252892.0
2020-11-23 18:00:00	AAPL	Stock	114.0	114.9	113.99	114.45	544749.0
2020-11-23 19:00:00	AAPL	Stock	114.41	114.6	114.35	114.6	224532.0
2020-11-23 04:00:00	MSFT	Stock	211.5	211.5	211.23	211.29	2019.0
2020-11-23 05:00:00	MSFT	Stock	211.19	211.27	211.12	211.13	3746.0
2020-11-23 06:00:00	MSFT	Stock	211.13	211.13	210.6	210.6	6511.0
2020-11-23 07:00:00	MSFT	Stock	210.7	210.95	210.52	210.9	34205.0
2020-11-23 08:00:00	MSFT	Stock	210.581	211.0	210.39	210.7	57891.0
2020-11-23 09:00:00	MSFT	Stock	210.65	212.29	210.65	211.66	1901516.0
2020-11-23 10:00:00	MSFT	Stock	211.66	211.84	209.26	210.4	3016160.0
2020-11-23 11:00:00	MSFT	Stock	210.385	210.44	208.16	208.6	2821782.0
2020-11-23 12:00:00	MSFT	Stock	208.58	209.66	208.31	209.63	1399779.0
2020-11-23 13:00:00	MSFT	Stock	209.66	210.08	209.6	209.635	1394522.0
2020-11-23 14:00:00	MSFT	Stock	209.63	210.22	209.16	210.21	1437172.0
2020-11-23 15:00:00	MSFT	Stock	210.22	210.712	209.56	210.09	3048675.0
2020-11-23 16:00:00	MSFT	Stock	210.11	210.55	210.0	210.16	6148824.0
2020-11-23 17:00:00	MSFT	Stock	210.5	210.5	210.255	210.4	4252.0
2020-11-23 18:00:00	MSFT	Stock	210.5	211.0	210.36	210.85	19847.0
2020-11-23 19:00:00	MSFT	Stock	210.78	211.0	210.75	211.0	19851.0
2020-11-23 04:00:00	NVDA	Stock	13.125	13.2438	13.0878	13.1752	157440.0
2020-11-23 05:00:00	NVDA	Stock	13.175	13.1788	13.175	13.1788	32560.0
2020-11-23 06:00:00	NVDA	Stock	13.2032	13.2032	13.2032	13.2032	4000.0
2020-11-23 07:00:00	NVDA	Stock	13.2108	13.2125	13.1328	13.1328	742800.0
2020-11-23 08:00:00	NVDA	Stock	13.1425	13.2	13.1133	13.1325	1597080.0
2020-11-23 09:00:00	NVDA	Stock	13.13	13.3825	13.1282	13.2852	53504360.0
2020-11-23 10:00:00	NVDA	Stock	13.287	13.3118	13.0878	13.1431	60498640.0
2020-11-23 11:00:00	NVDA	Stock	13.1438	13.158	13.0155	13.0988	36433320.0
2020-11-23 12:00:00	NVDA	Stock	13.0915	13.13	13.0565	13.124	23266040.0
2020-11-23 13:00:00	NVDA	Stock	13.1258	13.2125	13.1138	13.1299	29944200.0
2020-11-23 14:00:00	NVDA	Stock	13.1297	13.175	13.075	13.1602	18163080.0
2020-11-23 15:00:00	NVDA	Stock	13.1614	13.1975	13.1252	13.13	34491000.0
2020-11-23 16:00:00	NVDA	Stock	13.14	13.15	13.125	13.14	18866640.0
2020-11-23 17:00:00	NVDA	Stock	13.14	13.1495	13.135	13.135	221880.0
2020-11-23 18:00:00	NVDA	Stock	13.1418	13.182	13.1418	13.1798	335000.0
2020-11-23 19:00:00	NVDA	Stock	13.1792	13.1972	13.1778	13.1932	263280.0
2020-11-23 05:00:00	AMZN	Stock	155.7	155.7	155.7	155.7	12640.0
2020-11-23 06:00:00	AMZN	Stock	155.65	155.65	155.65	155.65	2000.0

> showing 50 of 62,497 rows — these rows as CSV

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