PREVIEW / stock_1hour / 2021-05-28

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-05-28.parquet
  size:    1.4 MB
  rows:    65,206
  symbols: 2,967

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-05-28 04:00:00	AAPL	Stock	126.04	126.18	126.0	126.09	6989.0
2021-05-28 05:00:00	AAPL	Stock	126.12	126.25	126.07	126.1	8385.0
2021-05-28 06:00:00	AAPL	Stock	126.17	126.28	126.02	126.28	15206.0
2021-05-28 07:00:00	AAPL	Stock	126.17	126.28	125.65	125.72	218677.0
2021-05-28 08:00:00	AAPL	Stock	126.0401	126.19	125.36	125.58	588971.0
2021-05-28 09:00:00	AAPL	Stock	125.58	125.8	124.58	125.46	11253264.0
2021-05-28 10:00:00	AAPL	Stock	125.46	125.71	125.13	125.17	8979205.0
2021-05-28 11:00:00	AAPL	Stock	125.18	125.23	124.88	125.195	6815058.0
2021-05-28 12:00:00	AAPL	Stock	125.195	125.41	125.14	125.29	5096543.0
2021-05-28 13:00:00	AAPL	Stock	125.3	125.3799	124.735	124.87	7197951.0
2021-05-28 14:00:00	AAPL	Stock	124.88	125.14	124.8118	125.0782	4720368.0
2021-05-28 15:00:00	AAPL	Stock	125.075	125.17	124.55	124.61	11996554.0
2021-05-28 16:00:00	AAPL	Stock	124.61	124.82	124.52	124.57	6908960.0
2021-05-28 17:00:00	AAPL	Stock	124.58	124.67	124.57	124.65	82625.0
2021-05-28 18:00:00	AAPL	Stock	124.6501	124.7	124.65	124.67	36133.0
2021-05-28 19:00:00	AAPL	Stock	124.65	124.67	124.61	124.61	33840.0
2021-05-28 04:00:00	MSFT	Stock	250.5	250.5	250.18	250.18	1819.0
2021-05-28 05:00:00	MSFT	Stock	250.27	250.3	250.27	250.3	1164.0
2021-05-28 06:00:00	MSFT	Stock	250.6	250.71	250.6	250.6	2659.0
2021-05-28 07:00:00	MSFT	Stock	250.53	250.86	250.49	250.71	5061.0
2021-05-28 08:00:00	MSFT	Stock	250.6	250.8199	248.687	250.43	20310.0
2021-05-28 09:00:00	MSFT	Stock	250.44	252.07	249.31	251.21	1918907.0
2021-05-28 10:00:00	MSFT	Stock	251.19	251.4	250.43	251.0	1415809.0
2021-05-28 11:00:00	MSFT	Stock	251.02	251.76	250.81	251.67	1394063.0
2021-05-28 12:00:00	MSFT	Stock	251.68	252.08	251.26	251.54	1186361.0
2021-05-28 13:00:00	MSFT	Stock	251.55	251.6697	250.6	250.81	1242557.0
2021-05-28 14:00:00	MSFT	Stock	250.82	250.97	250.5	250.81	998021.0
2021-05-28 15:00:00	MSFT	Stock	250.8	250.81	249.56	249.94	3204010.0
2021-05-28 16:00:00	MSFT	Stock	249.68	250.5612	249.68	249.96	3529282.0
2021-05-28 17:00:00	MSFT	Stock	249.97	250.01	249.96	250.0	5529.0
2021-05-28 18:00:00	MSFT	Stock	249.8	250.03	249.77	249.99	4026.0
2021-05-28 19:00:00	MSFT	Stock	249.99	250.0499	249.95	249.95	879.0
2021-05-28 04:00:00	NVDA	Stock	15.535	15.5505	15.5258	15.5262	58720.0
2021-05-28 05:00:00	NVDA	Stock	15.525	15.525	15.525	15.525	12800.0
2021-05-28 06:00:00	NVDA	Stock	15.525	15.525	15.506	15.5093	129440.0
2021-05-28 07:00:00	NVDA	Stock	15.5188	15.5498	15.5188	15.5248	683880.0
2021-05-28 08:00:00	NVDA	Stock	15.5248	15.5492	15.4788	15.488	1468760.0
2021-05-28 09:00:00	NVDA	Stock	15.4875	15.9632	15.4752	15.9572	65014560.0
2021-05-28 10:00:00	NVDA	Stock	15.9568	16.0838	15.9128	15.9974	84996040.0
2021-05-28 11:00:00	NVDA	Stock	15.9972	16.1562	15.9665	16.103	54240160.0
2021-05-28 12:00:00	NVDA	Stock	16.104	16.2215	16.1004	16.1854	37255720.0
2021-05-28 13:00:00	NVDA	Stock	16.183	16.2393	16.1463	16.1715	39056360.0
2021-05-28 14:00:00	NVDA	Stock	16.1748	16.25	16.1565	16.2435	35554800.0
2021-05-28 15:00:00	NVDA	Stock	16.2438	16.2775	16.1952	16.245	81228440.0
2021-05-28 16:00:00	NVDA	Stock	16.2445	16.2675	16.2445	16.2525	25769440.0
2021-05-28 17:00:00	NVDA	Stock	16.2515	16.2562	16.2448	16.245	331360.0
2021-05-28 18:00:00	NVDA	Stock	16.2475	16.2498	16.2303	16.2303	263960.0
2021-05-28 19:00:00	NVDA	Stock	16.246	16.2625	16.246	16.262	405840.0
2021-05-28 07:00:00	AMZN	Stock	162.397	162.397	162.25	162.25	12920.0
2021-05-28 08:00:00	AMZN	Stock	162.4	162.445	162.02	162.1	45200.0

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

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