PREVIEW / etf_1hour / 2024-04-23

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-04-23.parquet
  size:    536 KB
  rows:    19,727

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
2024-04-23 04:00:00	SPY	ETF	499.8	500.73	499.8	500.07	40240.0
2024-04-23 05:00:00	SPY	ETF	500.05	500.5	499.85	499.85	11623.0
2024-04-23 06:00:00	SPY	ETF	500.0	501.24	500.0	501.24	42821.0
2024-04-23 07:00:00	SPY	ETF	501.24	501.43	500.51	500.6	215628.0
2024-04-23 08:00:00	SPY	ETF	501.27	501.55	499.22	501.41	266342.0
2024-04-23 09:00:00	SPY	ETF	501.33	503.69	501.225	503.07	6031755.0
2024-04-23 10:00:00	SPY	ETF	503.08	505.33	502.69	505.21	8751897.0
2024-04-23 11:00:00	SPY	ETF	505.22	505.34	504.05	504.33	6024405.0
2024-04-23 12:00:00	SPY	ETF	504.33	505.6	504.23	505.19	4761538.0
2024-04-23 13:00:00	SPY	ETF	505.19	506.065	504.57	505.98	3976341.0
2024-04-23 14:00:00	SPY	ETF	505.975	506.09	505.25	505.73	4342136.0
2024-04-23 15:00:00	SPY	ETF	505.725	505.7889	504.96	505.64	10716675.0
2024-04-23 16:00:00	SPY	ETF	505.63	506.16	505.19	506.02	3083486.0
2024-04-23 17:00:00	SPY	ETF	506.07	507.0	505.95	506.55	146003.0
2024-04-23 18:00:00	SPY	ETF	506.55	506.55	505.65	506.23	145402.0
2024-04-23 19:00:00	SPY	ETF	506.19	506.72	506.13	506.43	86958.0
2024-04-23 04:00:00	QQQ	ETF	419.26	420.06	418.52	419.66	83330.0
2024-04-23 05:00:00	QQQ	ETF	419.62	420.18	419.37	419.51	27993.0
2024-04-23 06:00:00	QQQ	ETF	419.48	420.49	419.41	420.29	83964.0
2024-04-23 07:00:00	QQQ	ETF	420.39	420.81	419.77	419.9	181910.0
2024-04-23 08:00:00	QQQ	ETF	419.99	420.78	418.19	420.6	404910.0
2024-04-23 09:00:00	QQQ	ETF	420.6	423.165	420.4	422.52	5602085.0
2024-04-23 10:00:00	QQQ	ETF	422.54	424.89	421.92	424.7201	6144855.0
2024-04-23 11:00:00	QQQ	ETF	424.73	425.08	423.51	424.025	3292454.0
2024-04-23 12:00:00	QQQ	ETF	424.03	425.28	424.03	424.78	2808904.0
2024-04-23 13:00:00	QQQ	ETF	424.78	425.9	424.25	425.795	2479475.0
2024-04-23 14:00:00	QQQ	ETF	425.8	426.28	425.4399	426.0201	2861517.0
2024-04-23 15:00:00	QQQ	ETF	426.02	426.09	424.77	425.14	6418274.0
2024-04-23 16:00:00	QQQ	ETF	425.13	426.51	424.77	426.31	1962681.0
2024-04-23 17:00:00	QQQ	ETF	426.34	427.54	425.07	427.2519	319715.0
2024-04-23 18:00:00	QQQ	ETF	427.25	427.4	425.07	426.831	292034.0
2024-04-23 19:00:00	QQQ	ETF	426.87	427.73	426.73	427.39	159011.0
2024-04-23 04:00:00	IWM	ETF	195.37	195.64	195.14	195.14	17087.0
2024-04-23 05:00:00	IWM	ETF	195.13	195.13	194.91	194.96	10316.0
2024-04-23 06:00:00	IWM	ETF	195.03	195.6	195.03	195.54	22047.0
2024-04-23 07:00:00	IWM	ETF	195.5	195.6	194.87	195.1	146352.0
2024-04-23 08:00:00	IWM	ETF	195.52	195.6	194.5	194.91	149341.0
2024-04-23 09:00:00	IWM	ETF	194.97	197.82	194.83	197.79	3498408.0
2024-04-23 10:00:00	IWM	ETF	197.8	198.75	197.5	198.44	4047703.0
2024-04-23 11:00:00	IWM	ETF	198.45	198.77	197.89	198.21	1990920.0
2024-04-23 12:00:00	IWM	ETF	198.24	198.84	198.14	198.57	1544784.0
2024-04-23 13:00:00	IWM	ETF	198.56	199.2	198.44	199.1799	1802888.0
2024-04-23 14:00:00	IWM	ETF	199.18	199.32	198.87	199.13	2164814.0
2024-04-23 15:00:00	IWM	ETF	199.12	199.13	198.275	198.52	5724859.0
2024-04-23 16:00:00	IWM	ETF	198.57	198.64	198.3649	198.44	1591441.0
2024-04-23 17:00:00	IWM	ETF	198.44	198.89	198.44	198.88	215266.0
2024-04-23 18:00:00	IWM	ETF	198.7	198.7	198.38	198.56	77239.0
2024-04-23 19:00:00	IWM	ETF	198.57	198.82	198.52	198.64	31668.0
2024-04-23 04:00:00	DIA	ETF	382.97	382.97	382.66	382.66	823.0
2024-04-23 05:00:00	DIA	ETF	382.55	382.68	382.55	382.68	730.0

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

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