PREVIEW / etf_30min / 2022-07-01

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-07-01.parquet
  size:    656 KB
  rows:    26,191

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-07-01 04:00:00	SPY	ETF	374.69	375.9	373.8	375.84	27188.0
2022-07-01 04:30:00	SPY	ETF	375.98	376.34	375.63	376.11	21604.0
2022-07-01 05:00:00	SPY	ETF	376.11	376.92	375.82	376.48	43701.0
2022-07-01 05:30:00	SPY	ETF	376.6	377.2	376.28	377.11	30054.0
2022-07-01 06:00:00	SPY	ETF	377.25	377.8	376.48	377.05	42255.0
2022-07-01 06:30:00	SPY	ETF	376.74	376.74	375.71	375.74	21632.0
2022-07-01 07:00:00	SPY	ETF	375.88	376.4	375.68	376.31	111579.0
2022-07-01 07:30:00	SPY	ETF	376.27	376.34	374.75	375.31	97801.0
2022-07-01 08:00:00	SPY	ETF	375.5801	377.19	373.5	375.65	209719.0
2022-07-01 08:30:00	SPY	ETF	375.65	376.77	375.58	376.3	268840.0
2022-07-01 09:00:00	SPY	ETF	376.51	377.04	376.24	376.55	380586.0
2022-07-01 09:30:00	SPY	ETF	376.53	379.71	375.75	378.69	7040279.0
2022-07-01 10:00:00	SPY	ETF	378.69	380.03	374.86	375.0301	7200632.0
2022-07-01 10:30:00	SPY	ETF	375.04	376.16	373.8	375.4	4454554.0
2022-07-01 11:00:00	SPY	ETF	375.4	377.51	374.69	376.2655	3730129.0
2022-07-01 11:30:00	SPY	ETF	376.27	377.2673	375.06	375.4	2354520.0
2022-07-01 12:00:00	SPY	ETF	375.44	377.03	374.9001	376.82	2050775.0
2022-07-01 12:30:00	SPY	ETF	376.82	377.1399	375.6632	375.67	1879925.0
2022-07-01 13:00:00	SPY	ETF	375.68	376.84	375.46	376.77	2108809.0
2022-07-01 13:30:00	SPY	ETF	376.81	378.32	376.68	378.2197	3118695.0
2022-07-01 14:00:00	SPY	ETF	378.23	379.48	377.3	378.98	3002292.0
2022-07-01 14:30:00	SPY	ETF	378.975	380.19	378.975	379.9	3388174.0
2022-07-01 15:00:00	SPY	ETF	379.9	380.67	378.93	380.17	4006389.0
2022-07-01 15:30:00	SPY	ETF	380.18	381.7	380.15	381.2	10090010.0
2022-07-01 16:00:00	SPY	ETF	381.2	381.42	380.9	381.05	3542433.0
2022-07-01 16:30:00	SPY	ETF	381.1	381.2	380.94	381.02	232029.0
2022-07-01 17:00:00	SPY	ETF	381.18	381.18	380.94	381.1	85072.0
2022-07-01 17:30:00	SPY	ETF	381.12	381.2	381.07	381.2	33313.0
2022-07-01 18:00:00	SPY	ETF	381.15	381.48	381.14	381.39	9083.0
2022-07-01 18:30:00	SPY	ETF	381.39	381.4	380.95	381.08	10045.0
2022-07-01 19:00:00	SPY	ETF	381.14	381.24	381.0	381.1	7728.0
2022-07-01 19:30:00	SPY	ETF	381.06	381.26	381.02	381.07	8450.0
2022-07-01 04:00:00	QQQ	ETF	277.98	279.01	277.29	278.98	97361.0
2022-07-01 04:30:00	QQQ	ETF	279.08	279.31	278.84	279.19	211228.0
2022-07-01 05:00:00	QQQ	ETF	279.17	279.81	278.9	279.43	33628.0
2022-07-01 05:30:00	QQQ	ETF	279.43	279.94	279.11	279.9	23557.0
2022-07-01 06:00:00	QQQ	ETF	279.93	279.93	279.2	279.48	26978.0
2022-07-01 06:30:00	QQQ	ETF	279.37	279.43	278.44	278.58	66284.0
2022-07-01 07:00:00	QQQ	ETF	278.64	279.34	278.47	279.27	99024.0
2022-07-01 07:30:00	QQQ	ETF	279.27	279.27	277.7	278.13	187645.0
2022-07-01 08:00:00	QQQ	ETF	278.12	279.9396	277.29	278.6	355711.0
2022-07-01 08:30:00	QQQ	ETF	278.49	279.58	278.44	279.24	275340.0
2022-07-01 09:00:00	QQQ	ETF	279.33	279.68	278.9	278.91	450751.0
2022-07-01 09:30:00	QQQ	ETF	278.95	281.82	277.4	280.846	7925399.0
2022-07-01 10:00:00	QQQ	ETF	280.87	282.26	277.95	278.14	5161059.0
2022-07-01 10:30:00	QQQ	ETF	278.15	279.16	277.03	278.38	3799678.0
2022-07-01 11:00:00	QQQ	ETF	278.38	280.16	277.63	279.012	3027674.0
2022-07-01 11:30:00	QQQ	ETF	279.04	279.91	277.94	278.28	2026627.0
2022-07-01 12:00:00	QQQ	ETF	278.27	279.28	277.65	279.12	1547489.0
2022-07-01 12:30:00	QQQ	ETF	279.094	279.34	277.88	277.88	1876163.0

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

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