PREVIEW / etf_1hour / 2022-09-15

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-09-15.parquet
  size:    443 KB
  rows:    16,126

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-09-15 04:00:00	SPY	ETF	395.62	395.89	394.6	395.01	131221.0
2022-09-15 05:00:00	SPY	ETF	395.06	395.7	394.85	395.35	73155.0
2022-09-15 06:00:00	SPY	ETF	395.43	395.5	393.41	394.0	163305.0
2022-09-15 07:00:00	SPY	ETF	394.06	394.92	393.83	394.1	262527.0
2022-09-15 08:00:00	SPY	ETF	394.2	395.65	393.18	394.14	1054826.0
2022-09-15 09:00:00	SPY	ETF	394.1	395.36	392.2929	395.1422	6389376.0
2022-09-15 10:00:00	SPY	ETF	395.18	395.96	391.16	391.35	9430625.0
2022-09-15 11:00:00	SPY	ETF	391.36	392.61	390.37	390.97	8356947.0
2022-09-15 12:00:00	SPY	ETF	390.96	392.17	390.22	392.1399	5134229.0
2022-09-15 13:00:00	SPY	ETF	392.14	394.54	392.14	392.87	7425417.0
2022-09-15 14:00:00	SPY	ETF	392.88	392.89	390.73	391.0453	6386279.0
2022-09-15 15:00:00	SPY	ETF	391.05	391.16	388.78	390.13	15171355.0
2022-09-15 16:00:00	SPY	ETF	390.13	391.1	388.79	389.3	4674718.0
2022-09-15 17:00:00	SPY	ETF	389.2	389.25	388.35	388.61	365425.0
2022-09-15 18:00:00	SPY	ETF	388.62	390.12	387.08	387.98	291254.0
2022-09-15 19:00:00	SPY	ETF	387.98	387.98	387.2	387.67	109966.0
2022-09-15 04:00:00	QQQ	ETF	296.75	296.97	295.8	296.01	52671.0
2022-09-15 05:00:00	QQQ	ETF	296.14	296.65	295.9	296.35	31325.0
2022-09-15 06:00:00	QQQ	ETF	296.48	296.5	294.63	295.13	162228.0
2022-09-15 07:00:00	QQQ	ETF	295.2	296.05	294.98	295.23	305700.0
2022-09-15 08:00:00	QQQ	ETF	295.15	296.59	294.28	295.25	777272.0
2022-09-15 09:00:00	QQQ	ETF	295.232	296.22	293.53	295.8	6327000.0
2022-09-15 10:00:00	QQQ	ETF	295.83	296.53	291.15	291.2	9517032.0
2022-09-15 11:00:00	QQQ	ETF	291.2	292.66	290.6	291.4985	7198709.0
2022-09-15 12:00:00	QQQ	ETF	291.49	292.65	290.88	292.6174	3573994.0
2022-09-15 13:00:00	QQQ	ETF	292.63	294.57	292.63	293.13	5098719.0
2022-09-15 14:00:00	QQQ	ETF	293.13	293.16	291.24	291.5001	4622434.0
2022-09-15 15:00:00	QQQ	ETF	291.5	291.7	289.46	291.02	10636186.0
2022-09-15 16:00:00	QQQ	ETF	291.03	291.82	289.82	290.27	2751673.0
2022-09-15 17:00:00	QQQ	ETF	290.25	291.1	289.7	289.95	222813.0
2022-09-15 18:00:00	QQQ	ETF	289.85	289.85	288.38	289.22	228415.0
2022-09-15 19:00:00	QQQ	ETF	289.25	289.25	288.68	288.88	127343.0
2022-09-15 04:00:00	IWM	ETF	183.74	183.74	182.99	183.11	18960.0
2022-09-15 05:00:00	IWM	ETF	183.22	183.47	183.1	183.36	5493.0
2022-09-15 06:00:00	IWM	ETF	183.33	183.37	182.31	182.63	21024.0
2022-09-15 07:00:00	IWM	ETF	182.65	183.05	182.53	182.57	19358.0
2022-09-15 08:00:00	IWM	ETF	182.69	183.0466	182.11	182.45	67169.0
2022-09-15 09:00:00	IWM	ETF	182.4	184.02	181.78	183.94	1744342.0
2022-09-15 10:00:00	IWM	ETF	184.0	184.69	182.035	182.08	3147433.0
2022-09-15 11:00:00	IWM	ETF	182.1	183.06	181.46	182.41	2176028.0
2022-09-15 12:00:00	IWM	ETF	182.4	182.81	181.98	182.81	1344928.0
2022-09-15 13:00:00	IWM	ETF	182.81	183.98	182.81	183.03	1481183.0
2022-09-15 14:00:00	IWM	ETF	183.03	183.04	181.92	182.03	1690058.0
2022-09-15 15:00:00	IWM	ETF	182.06	182.1	180.86	181.64	4104431.0
2022-09-15 16:00:00	IWM	ETF	181.63	182.12	181.12	181.37	982094.0
2022-09-15 17:00:00	IWM	ETF	181.39	181.63	180.66	180.83	439568.0
2022-09-15 18:00:00	IWM	ETF	180.83	180.99	180.05	180.63	238541.0
2022-09-15 19:00:00	IWM	ETF	180.66	180.66	180.2	180.44	42921.0
2022-09-15 04:00:00	DIA	ETF	312.49	312.49	312.45	312.46	1700.0
2022-09-15 05:00:00	DIA	ETF	312.59	312.64	312.44	312.64	2500.0

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

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