PREVIEW / etf_30min / 2022-09-15

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-09-15.parquet
  size:    647 KB
  rows:    25,920

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.86	394.94	95112.0
2022-09-15 04:30:00	SPY	ETF	394.96	395.03	394.6	395.01	36109.0
2022-09-15 05:00:00	SPY	ETF	395.06	395.23	394.85	395.07	52364.0
2022-09-15 05:30:00	SPY	ETF	395.15	395.7	395.15	395.35	20791.0
2022-09-15 06:00:00	SPY	ETF	395.43	395.5	395.02	395.02	15428.0
2022-09-15 06:30:00	SPY	ETF	395.04	395.04	393.41	394.0	147877.0
2022-09-15 07:00:00	SPY	ETF	394.06	394.92	393.9	394.89	132882.0
2022-09-15 07:30:00	SPY	ETF	394.86	394.87	393.83	394.1	129645.0
2022-09-15 08:00:00	SPY	ETF	394.2	395.65	393.26	393.5	308337.0
2022-09-15 08:30:00	SPY	ETF	393.44	394.73	393.18	394.14	746489.0
2022-09-15 09:00:00	SPY	ETF	394.1	394.18	392.76	392.92	568527.0
2022-09-15 09:30:00	SPY	ETF	392.96	395.36	392.2929	395.1422	5820849.0
2022-09-15 10:00:00	SPY	ETF	395.18	395.96	392.83	392.92	4409934.0
2022-09-15 10:30:00	SPY	ETF	392.92	393.66	391.16	391.35	5020691.0
2022-09-15 11:00:00	SPY	ETF	391.36	392.55	390.57	392.2614	5090853.0
2022-09-15 11:30:00	SPY	ETF	392.26	392.61	390.37	390.97	3266094.0
2022-09-15 12:00:00	SPY	ETF	390.96	391.38	390.22	390.62	2714608.0
2022-09-15 12:30:00	SPY	ETF	390.63	392.17	390.6	392.1399	2419621.0
2022-09-15 13:00:00	SPY	ETF	392.14	394.54	392.14	394.06	4694140.0
2022-09-15 13:30:00	SPY	ETF	394.02	394.12	392.47	392.87	2731277.0
2022-09-15 14:00:00	SPY	ETF	392.88	392.89	391.25	392.26	3396349.0
2022-09-15 14:30:00	SPY	ETF	392.27	392.665	390.73	391.0453	2989930.0
2022-09-15 15:00:00	SPY	ETF	391.05	391.16	388.78	389.11	5520087.0
2022-09-15 15:30:00	SPY	ETF	389.1	390.96	388.87	390.13	9651268.0
2022-09-15 16:00:00	SPY	ETF	390.13	391.1	390.12	390.59	3545084.0
2022-09-15 16:30:00	SPY	ETF	390.56	390.57	388.79	389.3	1129634.0
2022-09-15 17:00:00	SPY	ETF	389.2	389.25	388.35	388.62	274944.0
2022-09-15 17:30:00	SPY	ETF	388.63	388.76	388.5	388.61	90481.0
2022-09-15 18:00:00	SPY	ETF	388.62	390.12	387.08	387.58	194585.0
2022-09-15 18:30:00	SPY	ETF	387.56	387.99	387.56	387.98	96669.0
2022-09-15 19:00:00	SPY	ETF	387.98	387.98	387.2	387.28	71207.0
2022-09-15 19:30:00	SPY	ETF	387.34	387.86	387.34	387.67	38759.0
2022-09-15 04:00:00	QQQ	ETF	296.75	296.97	296.05	296.11	27111.0
2022-09-15 04:30:00	QQQ	ETF	296.19	296.19	295.8	296.01	25560.0
2022-09-15 05:00:00	QQQ	ETF	296.14	296.17	295.9	296.08	16250.0
2022-09-15 05:30:00	QQQ	ETF	296.45	296.65	296.35	296.35	15075.0
2022-09-15 06:00:00	QQQ	ETF	296.48	296.5	296.28	296.28	9376.0
2022-09-15 06:30:00	QQQ	ETF	296.1	296.1	294.63	295.13	152852.0
2022-09-15 07:00:00	QQQ	ETF	295.2	296.05	295.11	296.05	151977.0
2022-09-15 07:30:00	QQQ	ETF	296.05	296.05	294.98	295.23	153723.0
2022-09-15 08:00:00	QQQ	ETF	295.15	296.59	294.3	294.68	367026.0
2022-09-15 08:30:00	QQQ	ETF	294.9	295.76	294.28	295.25	410246.0
2022-09-15 09:00:00	QQQ	ETF	295.232	295.32	293.94	294.01	551212.0
2022-09-15 09:30:00	QQQ	ETF	294.07	296.22	293.53	295.8	5775788.0
2022-09-15 10:00:00	QQQ	ETF	295.83	296.53	293.48	293.595	4251196.0
2022-09-15 10:30:00	QQQ	ETF	293.585	294.15	291.15	291.2	5265836.0
2022-09-15 11:00:00	QQQ	ETF	291.2	292.38	290.6	292.1	4566480.0
2022-09-15 11:30:00	QQQ	ETF	292.07	292.66	290.94	291.4985	2632229.0
2022-09-15 12:00:00	QQQ	ETF	291.49	291.88	290.88	291.24	1994362.0
2022-09-15 12:30:00	QQQ	ETF	291.26	292.65	291.22	292.6174	1579632.0

> showing 50 of 25,920 rows — these rows as CSV

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