PREVIEW / stock_1hour / 2023-09-27

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-09-27.parquet
  size:    1.3 MB
  rows:    58,635
  symbols: 1,400

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-09-27 04:00:00	AAPL	Stock	172.71	173.32	172.5	172.95	20381.0
2023-09-27 05:00:00	AAPL	Stock	172.9	172.9	172.62	172.67	4447.0
2023-09-27 06:00:00	AAPL	Stock	172.69	172.84	172.5	172.6	13864.0
2023-09-27 07:00:00	AAPL	Stock	172.65	172.91	172.5	172.89	79516.0
2023-09-27 08:00:00	AAPL	Stock	172.6	173.17	172.3	172.94	218896.0
2023-09-27 09:00:00	AAPL	Stock	172.9	173.05	171.45	171.51	6364589.0
2023-09-27 10:00:00	AAPL	Stock	171.5	171.66	170.27	170.409	9106029.0
2023-09-27 11:00:00	AAPL	Stock	170.405	171.1479	170.02	170.4	5438279.0
2023-09-27 12:00:00	AAPL	Stock	170.4011	170.41	169.64	169.94	5645477.0
2023-09-27 13:00:00	AAPL	Stock	169.93	170.2	169.05	169.53	5265596.0
2023-09-27 14:00:00	AAPL	Stock	169.54	170.67	169.195	170.2	5786076.0
2023-09-27 15:00:00	AAPL	Stock	170.2	170.96	169.76	170.43	11874738.0
2023-09-27 16:00:00	AAPL	Stock	170.43	170.64	170.25	170.43	6959536.0
2023-09-27 17:00:00	AAPL	Stock	170.44	170.49	170.34	170.43	42463.0
2023-09-27 18:00:00	AAPL	Stock	170.47	170.4991	170.22	170.2986	48164.0
2023-09-27 19:00:00	AAPL	Stock	170.29	170.39	170.22	170.34	32562.0
2023-09-27 04:00:00	MSFT	Stock	313.03	314.44	313.03	314.0	3765.0
2023-09-27 05:00:00	MSFT	Stock	313.76	314.02	313.66	313.97	4531.0
2023-09-27 06:00:00	MSFT	Stock	313.95	313.95	313.7	313.94	654.0
2023-09-27 07:00:00	MSFT	Stock	313.95	314.08	313.33	313.33	10222.0
2023-09-27 08:00:00	MSFT	Stock	313.5	314.05	312.6	313.68	32803.0
2023-09-27 09:00:00	MSFT	Stock	313.66	314.16	311.81	312.19	1535197.0
2023-09-27 10:00:00	MSFT	Stock	312.205	312.5024	310.1755	310.3472	2559863.0
2023-09-27 11:00:00	MSFT	Stock	310.35	311.877	310.3	310.84	1335486.0
2023-09-27 12:00:00	MSFT	Stock	310.83	311.28	310.27	311.0135	964296.0
2023-09-27 13:00:00	MSFT	Stock	311.03	311.9	309.75	310.11	1223744.0
2023-09-27 14:00:00	MSFT	Stock	310.115	313.16	309.69	312.695	1614679.0
2023-09-27 15:00:00	MSFT	Stock	312.695	314.299	311.87	312.83	2352189.0
2023-09-27 16:00:00	MSFT	Stock	312.85	313.97	312.61	313.81	2355306.0
2023-09-27 17:00:00	MSFT	Stock	313.72	313.9899	313.5633	313.73	4071.0
2023-09-27 18:00:00	MSFT	Stock	313.7499	313.7499	312.8	313.1	7272.0
2023-09-27 19:00:00	MSFT	Stock	313.17	313.86	313.03	313.86	8936.0
2023-09-27 04:00:00	NVDA	Stock	42.15	42.2	42.121	42.13	198840.0
2023-09-27 05:00:00	NVDA	Stock	42.137	42.137	42.034	42.05	157590.0
2023-09-27 06:00:00	NVDA	Stock	42.03	42.083	41.95	42.065	91670.0
2023-09-27 07:00:00	NVDA	Stock	42.057	42.2	42.021	42.19	515300.0
2023-09-27 08:00:00	NVDA	Stock	42.05	42.2868	41.955	42.25	1245780.0
2023-09-27 09:00:00	NVDA	Stock	42.24	42.655	42.2	42.377	51731270.0
2023-09-27 10:00:00	NVDA	Stock	42.381	42.4398	41.885	41.96	60716490.0
2023-09-27 11:00:00	NVDA	Stock	41.96	42.278	41.7733	41.793	42937910.0
2023-09-27 12:00:00	NVDA	Stock	41.793	41.92	41.629	41.727	35275250.0
2023-09-27 13:00:00	NVDA	Stock	41.726	41.9466	41.66	41.836	26857620.0
2023-09-27 14:00:00	NVDA	Stock	41.831	42.535	41.735	42.4795	50555640.0
2023-09-27 15:00:00	NVDA	Stock	42.471	42.872	42.371	42.468	69117450.0
2023-09-27 16:00:00	NVDA	Stock	42.485	42.517	42.3721	42.4214	14815490.0
2023-09-27 17:00:00	NVDA	Stock	42.43	42.51	42.421	42.483	309570.0
2023-09-27 18:00:00	NVDA	Stock	42.476	42.595	42.462	42.594	314760.0
2023-09-27 19:00:00	NVDA	Stock	42.595	42.7	42.58	42.69	558700.0
2023-09-27 04:00:00	AMZN	Stock	126.46	126.62	126.1	126.3	25151.0
2023-09-27 05:00:00	AMZN	Stock	126.3	126.31	126.05	126.2	8432.0

> showing 50 of 58,635 rows — these rows as CSV

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