PREVIEW / etf_1hour / 2023-03-07

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-03-07.parquet
  size:    465 KB
  rows:    16,821

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-03-07 04:00:00	SPY	ETF	405.33	405.73	405.1	405.1	13983.0
2023-03-07 05:00:00	SPY	ETF	405.11	405.38	405.09	405.35	10534.0
2023-03-07 06:00:00	SPY	ETF	405.42	405.53	404.97	405.03	36096.0
2023-03-07 07:00:00	SPY	ETF	405.0	405.07	404.75	404.97	113017.0
2023-03-07 08:00:00	SPY	ETF	404.9813	405.6296	404.77	404.88	225572.0
2023-03-07 09:00:00	SPY	ETF	404.87	404.89	404.08	404.3572	4872561.0
2023-03-07 10:00:00	SPY	ETF	404.31	404.3199	400.35	400.42	20511473.0
2023-03-07 11:00:00	SPY	ETF	400.44	401.32	399.78	399.89	9997538.0
2023-03-07 12:00:00	SPY	ETF	399.87	402.02	399.78	400.34	8277177.0
2023-03-07 13:00:00	SPY	ETF	400.335	400.39	398.16	398.3866	8634197.0
2023-03-07 14:00:00	SPY	ETF	398.38	398.94	397.625	397.745	9109551.0
2023-03-07 15:00:00	SPY	ETF	397.745	399.17	397.69	398.26	18292667.0
2023-03-07 16:00:00	SPY	ETF	398.28	398.56	398.11	398.3	4831169.0
2023-03-07 17:00:00	SPY	ETF	398.28	398.4	398.21	398.31	56217.0
2023-03-07 18:00:00	SPY	ETF	398.32	398.6	398.31	398.47	47339.0
2023-03-07 19:00:00	SPY	ETF	398.47	398.53	397.4	398.24	188394.0
2023-03-07 04:00:00	QQQ	ETF	300.58	301.41	300.58	300.74	37924.0
2023-03-07 05:00:00	QQQ	ETF	300.8	301.11	300.79	301.05	8302.0
2023-03-07 06:00:00	QQQ	ETF	301.05	301.22	300.68	300.76	37660.0
2023-03-07 07:00:00	QQQ	ETF	300.75	300.86	300.5	300.66	54076.0
2023-03-07 08:00:00	QQQ	ETF	300.79	301.1904	300.245	300.6	206404.0
2023-03-07 09:00:00	QQQ	ETF	300.59	301.01	299.82	300.292	3954066.0
2023-03-07 10:00:00	QQQ	ETF	300.29	300.29	296.64	297.45	15531926.0
2023-03-07 11:00:00	QQQ	ETF	297.47	298.64	297.3	297.6599	7069311.0
2023-03-07 12:00:00	QQQ	ETF	297.66	299.77	297.55	298.55	5640548.0
2023-03-07 13:00:00	QQQ	ETF	298.53	298.64	296.36	296.72	5684391.0
2023-03-07 14:00:00	QQQ	ETF	296.72	297.21	295.72	295.81	4196964.0
2023-03-07 15:00:00	QQQ	ETF	295.82	296.78	295.75	296.33	8318038.0
2023-03-07 16:00:00	QQQ	ETF	296.33	296.73	296.2	296.48	1706003.0
2023-03-07 17:00:00	QQQ	ETF	296.45	296.508	296.35	296.37	27276.0
2023-03-07 18:00:00	QQQ	ETF	296.4	296.68	296.38	296.5	30095.0
2023-03-07 19:00:00	QQQ	ETF	296.52	296.52	295.96	296.22	132540.0
2023-03-07 04:00:00	IWM	ETF	189.28	189.44	189.17	189.17	5993.0
2023-03-07 05:00:00	IWM	ETF	189.24	189.36	189.22	189.33	3118.0
2023-03-07 06:00:00	IWM	ETF	189.32	189.44	189.14	189.14	23911.0
2023-03-07 07:00:00	IWM	ETF	189.16	189.25	188.98	189.25	45225.0
2023-03-07 08:00:00	IWM	ETF	189.13	189.34	188.7	189.15	101888.0
2023-03-07 09:00:00	IWM	ETF	189.11	189.11	188.11	189.04	1878044.0
2023-03-07 10:00:00	IWM	ETF	189.0	189.01	187.13	187.15	4429426.0
2023-03-07 11:00:00	IWM	ETF	187.16	187.85	187.06	187.25	1630369.0
2023-03-07 12:00:00	IWM	ETF	187.24	188.29	187.06	187.42	1564682.0
2023-03-07 13:00:00	IWM	ETF	187.42	187.45	186.32	186.4	1875652.0
2023-03-07 14:00:00	IWM	ETF	186.4	186.74	186.22	186.3	1319830.0
2023-03-07 15:00:00	IWM	ETF	186.29	187.07	186.29	186.54	3683483.0
2023-03-07 16:00:00	IWM	ETF	186.54	186.76	186.51	186.68	1499669.0
2023-03-07 17:00:00	IWM	ETF	186.56	186.67	186.52	186.55	12939.0
2023-03-07 18:00:00	IWM	ETF	186.57	186.82	186.57	186.77	20772.0
2023-03-07 19:00:00	IWM	ETF	186.76	186.76	186.45	186.65	14390.0
2023-03-07 04:00:00	DIA	ETF	335.0	335.0	335.0	335.0	100.0
2023-03-07 08:00:00	DIA	ETF	334.82	335.05	334.82	334.93	750.0

> showing 50 of 16,821 rows — these rows as CSV

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