PREVIEW / stock_1hour / 2022-03-23

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-03-23.parquet
  size:    1.4 MB
  rows:    64,286
  symbols: 2,474

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-03-23 04:00:00	AAPL	Stock	168.7	168.9	168.5	168.68	17134.0
2022-03-23 05:00:00	AAPL	Stock	168.71	168.72	168.21	168.21	11725.0
2022-03-23 06:00:00	AAPL	Stock	168.21	168.3	167.87	167.93	18159.0
2022-03-23 07:00:00	AAPL	Stock	168.0	168.2	167.77	167.95	103970.0
2022-03-23 08:00:00	AAPL	Stock	168.07	169.37	167.601	167.77	466821.0
2022-03-23 09:00:00	AAPL	Stock	167.78	169.81	167.65	169.55	11077681.0
2022-03-23 10:00:00	AAPL	Stock	169.519	170.76	169.2	170.402	13559929.0
2022-03-23 11:00:00	AAPL	Stock	170.41	171.865	170.3306	171.775	10551268.0
2022-03-23 12:00:00	AAPL	Stock	171.78	172.22	171.17	171.72	9651639.0
2022-03-23 13:00:00	AAPL	Stock	171.7116	172.64	171.69	172.325	11048932.0
2022-03-23 14:00:00	AAPL	Stock	172.33	172.4325	171.4139	171.725	8145773.0
2022-03-23 15:00:00	AAPL	Stock	171.73	171.97	170.1	170.22	12758383.0
2022-03-23 16:00:00	AAPL	Stock	170.25	170.47	170.05	170.33	8884616.0
2022-03-23 17:00:00	AAPL	Stock	170.34	170.36	170.02	170.15	84518.0
2022-03-23 18:00:00	AAPL	Stock	170.18	170.36	170.12	170.24	34179.0
2022-03-23 19:00:00	AAPL	Stock	170.35	170.69	170.32	170.69	53421.0
2022-03-23 04:00:00	MSFT	Stock	303.63	303.63	302.86	303.49	2689.0
2022-03-23 05:00:00	MSFT	Stock	303.49	303.49	302.52	302.52	1654.0
2022-03-23 06:00:00	MSFT	Stock	302.77	302.77	302.05	302.28	1527.0
2022-03-23 07:00:00	MSFT	Stock	302.33	302.85	300.96	301.28	21037.0
2022-03-23 08:00:00	MSFT	Stock	302.1675	305.76	301.21	301.49	45955.0
2022-03-23 09:00:00	MSFT	Stock	301.54	301.95	297.7201	299.745	3294676.0
2022-03-23 10:00:00	MSFT	Stock	299.715	302.58	299.24	301.07	2541854.0
2022-03-23 11:00:00	MSFT	Stock	301.11	302.26	300.89	302.22	1588652.0
2022-03-23 12:00:00	MSFT	Stock	302.21	303.23	301.36	302.18	1661867.0
2022-03-23 13:00:00	MSFT	Stock	302.16	302.429	300.551	301.33	1262362.0
2022-03-23 14:00:00	MSFT	Stock	301.3101	301.84	300.2237	300.81	1369444.0
2022-03-23 15:00:00	MSFT	Stock	300.83	301.63	299.38	299.41	2625471.0
2022-03-23 16:00:00	MSFT	Stock	299.42	299.8	299.25	299.5	4669123.0
2022-03-23 17:00:00	MSFT	Stock	299.4	299.49	299.05	299.05	13877.0
2022-03-23 18:00:00	MSFT	Stock	299.2	299.7	299.2	299.6	9569.0
2022-03-23 19:00:00	MSFT	Stock	299.6	299.94	299.57	299.85	9545.0
2022-03-23 04:00:00	NVDA	Stock	26.5	26.563	26.437	26.493	87970.0
2022-03-23 05:00:00	NVDA	Stock	26.485	26.5	26.34	26.4	70100.0
2022-03-23 06:00:00	NVDA	Stock	26.373	26.373	26.284	26.338	48550.0
2022-03-23 07:00:00	NVDA	Stock	26.355	26.355	26.122	26.15	216380.0
2022-03-23 08:00:00	NVDA	Stock	26.2997	26.632	26.072	26.125	1021700.0
2022-03-23 09:00:00	NVDA	Stock	26.125	26.175	25.633	25.6838	55096060.0
2022-03-23 10:00:00	NVDA	Stock	25.68	26.281	25.575	26.194	70661820.0
2022-03-23 11:00:00	NVDA	Stock	26.195	26.6115	26.192	26.55	53854220.0
2022-03-23 12:00:00	NVDA	Stock	26.551	26.607	26.205	26.453	43412850.0
2022-03-23 13:00:00	NVDA	Stock	26.454	26.4777	25.8	25.9385	51993620.0
2022-03-23 14:00:00	NVDA	Stock	25.939	26.064	25.712	25.8867	33923080.0
2022-03-23 15:00:00	NVDA	Stock	25.89	25.974	25.605	25.623	49695370.0
2022-03-23 16:00:00	NVDA	Stock	25.634	25.698	25.615	25.684	21848070.0
2022-03-23 17:00:00	NVDA	Stock	25.684	25.684	25.63	25.655	214810.0
2022-03-23 18:00:00	NVDA	Stock	25.653	25.844	25.653	25.784	576050.0
2022-03-23 19:00:00	NVDA	Stock	25.779	25.83	25.76	25.769	387860.0
2022-03-23 07:00:00	AMZN	Stock	164.4515	164.4515	163.9025	163.903	31560.0
2022-03-23 08:00:00	AMZN	Stock	163.984	164.1495	163.7	163.8	57760.0

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

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