PREVIEW / stock_1hour / 2022-01-26

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-01-26.parquet
  size:    1.4 MB
  rows:    65,101
  symbols: 2,637

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
2022-01-26 04:00:00	AAPL	Stock	161.53	163.41	161.53	162.94	65102.0
2022-01-26 05:00:00	AAPL	Stock	163.0	163.29	162.59	162.86	34421.0
2022-01-26 06:00:00	AAPL	Stock	162.89	163.51	162.83	163.46	34936.0
2022-01-26 07:00:00	AAPL	Stock	163.29	163.43	162.45	163.34	237439.0
2022-01-26 08:00:00	AAPL	Stock	162.8999	163.98	159.381	163.3	807066.0
2022-01-26 09:00:00	AAPL	Stock	163.3	163.9	161.59	162.1501	10575216.0
2022-01-26 10:00:00	AAPL	Stock	162.14	162.95	161.36	162.19	11839632.0
2022-01-26 11:00:00	AAPL	Stock	162.2	163.13	161.77	162.8371	7225552.0
2022-01-26 12:00:00	AAPL	Stock	162.8454	163.5499	162.72	163.2434	6336534.0
2022-01-26 13:00:00	AAPL	Stock	163.25	163.275	162.57	162.78	6610323.0
2022-01-26 14:00:00	AAPL	Stock	162.78	164.3894	159.08	160.5201	17396934.0
2022-01-26 15:00:00	AAPL	Stock	160.54	160.54	157.82	159.75	19866549.0
2022-01-26 16:00:00	AAPL	Stock	159.65	160.42	159.0	160.27	8634069.0
2022-01-26 17:00:00	AAPL	Stock	160.25	161.47	160.1	161.0	134047.0
2022-01-26 18:00:00	AAPL	Stock	161.03	161.89	160.77	161.66	171073.0
2022-01-26 19:00:00	AAPL	Stock	161.64	161.67	160.35	160.4999	133388.0
2022-01-26 04:00:00	MSFT	Stock	295.5	299.0	295.1	298.34	96871.0
2022-01-26 05:00:00	MSFT	Stock	298.1	300.87	297.6	300.0	75004.0
2022-01-26 06:00:00	MSFT	Stock	299.97	300.51	298.8	299.5	59827.0
2022-01-26 07:00:00	MSFT	Stock	299.5	300.92	298.12	300.52	430153.0
2022-01-26 08:00:00	MSFT	Stock	299.7179	304.87	298.1	304.75	1078490.0
2022-01-26 09:00:00	MSFT	Stock	304.75	308.75	300.33	301.3	12545017.0
2022-01-26 10:00:00	MSFT	Stock	301.29	303.19	298.54	300.51	10826517.0
2022-01-26 11:00:00	MSFT	Stock	300.48	302.29	299.0	300.08	6631864.0
2022-01-26 12:00:00	MSFT	Stock	300.19	304.24	300.17	303.2095	4652668.0
2022-01-26 13:00:00	MSFT	Stock	303.25	303.32	301.15	301.839	3343667.0
2022-01-26 14:00:00	MSFT	Stock	301.74	306.63	296.18	298.74	10708283.0
2022-01-26 15:00:00	MSFT	Stock	298.72	299.075	293.03	296.94	12083848.0
2022-01-26 16:00:00	MSFT	Stock	296.71	297.25	295.3	296.89	4879532.0
2022-01-26 17:00:00	MSFT	Stock	297.0	299.0	296.8	298.0	56524.0
2022-01-26 18:00:00	MSFT	Stock	298.13	299.69	298.0	299.43	37201.0
2022-01-26 19:00:00	MSFT	Stock	299.55	299.63	296.9	296.9	46828.0
2022-01-26 04:00:00	NVDA	Stock	22.831	23.275	22.742	23.129	670080.0
2022-01-26 05:00:00	NVDA	Stock	23.117	23.29	23.034	23.22	198730.0
2022-01-26 06:00:00	NVDA	Stock	23.249	23.298	23.12	23.12	453230.0
2022-01-26 07:00:00	NVDA	Stock	23.117	23.162	22.912	23.056	1606500.0
2022-01-26 08:00:00	NVDA	Stock	22.98	23.374	22.93	23.325	2832270.0
2022-01-26 09:00:00	NVDA	Stock	23.316	23.524	22.8	23.199	59988390.0
2022-01-26 10:00:00	NVDA	Stock	23.202	23.652	23.057	23.185	98048110.0
2022-01-26 11:00:00	NVDA	Stock	23.181	23.327	22.966	23.228	49746950.0
2022-01-26 12:00:00	NVDA	Stock	23.236	23.82	23.1883	23.7639	54216350.0
2022-01-26 13:00:00	NVDA	Stock	23.769	23.775	23.533	23.585	39133110.0
2022-01-26 14:00:00	NVDA	Stock	23.579	24.057	22.925	23.093	114792910.0
2022-01-26 15:00:00	NVDA	Stock	23.076	23.233	22.3	22.772	104924520.0
2022-01-26 16:00:00	NVDA	Stock	22.777	22.985	22.6	22.965	22749050.0
2022-01-26 17:00:00	NVDA	Stock	22.97	23.15	22.934	23.089	822410.0
2022-01-26 18:00:00	NVDA	Stock	23.085	23.3	23.044	23.23	667970.0
2022-01-26 19:00:00	NVDA	Stock	23.2	23.224	23.054	23.1	730930.0
2022-01-26 04:00:00	AMZN	Stock	142.2	142.35	142.2	142.35	34500.0
2022-01-26 06:00:00	AMZN	Stock	143.8	143.8	143.5	143.75	20820.0

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

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