PREVIEW / etf_30min / 2022-09-20

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-09-20.parquet
  size:    643 KB
  rows:    26,079

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-20 04:00:00	SPY	ETF	388.33	388.98	387.39	387.7	54186.0
2022-09-20 04:30:00	SPY	ETF	387.75	388.4	387.75	387.78	31714.0
2022-09-20 05:00:00	SPY	ETF	387.96	387.96	386.88	387.2	49351.0
2022-09-20 05:30:00	SPY	ETF	387.46	387.51	386.51	386.9	22343.0
2022-09-20 06:00:00	SPY	ETF	386.79	386.79	386.31	386.7	46080.0
2022-09-20 06:30:00	SPY	ETF	386.89	387.04	386.52	387.02	79060.0
2022-09-20 07:00:00	SPY	ETF	387.03	387.43	386.71	387.3	144061.0
2022-09-20 07:30:00	SPY	ETF	387.15	387.15	386.69	386.74	60494.0
2022-09-20 08:00:00	SPY	ETF	386.9835	390.18	385.34	385.5	290550.0
2022-09-20 08:30:00	SPY	ETF	385.5	386.25	385.5	385.9	197184.0
2022-09-20 09:00:00	SPY	ETF	385.885	386.17	385.05	385.05	402897.0
2022-09-20 09:30:00	SPY	ETF	385.05	385.3	383.41	383.88	6421041.0
2022-09-20 10:00:00	SPY	ETF	383.87	384.44	383.1	384.0	4174563.0
2022-09-20 10:30:00	SPY	ETF	384.0	384.76	382.74	384.65	3613098.0
2022-09-20 11:00:00	SPY	ETF	384.66	385.2001	384.13	384.6099	2789458.0
2022-09-20 11:30:00	SPY	ETF	384.6	385.86	384.22	385.68	3145648.0
2022-09-20 12:00:00	SPY	ETF	385.7	386.12	384.565	384.57	2518957.0
2022-09-20 12:30:00	SPY	ETF	384.58	384.64	383.82	384.21	3127735.0
2022-09-20 13:00:00	SPY	ETF	384.21	384.32	382.57	382.67	3653711.0
2022-09-20 13:30:00	SPY	ETF	382.645	382.75	381.195	381.41	3617933.0
2022-09-20 14:00:00	SPY	ETF	381.405	383.08	381.35	382.71	3745788.0
2022-09-20 14:30:00	SPY	ETF	382.7	383.65	381.5	383.33	4436266.0
2022-09-20 15:00:00	SPY	ETF	383.325	384.5	382.85	384.15	4385552.0
2022-09-20 15:30:00	SPY	ETF	384.14	385.47	383.475	384.17	9379548.0
2022-09-20 16:00:00	SPY	ETF	384.16	384.98	384.09	384.46	2392679.0
2022-09-20 16:30:00	SPY	ETF	384.47	384.74	384.09	384.74	138971.0
2022-09-20 17:00:00	SPY	ETF	384.71	384.74	384.52	384.52	19273.0
2022-09-20 17:30:00	SPY	ETF	384.54	384.6	384.5	384.58	52428.0
2022-09-20 18:00:00	SPY	ETF	384.59	384.63	384.01	384.11	72835.0
2022-09-20 18:30:00	SPY	ETF	384.2	384.44	384.15	384.44	35054.0
2022-09-20 19:00:00	SPY	ETF	384.42	384.5	383.83	384.08	46458.0
2022-09-20 19:30:00	SPY	ETF	384.02	384.45	384.0	384.34	32304.0
2022-09-20 04:00:00	QQQ	ETF	290.96	290.96	289.88	290.27	47691.0
2022-09-20 04:30:00	QQQ	ETF	290.28	290.71	290.2	290.32	39340.0
2022-09-20 05:00:00	QQQ	ETF	290.25	290.34	289.35	289.74	46727.0
2022-09-20 05:30:00	QQQ	ETF	289.67	289.94	289.3	289.56	58824.0
2022-09-20 06:00:00	QQQ	ETF	289.55	289.63	289.1	289.63	46547.0
2022-09-20 06:30:00	QQQ	ETF	289.65	289.77	289.37	289.67	31120.0
2022-09-20 07:00:00	QQQ	ETF	289.72	290.16	289.51	289.99	175593.0
2022-09-20 07:30:00	QQQ	ETF	289.92	289.98	289.32	289.39	97004.0
2022-09-20 08:00:00	QQQ	ETF	289.72	292.0	288.47	288.56	335129.0
2022-09-20 08:30:00	QQQ	ETF	288.61	289.28	288.58	289.05	245168.0
2022-09-20 09:00:00	QQQ	ETF	289.06	289.27	288.4	288.48	227021.0
2022-09-20 09:30:00	QQQ	ETF	288.49	289.22	287.79	288.6	6046746.0
2022-09-20 10:00:00	QQQ	ETF	288.59	289.26	288.05	288.84	4085653.0
2022-09-20 10:30:00	QQQ	ETF	288.84	289.68	287.8601	289.51	3169819.0
2022-09-20 11:00:00	QQQ	ETF	289.5	290.18	289.1163	289.8716	1998616.0
2022-09-20 11:30:00	QQQ	ETF	289.89	290.92	289.32	290.85	2017499.0
2022-09-20 12:00:00	QQQ	ETF	290.89	291.07	289.56	289.6242	1812499.0
2022-09-20 12:30:00	QQQ	ETF	289.6	289.68	288.94	289.3	1664701.0

> showing 50 of 26,079 rows — these rows as CSV

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