PREVIEW / etf_30min / 2022-03-04

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-03-04.parquet
  size:    681 KB
  rows:    27,373

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-03-04 04:00:00	SPY	ETF	431.62	432.96	431.34	432.54	89050.0
2022-03-04 04:30:00	SPY	ETF	432.37	433.07	431.44	432.19	37220.0
2022-03-04 05:00:00	SPY	ETF	432.15	433.5	431.89	433.46	34153.0
2022-03-04 05:30:00	SPY	ETF	433.59	433.59	431.95	432.0	46413.0
2022-03-04 06:00:00	SPY	ETF	432.04	432.29	431.39	432.05	54547.0
2022-03-04 06:30:00	SPY	ETF	432.25	432.6	431.87	431.94	63510.0
2022-03-04 07:00:00	SPY	ETF	432.12	432.3	430.74	430.81	144030.0
2022-03-04 07:30:00	SPY	ETF	430.79	432.49	430.78	432.2	192099.0
2022-03-04 08:00:00	SPY	ETF	431.7099	436.096	430.76	432.1	414035.0
2022-03-04 08:30:00	SPY	ETF	432.03	434.24	431.18	431.58	955276.0
2022-03-04 09:00:00	SPY	ETF	431.66	432.25	430.94	431.7	463843.0
2022-03-04 09:30:00	SPY	ETF	431.75	432.49	429.37	431.79	10439464.0
2022-03-04 10:00:00	SPY	ETF	431.78	432.43	428.71	429.8	7958113.0
2022-03-04 10:30:00	SPY	ETF	429.81	430.53	428.35	428.51	6441841.0
2022-03-04 11:00:00	SPY	ETF	428.51	429.455	427.88	428.98	5529699.0
2022-03-04 11:30:00	SPY	ETF	428.97	430.02	428.0	429.22	5026247.0
2022-03-04 12:00:00	SPY	ETF	429.2265	431.89	428.72	431.47	5377557.0
2022-03-04 12:30:00	SPY	ETF	431.45	432.35	430.51	431.935	3922284.0
2022-03-04 13:00:00	SPY	ETF	431.94	433.37	431.69	431.81	4929846.0
2022-03-04 13:30:00	SPY	ETF	431.78	432.87	430.31	430.48	3385654.0
2022-03-04 14:00:00	SPY	ETF	430.48	431.86	429.68	431.2143	5543269.0
2022-03-04 14:30:00	SPY	ETF	431.2	431.64	429.2	429.31	3597633.0
2022-03-04 15:00:00	SPY	ETF	429.32	431.4	429.22	430.71	5707271.0
2022-03-04 15:30:00	SPY	ETF	430.71	432.63	429.59	432.24	14325337.0
2022-03-04 16:00:00	SPY	ETF	432.24	432.3068	431.52	431.79	3698424.0
2022-03-04 16:30:00	SPY	ETF	431.77	432.23	431.6	431.78	343833.0
2022-03-04 17:00:00	SPY	ETF	431.62	432.1	431.62	432.04	105313.0
2022-03-04 17:30:00	SPY	ETF	432.06	432.17	431.51	431.67	35776.0
2022-03-04 18:00:00	SPY	ETF	431.7	431.75	431.3	431.4	35389.0
2022-03-04 18:30:00	SPY	ETF	431.48	431.94	430.0	431.15	37755.0
2022-03-04 19:00:00	SPY	ETF	431.15	431.39	431.09	431.24	15696.0
2022-03-04 19:30:00	SPY	ETF	431.25	431.5	431.17	431.28	5913.0
2022-03-04 04:00:00	QQQ	ETF	340.2	340.24	338.83	339.63	86548.0
2022-03-04 04:30:00	QQQ	ETF	339.6	340.07	338.72	339.25	41085.0
2022-03-04 05:00:00	QQQ	ETF	339.41	341.0	339.41	341.0	49648.0
2022-03-04 05:30:00	QQQ	ETF	341.0	341.0	339.28	339.56	97297.0
2022-03-04 06:00:00	QQQ	ETF	339.21	339.99	339.0	339.65	84110.0
2022-03-04 06:30:00	QQQ	ETF	339.65	340.08	339.23	339.56	59171.0
2022-03-04 07:00:00	QQQ	ETF	339.73	339.91	338.33	338.48	163385.0
2022-03-04 07:30:00	QQQ	ETF	338.44	339.93	338.43	339.77	223874.0
2022-03-04 08:00:00	QQQ	ETF	339.4401	342.516	338.36	339.66	327266.0
2022-03-04 08:30:00	QQQ	ETF	339.68	341.51	338.5	339.19	997780.0
2022-03-04 09:00:00	QQQ	ETF	339.16	339.81	338.51	339.8	437593.0
2022-03-04 09:30:00	QQQ	ETF	339.83	341.31	337.35	339.54	7631871.0
2022-03-04 10:00:00	QQQ	ETF	339.51	340.19	336.51	337.25	5442319.0
2022-03-04 10:30:00	QQQ	ETF	337.25	338.27	335.95	336.07	4367698.0
2022-03-04 11:00:00	QQQ	ETF	336.08	336.4593	334.92	336.08	4408348.0
2022-03-04 11:30:00	QQQ	ETF	336.04	337.11	335.1324	336.21	3129628.0
2022-03-04 12:00:00	QQQ	ETF	336.22	338.68	335.6632	338.201	4021947.0
2022-03-04 12:30:00	QQQ	ETF	338.19	338.68	336.93	338.13	2834974.0

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

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