PREVIEW / stock_1hour / 2023-05-16

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-05-16.parquet
  size:    1.3 MB
  rows:    59,622
  symbols: 1,685

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
2023-05-16 04:00:00	AAPL	Stock	172.59	172.67	172.14	172.19	6770.0
2023-05-16 05:00:00	AAPL	Stock	172.25	172.25	172.02	172.07	2282.0
2023-05-16 06:00:00	AAPL	Stock	172.03	172.1	171.99	172.07	11924.0
2023-05-16 07:00:00	AAPL	Stock	172.1	172.1	171.91	172.01	10754.0
2023-05-16 08:00:00	AAPL	Stock	172.15	172.18	171.63	171.71	91725.0
2023-05-16 09:00:00	AAPL	Stock	171.67	173.1383	171.33	172.62	6516401.0
2023-05-16 10:00:00	AAPL	Stock	172.62	172.7	171.88	172.28	5786330.0
2023-05-16 11:00:00	AAPL	Stock	172.29	172.35	171.83	172.22	4132252.0
2023-05-16 12:00:00	AAPL	Stock	172.225	172.51	171.97	172.18	2817066.0
2023-05-16 13:00:00	AAPL	Stock	172.181	172.34	172.04	172.3078	2169641.0
2023-05-16 14:00:00	AAPL	Stock	172.31	172.47	171.7991	172.39	3222880.0
2023-05-16 15:00:00	AAPL	Stock	172.395	172.725	172.03	172.08	5678075.0
2023-05-16 16:00:00	AAPL	Stock	172.075	172.3	172.0106	172.26	3179152.0
2023-05-16 17:00:00	AAPL	Stock	172.25	172.3	172.17	172.17	20073.0
2023-05-16 18:00:00	AAPL	Stock	172.15	172.26	172.11	172.18	15068.0
2023-05-16 19:00:00	AAPL	Stock	172.21	172.24	172.15	172.23	17879.0
2023-05-16 04:00:00	MSFT	Stock	309.65	309.95	309.5	309.5	2599.0
2023-05-16 05:00:00	MSFT	Stock	309.85	309.85	309.42	309.44	4360.0
2023-05-16 06:00:00	MSFT	Stock	309.42	309.82	309.35	309.82	1236.0
2023-05-16 07:00:00	MSFT	Stock	309.8	309.9	309.41	309.57	4967.0
2023-05-16 08:00:00	MSFT	Stock	309.85	310.0	308.94	309.26	26563.0
2023-05-16 09:00:00	MSFT	Stock	309.26	313.71	308.98	312.15	3638547.0
2023-05-16 10:00:00	MSFT	Stock	312.18	313.24	311.1	312.8	2512808.0
2023-05-16 11:00:00	MSFT	Stock	312.7806	313.68	312.22	313.54	2171411.0
2023-05-16 12:00:00	MSFT	Stock	313.54	313.6	312.66	312.9	1425256.0
2023-05-16 13:00:00	MSFT	Stock	312.94	313.3798	312.67	313.37	1233758.0
2023-05-16 14:00:00	MSFT	Stock	313.39	313.43	312.245	312.74	1734211.0
2023-05-16 15:00:00	MSFT	Stock	312.73	313.46	311.72	311.76	2977709.0
2023-05-16 16:00:00	MSFT	Stock	311.77	312.36	311.6	311.87	3085760.0
2023-05-16 17:00:00	MSFT	Stock	311.88	311.89	311.85	311.85	6366.0
2023-05-16 18:00:00	MSFT	Stock	311.95	311.95	311.44	311.49	16977.0
2023-05-16 19:00:00	MSFT	Stock	311.55	311.74	311.25	311.7	8517.0
2023-05-16 04:00:00	NVDA	Stock	28.964	28.978	28.911	28.911	96600.0
2023-05-16 05:00:00	NVDA	Stock	28.927	28.927	28.886	28.886	13090.0
2023-05-16 06:00:00	NVDA	Stock	28.872	28.916	28.86	28.91	51130.0
2023-05-16 07:00:00	NVDA	Stock	28.92	28.943	28.89	28.905	109830.0
2023-05-16 08:00:00	NVDA	Stock	28.9201	28.957	28.821	28.83	619410.0
2023-05-16 09:00:00	NVDA	Stock	28.823	29.3	28.815	29.2795	47385290.0
2023-05-16 10:00:00	NVDA	Stock	29.277	29.358	29.078	29.306	48707810.0
2023-05-16 11:00:00	NVDA	Stock	29.3035	29.625	29.299	29.6125	50951180.0
2023-05-16 12:00:00	NVDA	Stock	29.6125	29.8159	29.564	29.8159	49564390.0
2023-05-16 13:00:00	NVDA	Stock	29.816	29.87	29.537	29.557	52010240.0
2023-05-16 14:00:00	NVDA	Stock	29.558	29.657	29.461	29.527	38046100.0
2023-05-16 15:00:00	NVDA	Stock	29.521	29.529	29.184	29.211	57612250.0
2023-05-16 16:00:00	NVDA	Stock	29.213	29.28	29.1897	29.27	14073770.0
2023-05-16 17:00:00	NVDA	Stock	29.267	29.3	29.265	29.287	156840.0
2023-05-16 18:00:00	NVDA	Stock	29.289	29.345	29.289	29.318	515380.0
2023-05-16 19:00:00	NVDA	Stock	29.323	29.4	29.315	29.373	401450.0
2023-05-16 04:00:00	AMZN	Stock	111.1	111.27	111.08	111.2	13712.0
2023-05-16 05:00:00	AMZN	Stock	111.2	111.38	111.1	111.1	4103.0

> showing 50 of 59,622 rows — these rows as CSV

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