PREVIEW / etf_1hour / 2023-03-15

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-03-15.parquet
  size:    487 KB
  rows:    18,362

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-15 04:00:00	SPY	ETF	391.63	392.38	391.18	391.18	65315.0
2023-03-15 05:00:00	SPY	ETF	391.23	391.31	388.65	388.67	128787.0
2023-03-15 06:00:00	SPY	ETF	388.63	388.99	383.77	384.75	522600.0
2023-03-15 07:00:00	SPY	ETF	384.69	386.13	384.69	385.26	1174191.0
2023-03-15 08:00:00	SPY	ETF	385.931	392.59	383.31	384.52	2549809.0
2023-03-15 09:00:00	SPY	ETF	384.5	387.72	384.07	385.57	14459506.0
2023-03-15 10:00:00	SPY	ETF	385.6	387.44	384.3106	386.165	18536051.0
2023-03-15 11:00:00	SPY	ETF	386.18	387.37	385.55	385.72	12082791.0
2023-03-15 12:00:00	SPY	ETF	385.7	386.25	383.71	384.14	13675592.0
2023-03-15 13:00:00	SPY	ETF	384.14	386.97	383.82	386.49	12531684.0
2023-03-15 14:00:00	SPY	ETF	386.51	389.49	385.44	388.66	19448423.0
2023-03-15 15:00:00	SPY	ETF	388.66	389.38	386.77	389.35	27577911.0
2023-03-15 16:00:00	SPY	ETF	389.35	389.63	388.71	389.1	4868371.0
2023-03-15 17:00:00	SPY	ETF	389.01	389.28	388.66	388.88	152072.0
2023-03-15 18:00:00	SPY	ETF	388.94	389.56	388.71	389.39	498332.0
2023-03-15 19:00:00	SPY	ETF	389.48	389.66	388.58	388.78	130246.0
2023-03-15 04:00:00	QQQ	ETF	297.68	298.24	297.37	297.39	46810.0
2023-03-15 05:00:00	QQQ	ETF	297.46	297.46	295.37	295.49	77555.0
2023-03-15 06:00:00	QQQ	ETF	295.48	295.76	292.05	292.99	331752.0
2023-03-15 07:00:00	QQQ	ETF	292.84	294.0	292.82	293.44	676770.0
2023-03-15 08:00:00	QQQ	ETF	293.35	298.0	292.0896	293.27	1575393.0
2023-03-15 09:00:00	QQQ	ETF	293.34	296.17	292.77	294.65	8357504.0
2023-03-15 10:00:00	QQQ	ETF	294.61	296.05	293.24	295.14	9549703.0
2023-03-15 11:00:00	QQQ	ETF	295.16	297.04	294.67	295.79	6492368.0
2023-03-15 12:00:00	QQQ	ETF	295.78	296.165	293.96	294.34	5558872.0
2023-03-15 13:00:00	QQQ	ETF	294.35	296.89	294.05	296.48	5176633.0
2023-03-15 14:00:00	QQQ	ETF	296.4962	298.92	295.65	298.535	8531837.0
2023-03-15 15:00:00	QQQ	ETF	298.55	299.27	296.71	298.93	12020924.0
2023-03-15 16:00:00	QQQ	ETF	298.93	299.24	298.7	299.03	1576874.0
2023-03-15 17:00:00	QQQ	ETF	299.06	299.11	298.76	298.9	109681.0
2023-03-15 18:00:00	QQQ	ETF	298.9	299.71	298.75	299.59	108050.0
2023-03-15 19:00:00	QQQ	ETF	299.58	299.81	298.98	299.23	194592.0
2023-03-15 04:00:00	IWM	ETF	176.83	177.15	176.16	176.16	14267.0
2023-03-15 05:00:00	IWM	ETF	176.24	176.24	174.4	174.42	34623.0
2023-03-15 06:00:00	IWM	ETF	174.42	174.42	171.5	171.94	162879.0
2023-03-15 07:00:00	IWM	ETF	171.97	172.54	171.7	172.03	356976.0
2023-03-15 08:00:00	IWM	ETF	172.05	175.93	170.73	171.1	526463.0
2023-03-15 09:00:00	IWM	ETF	171.16	173.28	171.1	172.02	6205596.0
2023-03-15 10:00:00	IWM	ETF	172.01	173.08	171.34	172.41	5777730.0
2023-03-15 11:00:00	IWM	ETF	172.42	173.29	171.94	172.1	4469246.0
2023-03-15 12:00:00	IWM	ETF	172.1	172.36	170.3762	170.72	4306830.0
2023-03-15 13:00:00	IWM	ETF	170.69	172.395	170.5	172.065	3872568.0
2023-03-15 14:00:00	IWM	ETF	172.08	173.91	171.36	173.045	6054428.0
2023-03-15 15:00:00	IWM	ETF	173.05	173.75	172.3	173.72	9481406.0
2023-03-15 16:00:00	IWM	ETF	173.73	173.8	171.1428	173.48	1845661.0
2023-03-15 17:00:00	IWM	ETF	173.64	173.64	173.2	173.3	413456.0
2023-03-15 18:00:00	IWM	ETF	173.37	173.7	173.15	173.64	46114.0
2023-03-15 19:00:00	IWM	ETF	173.72	173.77	173.1	173.21	56398.0
2023-03-15 04:00:00	DIA	ETF	322.06	322.06	322.06	322.06	100.0
2023-03-15 05:00:00	DIA	ETF	321.26	321.26	319.56	319.57	9339.0

> showing 50 of 18,362 rows — these rows as CSV

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