PREVIEW / etf_30min / 2022-08-29

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-08-29.parquet
  size:    659 KB
  rows:    26,259

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-08-29 04:00:00	SPY	ETF	403.39	403.39	402.11	402.11	32421.0
2022-08-29 04:30:00	SPY	ETF	402.25	402.27	401.31	401.32	17543.0
2022-08-29 05:00:00	SPY	ETF	401.31	401.94	401.2	401.86	28551.0
2022-08-29 05:30:00	SPY	ETF	401.78	401.9	401.07	401.77	19102.0
2022-08-29 06:00:00	SPY	ETF	401.78	401.84	401.32	401.45	43659.0
2022-08-29 06:30:00	SPY	ETF	401.65	402.08	401.47	401.54	27640.0
2022-08-29 07:00:00	SPY	ETF	401.49	401.66	401.02	401.28	193271.0
2022-08-29 07:30:00	SPY	ETF	401.24	401.82	401.15	401.82	209927.0
2022-08-29 08:00:00	SPY	ETF	401.21	403.13	401.02	402.13	418805.0
2022-08-29 08:30:00	SPY	ETF	402.15	402.82	401.99	401.99	268156.0
2022-08-29 09:00:00	SPY	ETF	402.0	402.65	401.82	402.26	278078.0
2022-08-29 09:30:00	SPY	ETF	402.2	404.17	401.5101	402.814	7215665.0
2022-08-29 10:00:00	SPY	ETF	402.84	404.52	402.52	403.4199	4451801.0
2022-08-29 10:30:00	SPY	ETF	403.42	403.95	401.1999	401.4	4614519.0
2022-08-29 11:00:00	SPY	ETF	401.38	402.74	401.28	402.17	3718338.0
2022-08-29 11:30:00	SPY	ETF	402.18	403.53	401.85	403.37	2963427.0
2022-08-29 12:00:00	SPY	ETF	403.39	404.44	403.32	403.83	2891789.0
2022-08-29 12:30:00	SPY	ETF	403.83	405.27	403.08	404.62	2648130.0
2022-08-29 13:00:00	SPY	ETF	404.64	405.1999	403.86	404.46	2026441.0
2022-08-29 13:30:00	SPY	ETF	404.44	405.84	404.315	405.08	2880008.0
2022-08-29 14:00:00	SPY	ETF	405.12	405.1369	403.74	404.05	2025456.0
2022-08-29 14:30:00	SPY	ETF	404.06	405.0	403.66	404.6	2122204.0
2022-08-29 15:00:00	SPY	ETF	404.63	405.605	404.07	404.1565	2714518.0
2022-08-29 15:30:00	SPY	ETF	404.14	404.76	402.4	402.63	6446599.0
2022-08-29 16:00:00	SPY	ETF	402.62	402.9	402.42	402.48	2243118.0
2022-08-29 16:30:00	SPY	ETF	402.48	402.99	402.43	402.97	161019.0
2022-08-29 17:00:00	SPY	ETF	402.94	402.98	402.82	402.94	57110.0
2022-08-29 17:30:00	SPY	ETF	402.89	402.93	402.82	402.85	27373.0
2022-08-29 18:00:00	SPY	ETF	402.91	403.16	402.9	402.9	87904.0
2022-08-29 18:30:00	SPY	ETF	402.9	402.97	402.88	402.89	25408.0
2022-08-29 19:00:00	SPY	ETF	402.94	403.11	402.73	403.11	15518.0
2022-08-29 19:30:00	SPY	ETF	403.06	403.73	403.06	403.62	65910.0
2022-08-29 04:00:00	QQQ	ETF	303.0	305.48	303.0	303.91	96757.0
2022-08-29 04:30:00	QQQ	ETF	303.92	304.12	303.4	303.4	28957.0
2022-08-29 05:00:00	QQQ	ETF	303.4	304.11	303.3	303.94	50090.0
2022-08-29 05:30:00	QQQ	ETF	303.93	304.18	303.39	304.01	64574.0
2022-08-29 06:00:00	QQQ	ETF	304.06	304.22	303.71	303.93	29158.0
2022-08-29 06:30:00	QQQ	ETF	303.9	304.41	303.9	303.94	44424.0
2022-08-29 07:00:00	QQQ	ETF	303.94	304.02	303.36	303.45	131776.0
2022-08-29 07:30:00	QQQ	ETF	303.5	304.01	303.39	304.01	172484.0
2022-08-29 08:00:00	QQQ	ETF	303.9306	307.67	303.2804	304.42	240216.0
2022-08-29 08:30:00	QQQ	ETF	304.45	304.96	304.31	304.38	288175.0
2022-08-29 09:00:00	QQQ	ETF	304.4	304.97	304.04	304.61	304870.0
2022-08-29 09:30:00	QQQ	ETF	304.62	307.14	304.013	305.345	6719273.0
2022-08-29 10:00:00	QQQ	ETF	305.38	307.22	305.09	306.1199	3409906.0
2022-08-29 10:30:00	QQQ	ETF	306.111	306.6	303.53	303.66	3424901.0
2022-08-29 11:00:00	QQQ	ETF	303.64	304.52	303.28	303.7601	3020625.0
2022-08-29 11:30:00	QQQ	ETF	303.77	305.075	303.35	304.845	2865990.0
2022-08-29 12:00:00	QQQ	ETF	304.84	306.12	304.69	305.2868	2356297.0
2022-08-29 12:30:00	QQQ	ETF	305.28	306.64	304.55	306.03	1922557.0

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

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