PREVIEW / etf_1hour / 2022-12-13

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-12-13.parquet
  size:    485 KB
  rows:    17,800

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-13 04:00:00	SPY	ETF	398.9	400.27	398.9	399.81	108369.0
2022-12-13 05:00:00	SPY	ETF	399.75	400.75	399.37	400.63	26441.0
2022-12-13 06:00:00	SPY	ETF	400.68	401.3	400.45	401.02	74594.0
2022-12-13 07:00:00	SPY	ETF	400.97	401.81	400.66	401.72	245078.0
2022-12-13 08:00:00	SPY	ETF	400.89	414.1	398.8	410.55	6948588.0
2022-12-13 09:00:00	SPY	ETF	410.6	411.6	407.4	409.33	12848252.0
2022-12-13 10:00:00	SPY	ETF	409.36	409.54	403.63	404.41	16100621.0
2022-12-13 11:00:00	SPY	ETF	404.43	405.84	401.73	402.65	10139304.0
2022-12-13 12:00:00	SPY	ETF	402.67	403.23	399.07	400.0112	11378068.0
2022-12-13 13:00:00	SPY	ETF	400.02	402.39	399.78	401.64	7392739.0
2022-12-13 14:00:00	SPY	ETF	401.64	403.22	400.9	401.59	6326588.0
2022-12-13 15:00:00	SPY	ETF	401.58	403.04	399.88	401.95	17746722.0
2022-12-13 16:00:00	SPY	ETF	401.96	402.25	401.5	401.75	3707740.0
2022-12-13 17:00:00	SPY	ETF	401.89	401.9	401.73	401.81	61475.0
2022-12-13 18:00:00	SPY	ETF	401.85	402.3	401.81	401.96	87415.0
2022-12-13 19:00:00	SPY	ETF	401.85	402.69	401.62	402.6	128574.0
2022-12-13 04:00:00	QQQ	ETF	285.74	286.81	285.68	286.2	92478.0
2022-12-13 05:00:00	QQQ	ETF	286.24	287.12	286.07	287.03	19180.0
2022-12-13 06:00:00	QQQ	ETF	287.07	287.24	286.82	287.05	44054.0
2022-12-13 07:00:00	QQQ	ETF	287.05	287.89	286.7	287.8	131667.0
2022-12-13 08:00:00	QQQ	ETF	287.3746	300.8	285.22	296.58	5692050.0
2022-12-13 09:00:00	QQQ	ETF	296.6	297.65	294.06	295.77	11030975.0
2022-12-13 10:00:00	QQQ	ETF	295.8	295.92	290.7	291.89	11178753.0
2022-12-13 11:00:00	QQQ	ETF	291.94	292.97	288.97	289.68	6797277.0
2022-12-13 12:00:00	QQQ	ETF	289.69	290.02	285.91	287.2	8488922.0
2022-12-13 13:00:00	QQQ	ETF	287.21	289.06	286.66	288.18	5438388.0
2022-12-13 14:00:00	QQQ	ETF	288.16	289.91	287.6	288.37	4132967.0
2022-12-13 15:00:00	QQQ	ETF	288.34	289.62	286.78	288.72	8350726.0
2022-12-13 16:00:00	QQQ	ETF	288.74	289.02	288.29	288.52	2467964.0
2022-12-13 17:00:00	QQQ	ETF	288.55	288.74	288.42	288.73	127718.0
2022-12-13 18:00:00	QQQ	ETF	288.7	289.04	288.6	288.71	100705.0
2022-12-13 19:00:00	QQQ	ETF	288.67	289.33	288.56	289.24	80561.0
2022-12-13 04:00:00	IWM	ETF	180.03	180.46	180.03	180.17	31772.0
2022-12-13 05:00:00	IWM	ETF	180.15	180.64	179.97	180.62	16675.0
2022-12-13 06:00:00	IWM	ETF	180.58	181.0	180.56	180.92	10264.0
2022-12-13 07:00:00	IWM	ETF	180.72	181.23	180.69	181.2	130338.0
2022-12-13 08:00:00	IWM	ETF	180.8999	187.04	179.43	186.17	806418.0
2022-12-13 09:00:00	IWM	ETF	186.17	186.67	184.44	185.55	5076641.0
2022-12-13 10:00:00	IWM	ETF	185.56	185.75	182.18	182.35	4089114.0
2022-12-13 11:00:00	IWM	ETF	182.38	182.97	181.12	181.59	2192049.0
2022-12-13 12:00:00	IWM	ETF	181.59	181.88	180.14	180.6	2477251.0
2022-12-13 13:00:00	IWM	ETF	180.61	181.98	180.58	181.64	1797711.0
2022-12-13 14:00:00	IWM	ETF	181.67	182.26	181.09	181.29	1647056.0
2022-12-13 15:00:00	IWM	ETF	181.29	181.91	180.53	181.39	3214679.0
2022-12-13 16:00:00	IWM	ETF	181.38	181.53	181.18	181.38	772210.0
2022-12-13 17:00:00	IWM	ETF	181.38	181.38	181.25	181.37	4635512.0
2022-12-13 18:00:00	IWM	ETF	181.38	181.57	181.3	181.42	30698.0
2022-12-13 19:00:00	IWM	ETF	181.41	181.77	181.18	181.75	19495.0
2022-12-13 04:00:00	DIA	ETF	341.6	341.6	341.6	341.6	100.0
2022-12-13 06:00:00	DIA	ETF	341.88	342.74	341.88	342.74	2181.0

> showing 50 of 17,800 rows — these rows as CSV

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