PREVIEW / etf_1hour / 2022-11-15

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-11-15.parquet
  size:    476 KB
  rows:    17,509

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-11-15 04:00:00	SPY	ETF	397.67	397.91	397.36	397.75	80895.0
2022-11-15 05:00:00	SPY	ETF	397.73	398.41	397.73	397.95	48174.0
2022-11-15 06:00:00	SPY	ETF	397.94	398.3	397.54	398.05	149153.0
2022-11-15 07:00:00	SPY	ETF	398.07	399.15	397.68	399.05	388177.0
2022-11-15 08:00:00	SPY	ETF	398.0	403.54	396.8	402.43	2479675.0
2022-11-15 09:00:00	SPY	ETF	402.35	402.48	399.97	401.62	7344828.0
2022-11-15 10:00:00	SPY	ETF	401.63	402.17	399.83	400.27	7246976.0
2022-11-15 11:00:00	SPY	ETF	400.25	401.565	399.35	401.2	5889278.0
2022-11-15 12:00:00	SPY	ETF	401.2	401.32	399.41	399.9986	4158847.0
2022-11-15 13:00:00	SPY	ETF	400.0	400.29	394.49	396.47	15343358.0
2022-11-15 14:00:00	SPY	ETF	396.475	399.16	394.93	398.71	11806730.0
2022-11-15 15:00:00	SPY	ETF	398.68	399.52	397.46	398.54	12078504.0
2022-11-15 16:00:00	SPY	ETF	398.54	399.04	397.64	397.98	6362575.0
2022-11-15 17:00:00	SPY	ETF	398.01	398.08	397.75	397.75	53984.0
2022-11-15 18:00:00	SPY	ETF	397.79	398.08	396.91	397.99	264904.0
2022-11-15 19:00:00	SPY	ETF	398.07	398.1	396.57	396.65	153101.0
2022-11-15 04:00:00	QQQ	ETF	287.86	288.28	287.72	288.17	56128.0
2022-11-15 05:00:00	QQQ	ETF	288.16	288.7	288.16	288.52	120557.0
2022-11-15 06:00:00	QQQ	ETF	288.7	288.83	288.26	288.7	56660.0
2022-11-15 07:00:00	QQQ	ETF	288.7	289.69	288.21	289.61	249823.0
2022-11-15 08:00:00	QQQ	ETF	288.56	294.56	285.654	293.48	3274984.0
2022-11-15 09:00:00	QQQ	ETF	293.52	293.58	290.815	292.455	8060912.0
2022-11-15 10:00:00	QQQ	ETF	292.45	293.01	290.76	291.28	6618648.0
2022-11-15 11:00:00	QQQ	ETF	291.35	292.74	290.31	292.59	5524210.0
2022-11-15 12:00:00	QQQ	ETF	292.59	292.64	290.99	291.41	3907136.0
2022-11-15 13:00:00	QQQ	ETF	291.43	291.7	285.97	287.91	11587353.0
2022-11-15 14:00:00	QQQ	ETF	287.92	290.1	286.34	289.72	9168611.0
2022-11-15 15:00:00	QQQ	ETF	289.71	290.505	288.59	289.42	7693761.0
2022-11-15 16:00:00	QQQ	ETF	289.4	290.82	288.75	289.07	1754047.0
2022-11-15 17:00:00	QQQ	ETF	289.13	289.39	288.88	288.95	99055.0
2022-11-15 18:00:00	QQQ	ETF	288.98	289.21	288.19	289.15	120387.0
2022-11-15 19:00:00	QQQ	ETF	289.2	289.3	287.8	287.84	139169.0
2022-11-15 04:00:00	IWM	ETF	186.33	186.38	186.01	186.23	41790.0
2022-11-15 05:00:00	IWM	ETF	186.26	186.47	186.1	186.16	17901.0
2022-11-15 06:00:00	IWM	ETF	186.25	186.45	185.95	186.18	33332.0
2022-11-15 07:00:00	IWM	ETF	186.2	186.81	186.03	186.65	232994.0
2022-11-15 08:00:00	IWM	ETF	186.2399	188.81	186.11	187.99	357754.0
2022-11-15 09:00:00	IWM	ETF	188.04	189.02	186.7343	188.3086	2675711.0
2022-11-15 10:00:00	IWM	ETF	188.32	189.56	187.95	188.43	3255451.0
2022-11-15 11:00:00	IWM	ETF	188.43	189.13	187.94	189.07	2009661.0
2022-11-15 12:00:00	IWM	ETF	189.08	189.26	188.38	188.87	1304740.0
2022-11-15 13:00:00	IWM	ETF	188.88	189.0	186.11	187.1	3198036.0
2022-11-15 14:00:00	IWM	ETF	187.11	188.215	186.13	188.01	2801165.0
2022-11-15 15:00:00	IWM	ETF	188.04	188.34	187.33	187.64	2901738.0
2022-11-15 16:00:00	IWM	ETF	187.55	187.89	187.15	187.3	1537928.0
2022-11-15 17:00:00	IWM	ETF	187.31	187.43	187.25	187.39	6573.0
2022-11-15 18:00:00	IWM	ETF	187.25	187.44	186.84	187.44	21406.0
2022-11-15 19:00:00	IWM	ETF	187.45	187.45	186.57	186.57	28356.0
2022-11-15 04:00:00	DIA	ETF	337.34	337.34	337.07	337.07	440.0
2022-11-15 05:00:00	DIA	ETF	337.13	337.57	337.1	337.17	3662.0

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

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