PREVIEW / etf_30min / 2022-11-07

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-11-07.parquet
  size:    683 KB
  rows:    27,459

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-07 04:00:00	SPY	ETF	375.0	377.89	375.0	377.69	48512.0
2022-11-07 04:30:00	SPY	ETF	377.7	377.78	377.05	377.05	8555.0
2022-11-07 05:00:00	SPY	ETF	377.1	378.23	377.06	378.18	42442.0
2022-11-07 05:30:00	SPY	ETF	378.17	378.35	377.82	378.27	14586.0
2022-11-07 06:00:00	SPY	ETF	378.35	378.79	378.18	378.39	32711.0
2022-11-07 06:30:00	SPY	ETF	378.44	378.85	378.28	378.28	32001.0
2022-11-07 07:00:00	SPY	ETF	378.22	378.85	377.94	378.15	106549.0
2022-11-07 07:30:00	SPY	ETF	378.01	378.18	377.61	377.9	190604.0
2022-11-07 08:00:00	SPY	ETF	378.78	378.82	374.5	377.08	494960.0
2022-11-07 08:30:00	SPY	ETF	377.1	377.57	376.89	377.3225	237020.0
2022-11-07 09:00:00	SPY	ETF	377.42	378.0	377.42	377.71	285060.0
2022-11-07 09:30:00	SPY	ETF	377.71	378.34	375.53	376.11	5187420.0
2022-11-07 10:00:00	SPY	ETF	376.11	378.39	376.01	376.85	4180954.0
2022-11-07 10:30:00	SPY	ETF	376.87	377.73	376.26	377.605	3086467.0
2022-11-07 11:00:00	SPY	ETF	377.62	378.08	376.875	377.79	2396642.0
2022-11-07 11:30:00	SPY	ETF	377.7901	378.15	376.21	376.22	2824127.0
2022-11-07 12:00:00	SPY	ETF	376.21	377.26	375.81	377.16	2472625.0
2022-11-07 12:30:00	SPY	ETF	377.16	377.37	376.55	377.0097	1565257.0
2022-11-07 13:00:00	SPY	ETF	377.0	377.9801	376.96	377.65	1988498.0
2022-11-07 13:30:00	SPY	ETF	377.6301	377.95	377.13	377.92	1966168.0
2022-11-07 14:00:00	SPY	ETF	377.92	379.6	377.92	379.47	4072746.0
2022-11-07 14:30:00	SPY	ETF	379.47	380.0	379.2	379.33	3476597.0
2022-11-07 15:00:00	SPY	ETF	379.335	380.33	379.32	380.19	3815053.0
2022-11-07 15:30:00	SPY	ETF	380.18	380.57	379.35	379.94	8830731.0
2022-11-07 16:00:00	SPY	ETF	379.94	380.04	379.4333	379.89	5454667.0
2022-11-07 16:30:00	SPY	ETF	379.86	379.95	379.44	379.68	1260681.0
2022-11-07 17:00:00	SPY	ETF	379.61	379.82	379.45	379.75	39681.0
2022-11-07 17:30:00	SPY	ETF	379.75	379.81	379.66	379.71	22934.0
2022-11-07 18:00:00	SPY	ETF	379.71	379.95	379.38	379.71	44956.0
2022-11-07 18:30:00	SPY	ETF	379.71	380.04	379.52	379.95	27919.0
2022-11-07 19:00:00	SPY	ETF	380.03	380.33	380.01	380.32	34333.0
2022-11-07 19:30:00	SPY	ETF	380.35	381.11	380.35	380.83	70600.0
2022-11-07 04:00:00	QQQ	ETF	264.0	265.93	264.0	265.45	48700.0
2022-11-07 04:30:00	QQQ	ETF	265.5	265.5	264.95	265.0	11515.0
2022-11-07 05:00:00	QQQ	ETF	264.91	265.8	264.91	265.74	18673.0
2022-11-07 05:30:00	QQQ	ETF	265.6	266.09	265.5	266.05	13339.0
2022-11-07 06:00:00	QQQ	ETF	266.05	266.53	265.95	266.24	27456.0
2022-11-07 06:30:00	QQQ	ETF	266.14	266.44	265.9	265.9	37170.0
2022-11-07 07:00:00	QQQ	ETF	265.91	266.3	265.55	265.65	104545.0
2022-11-07 07:30:00	QQQ	ETF	265.54	265.83	265.31	265.58	143910.0
2022-11-07 08:00:00	QQQ	ETF	265.5608	266.61	262.9	265.16	540988.0
2022-11-07 08:30:00	QQQ	ETF	265.22	265.53	265.02	265.45	326871.0
2022-11-07 09:00:00	QQQ	ETF	265.46	265.9	265.41	265.76	261822.0
2022-11-07 09:30:00	QQQ	ETF	265.75	266.485	263.57	264.42	4740709.0
2022-11-07 10:00:00	QQQ	ETF	264.44	266.31	264.24	264.61	3589478.0
2022-11-07 10:30:00	QQQ	ETF	264.66	265.5143	263.97	265.456	2296943.0
2022-11-07 11:00:00	QQQ	ETF	265.47	265.97	264.55	265.71	1864110.0
2022-11-07 11:30:00	QQQ	ETF	265.71	266.02	264.0109	264.02	2309152.0
2022-11-07 12:00:00	QQQ	ETF	264.02	264.92	263.61	264.755	1858158.0
2022-11-07 12:30:00	QQQ	ETF	264.76	265.04	264.3506	264.79	1307355.0

> showing 50 of 27,459 rows — these rows as CSV

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