PREVIEW / stock_1hour / 2021-09-23

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-09-23.parquet
  size:    1.4 MB
  rows:    64,666
  symbols: 2,726

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-09-23 04:00:00	AAPL	Stock	146.71	147.25	146.71	147.21	34543.0
2021-09-23 05:00:00	AAPL	Stock	147.21	147.68	147.12	147.55	44680.0
2021-09-23 06:00:00	AAPL	Stock	147.54	147.58	146.92	147.2	78715.0
2021-09-23 07:00:00	AAPL	Stock	147.2	147.54	147.0	147.27	229609.0
2021-09-23 08:00:00	AAPL	Stock	147.0299	147.53	146.63	146.77	579172.0
2021-09-23 09:00:00	AAPL	Stock	146.76	146.85	145.64	146.265	10451075.0
2021-09-23 10:00:00	AAPL	Stock	146.275	147.08	146.2201	146.94	9527637.0
2021-09-23 11:00:00	AAPL	Stock	146.955	146.985	146.36	146.9199	6723516.0
2021-09-23 12:00:00	AAPL	Stock	146.91	146.94	146.51	146.59	5541967.0
2021-09-23 13:00:00	AAPL	Stock	146.59	147.04	146.54	147.02	4680327.0
2021-09-23 14:00:00	AAPL	Stock	147.0189	147.0271	146.71	146.95	4364795.0
2021-09-23 15:00:00	AAPL	Stock	146.9529	146.99	146.7	146.75	9000157.0
2021-09-23 16:00:00	AAPL	Stock	146.75	146.92	146.63	146.74	5672436.0
2021-09-23 17:00:00	AAPL	Stock	146.73	148.63	146.7	146.82	34745.0
2021-09-23 18:00:00	AAPL	Stock	146.8	146.85	146.77	146.84	29403.0
2021-09-23 19:00:00	AAPL	Stock	146.82	146.9	146.82	146.9	62449.0
2021-09-23 04:00:00	MSFT	Stock	300.23	300.8	300.01	300.79	2666.0
2021-09-23 05:00:00	MSFT	Stock	300.9	301.5	300.89	301.0	8857.0
2021-09-23 06:00:00	MSFT	Stock	301.02	301.45	300.11	300.32	8100.0
2021-09-23 07:00:00	MSFT	Stock	300.43	300.48	299.55	299.77	33396.0
2021-09-23 08:00:00	MSFT	Stock	300.3898	300.47	298.98	299.0	27222.0
2021-09-23 09:00:00	MSFT	Stock	299.07	299.63	297.5339	299.29	1954214.0
2021-09-23 10:00:00	MSFT	Stock	299.295	300.9	299.27	300.62	2115717.0
2021-09-23 11:00:00	MSFT	Stock	300.64	300.6784	299.3201	300.165	1410548.0
2021-09-23 12:00:00	MSFT	Stock	300.18	300.205	299.35	299.65	1020237.0
2021-09-23 13:00:00	MSFT	Stock	299.66	300.36	299.495	300.14	991182.0
2021-09-23 14:00:00	MSFT	Stock	300.15	300.38	299.69	300.33	1021200.0
2021-09-23 15:00:00	MSFT	Stock	300.34	300.4099	299.48	299.54	2342418.0
2021-09-23 16:00:00	MSFT	Stock	299.56	299.71	299.39	299.4	2886616.0
2021-09-23 17:00:00	MSFT	Stock	299.5	299.6	299.4	299.6	1000.0
2021-09-23 18:00:00	MSFT	Stock	299.6	299.8	299.6	299.8	2024.0
2021-09-23 19:00:00	MSFT	Stock	299.8	299.98	299.79	299.87	3734.0
2021-09-23 04:00:00	NVDA	Stock	22.249	22.249	22.196	22.2	44750.0
2021-09-23 05:00:00	NVDA	Stock	22.2	22.238	22.18	22.235	127950.0
2021-09-23 06:00:00	NVDA	Stock	22.24	22.249	22.102	22.128	83850.0
2021-09-23 07:00:00	NVDA	Stock	22.121	22.198	22.114	22.127	395800.0
2021-09-23 08:00:00	NVDA	Stock	22.177	22.23	22.096	22.129	830720.0
2021-09-23 09:00:00	NVDA	Stock	22.11	22.2629	21.89	22.226	36934600.0
2021-09-23 10:00:00	NVDA	Stock	22.226	22.385	22.216	22.367	34878330.0
2021-09-23 11:00:00	NVDA	Stock	22.367	22.377	22.2371	22.368	25672420.0
2021-09-23 12:00:00	NVDA	Stock	22.368	22.446	22.282	22.431	21167120.0
2021-09-23 13:00:00	NVDA	Stock	22.431	22.524	22.4017	22.5185	17691420.0
2021-09-23 14:00:00	NVDA	Stock	22.519	22.525	22.454	22.5	15143540.0
2021-09-23 15:00:00	NVDA	Stock	22.501	22.5345	22.4635	22.482	24349850.0
2021-09-23 16:00:00	NVDA	Stock	22.482	22.507	22.482	22.482	13990800.0
2021-09-23 17:00:00	NVDA	Stock	22.483	22.483	22.46	22.479	66570.0
2021-09-23 18:00:00	NVDA	Stock	22.471	22.498	22.471	22.49	182970.0
2021-09-23 19:00:00	NVDA	Stock	22.498	22.512	22.483	22.51	136520.0
2021-09-23 04:00:00	AMZN	Stock	170.25	170.4115	170.25	170.4115	11000.0
2021-09-23 05:00:00	AMZN	Stock	170.4	170.4	170.4	170.4	6800.0

> showing 50 of 64,666 rows — these rows as CSV

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