PREVIEW / etf_1hour / 2023-12-19

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-12-19.parquet
  size:    528 KB
  rows:    19,409

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-12-19 04:00:00	SPY	ETF	472.43	472.62	472.38	472.44	14240.0
2023-12-19 05:00:00	SPY	ETF	472.48	472.49	472.33	472.33	3882.0
2023-12-19 06:00:00	SPY	ETF	472.42	472.65	472.4	472.54	27622.0
2023-12-19 07:00:00	SPY	ETF	472.5	473.17	472.5	473.12	123537.0
2023-12-19 08:00:00	SPY	ETF	472.5206	473.22	472.13	472.91	280024.0
2023-12-19 09:00:00	SPY	ETF	472.86	473.66	472.45	473.48	4736904.0
2023-12-19 10:00:00	SPY	ETF	473.5	474.08	473.04	474.065	6402434.0
2023-12-19 11:00:00	SPY	ETF	474.07	474.475	473.8499	473.91	5062299.0
2023-12-19 12:00:00	SPY	ETF	473.9	474.21	473.6305	474.075	4027709.0
2023-12-19 13:00:00	SPY	ETF	474.08	474.35	473.6399	474.1758	3993764.0
2023-12-19 14:00:00	SPY	ETF	474.18	474.41	474.0	474.17	4082533.0
2023-12-19 15:00:00	SPY	ETF	474.18	474.92	473.82	474.82	9351975.0
2023-12-19 16:00:00	SPY	ETF	474.81	474.91	474.0589	474.59	3582263.0
2023-12-19 17:00:00	SPY	ETF	474.6	474.84	474.54	474.7	2292017.0
2023-12-19 18:00:00	SPY	ETF	474.7	474.84	474.55	474.6	134511.0
2023-12-19 19:00:00	SPY	ETF	474.58	474.75	474.58	474.67	58105.0
2023-12-19 04:00:00	QQQ	ETF	407.22	407.46	407.0	407.33	47404.0
2023-12-19 05:00:00	QQQ	ETF	407.33	407.43	407.27	407.39	12905.0
2023-12-19 06:00:00	QQQ	ETF	407.39	407.76	407.23	407.59	43622.0
2023-12-19 07:00:00	QQQ	ETF	407.58	408.37	407.49	408.08	192034.0
2023-12-19 08:00:00	QQQ	ETF	407.6193	408.3304	406.75	407.69	227914.0
2023-12-19 09:00:00	QQQ	ETF	407.68	408.5286	407.345	408.18	3580601.0
2023-12-19 10:00:00	QQQ	ETF	408.19	408.87	407.54	408.6599	4521932.0
2023-12-19 11:00:00	QQQ	ETF	408.67	408.94	408.1899	408.2014	3149485.0
2023-12-19 12:00:00	QQQ	ETF	408.2	408.7199	407.84	408.5123	2535024.0
2023-12-19 13:00:00	QQQ	ETF	408.51	408.77	407.83	408.49	2484593.0
2023-12-19 14:00:00	QQQ	ETF	408.5	408.88	408.46	408.6516	2193496.0
2023-12-19 15:00:00	QQQ	ETF	408.66	409.28	408.3	409.15	5134379.0
2023-12-19 16:00:00	QQQ	ETF	409.16	409.34	409.0	409.25	1480248.0
2023-12-19 17:00:00	QQQ	ETF	409.26	409.39	409.17	409.23	15018.0
2023-12-19 18:00:00	QQQ	ETF	409.23	409.43	409.12	409.33	28077.0
2023-12-19 19:00:00	QQQ	ETF	409.32	409.56	409.32	409.48	50837.0
2023-12-19 04:00:00	IWM	ETF	197.68	197.81	197.65	197.65	17379.0
2023-12-19 05:00:00	IWM	ETF	197.7	197.75	197.61	197.72	2174.0
2023-12-19 06:00:00	IWM	ETF	197.79	197.9	197.75	197.85	34704.0
2023-12-19 07:00:00	IWM	ETF	197.87	198.899	197.82	198.79	121220.0
2023-12-19 08:00:00	IWM	ETF	197.8204	199.0	197.33	198.8	261034.0
2023-12-19 09:00:00	IWM	ETF	198.74	200.76	198.02	200.65	7250428.0
2023-12-19 10:00:00	IWM	ETF	200.65	200.805	199.62	200.21	5898751.0
2023-12-19 11:00:00	IWM	ETF	200.22	200.63	199.68	199.7007	2954485.0
2023-12-19 12:00:00	IWM	ETF	199.7	200.2355	199.54	200.2	2695598.0
2023-12-19 13:00:00	IWM	ETF	200.2	200.57	199.94	200.39	2861362.0
2023-12-19 14:00:00	IWM	ETF	200.39	200.619	200.36	200.5399	2671494.0
2023-12-19 15:00:00	IWM	ETF	200.54	201.3	200.54	200.98	9878080.0
2023-12-19 16:00:00	IWM	ETF	200.93	201.05	200.5	200.79	3258806.0
2023-12-19 17:00:00	IWM	ETF	200.81	200.93	200.75	200.84	601569.0
2023-12-19 18:00:00	IWM	ETF	200.82	200.87	200.68	200.74	32782.0
2023-12-19 19:00:00	IWM	ETF	200.7293	200.89	200.72	200.85	50791.0
2023-12-19 04:00:00	DIA	ETF	373.2	373.28	373.2	373.28	804.0
2023-12-19 05:00:00	DIA	ETF	373.19	373.19	373.19	373.19	250.0

> showing 50 of 19,409 rows — these rows as CSV

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