PREVIEW / etf_1hour / 2022-12-14

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-12-14.parquet
  size:    467 KB
  rows:    16,972

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
2022-12-14 04:00:00	SPY	ETF	402.37	402.43	401.51	402.03	101450.0
2022-12-14 05:00:00	SPY	ETF	402.08	402.29	401.8	401.92	11305.0
2022-12-14 06:00:00	SPY	ETF	401.83	402.03	401.09	402.02	45738.0
2022-12-14 07:00:00	SPY	ETF	401.94	402.68	401.24	401.44	216059.0
2022-12-14 08:00:00	SPY	ETF	402.17	403.27	400.92	401.68	409677.0
2022-12-14 09:00:00	SPY	ETF	401.75	403.98	401.31	403.85	5235736.0
2022-12-14 10:00:00	SPY	ETF	403.845	404.52	403.47	404.26	5668242.0
2022-12-14 11:00:00	SPY	ETF	404.27	405.04	404.05	404.14	4424143.0
2022-12-14 12:00:00	SPY	ETF	404.15	404.28	403.52	403.56	3807226.0
2022-12-14 13:00:00	SPY	ETF	403.57	405.5	403.501	404.76	5298346.0
2022-12-14 14:00:00	SPY	ETF	404.77	404.86	396.31	398.86	25249216.0
2022-12-14 15:00:00	SPY	ETF	398.88	403.59	397.7	399.41	21542500.0
2022-12-14 16:00:00	SPY	ETF	399.41	400.66	399.21	400.37	4957004.0
2022-12-14 17:00:00	SPY	ETF	400.42	400.56	400.07	400.32	117223.0
2022-12-14 18:00:00	SPY	ETF	400.35	400.74	399.91	400.29	191454.0
2022-12-14 19:00:00	SPY	ETF	400.21	400.75	400.02	400.75	143077.0
2022-12-14 04:00:00	QQQ	ETF	289.29	289.29	288.19	288.64	61251.0
2022-12-14 05:00:00	QQQ	ETF	288.65	288.97	288.38	288.54	20602.0
2022-12-14 06:00:00	QQQ	ETF	288.44	288.58	287.81	288.58	37131.0
2022-12-14 07:00:00	QQQ	ETF	288.6	289.16	288.18	288.36	74922.0
2022-12-14 08:00:00	QQQ	ETF	288.6	289.82	287.92	288.39	265062.0
2022-12-14 09:00:00	QQQ	ETF	288.4	290.09	287.88	289.9774	3973563.0
2022-12-14 10:00:00	QQQ	ETF	289.97	290.77	289.68	290.38	4087727.0
2022-12-14 11:00:00	QQQ	ETF	290.42	291.21	290.07	290.52	2894379.0
2022-12-14 12:00:00	QQQ	ETF	290.51	290.54	289.5	289.54	2376837.0
2022-12-14 13:00:00	QQQ	ETF	289.55	291.41	289.41	290.89	3545566.0
2022-12-14 14:00:00	QQQ	ETF	290.95	290.97	283.19	285.8	19036464.0
2022-12-14 15:00:00	QQQ	ETF	285.83	290.0299	284.99	286.42	13420063.0
2022-12-14 16:00:00	QQQ	ETF	286.42	287.26	286.19	287.05	1394851.0
2022-12-14 17:00:00	QQQ	ETF	287.02	287.05	286.51	286.85	794586.0
2022-12-14 18:00:00	QQQ	ETF	286.84	287.26	286.7	286.88	73623.0
2022-12-14 19:00:00	QQQ	ETF	286.83	287.23	286.7	287.23	61760.0
2022-12-14 04:00:00	IWM	ETF	181.54	181.68	181.19	181.48	13395.0
2022-12-14 05:00:00	IWM	ETF	181.47	181.65	181.35	181.35	8255.0
2022-12-14 06:00:00	IWM	ETF	181.43	181.51	181.04	181.36	6075.0
2022-12-14 07:00:00	IWM	ETF	181.52	181.8	181.02	181.09	18226.0
2022-12-14 08:00:00	IWM	ETF	181.14	181.46	180.85	181.46	71622.0
2022-12-14 09:00:00	IWM	ETF	181.46	182.15	181.21	181.775	1502752.0
2022-12-14 10:00:00	IWM	ETF	181.79	182.405	181.4	182.38	1979585.0
2022-12-14 11:00:00	IWM	ETF	182.4	182.91	182.23	182.36	2016271.0
2022-12-14 12:00:00	IWM	ETF	182.37	182.5	181.8	181.85	1445437.0
2022-12-14 13:00:00	IWM	ETF	181.86	182.68	181.85	182.51	1546565.0
2022-12-14 14:00:00	IWM	ETF	182.44	182.44	178.83	180.38	5939608.0
2022-12-14 15:00:00	IWM	ETF	180.39	182.59	179.25	180.14	5239458.0
2022-12-14 16:00:00	IWM	ETF	180.19	180.9	180.09	180.74	815927.0
2022-12-14 17:00:00	IWM	ETF	180.85	180.86	180.19	180.55	2331763.0
2022-12-14 18:00:00	IWM	ETF	180.5	180.92	180.46	180.6	20155.0
2022-12-14 19:00:00	IWM	ETF	180.6	180.89	180.48	180.87	17906.0
2022-12-14 04:00:00	DIA	ETF	342.11	342.11	342.07	342.07	461.0
2022-12-14 05:00:00	DIA	ETF	342.03	342.03	342.03	342.03	111.0

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

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