PREVIEW / etf_30min / 2022-02-25

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-02-25.parquet
  size:    683 KB
  rows:    27,393

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-02-25 04:00:00	SPY	ETF	423.47	424.49	422.82	423.14	37514.0
2022-02-25 04:30:00	SPY	ETF	423.05	425.77	422.99	425.19	34806.0
2022-02-25 05:00:00	SPY	ETF	424.86	426.35	424.74	425.5	30244.0
2022-02-25 05:30:00	SPY	ETF	425.73	426.12	425.22	425.47	10506.0
2022-02-25 06:00:00	SPY	ETF	425.54	425.84	423.72	425.01	33822.0
2022-02-25 06:30:00	SPY	ETF	424.96	426.61	424.2	425.4	85932.0
2022-02-25 07:00:00	SPY	ETF	425.29	427.3	425.09	426.63	263226.0
2022-02-25 07:30:00	SPY	ETF	426.7	429.61	426.08	429.17	896074.0
2022-02-25 08:00:00	SPY	ETF	425.3001	430.48	423.09	430.03	871844.0
2022-02-25 08:30:00	SPY	ETF	430.15	431.5	429.63	430.18	830819.0
2022-02-25 09:00:00	SPY	ETF	430.12	430.34	428.79	429.59	644606.0
2022-02-25 09:30:00	SPY	ETF	429.61	431.26	428.26	428.52	9378378.0
2022-02-25 10:00:00	SPY	ETF	428.49	432.26	427.86	431.87	7571837.0
2022-02-25 10:30:00	SPY	ETF	431.86	433.98	430.54	433.27	6417804.0
2022-02-25 11:00:00	SPY	ETF	433.25	435.79	432.45	435.225	7315145.0
2022-02-25 11:30:00	SPY	ETF	435.24	436.84	434.53	436.72	6035820.0
2022-02-25 12:00:00	SPY	ETF	436.74	436.98	435.49	436.64	4780226.0
2022-02-25 12:30:00	SPY	ETF	436.65	437.3	435.35	435.8081	5550080.0
2022-02-25 13:00:00	SPY	ETF	435.8	436.81	434.83	436.56	5512414.0
2022-02-25 13:30:00	SPY	ETF	436.56	437.73	436.13	436.6	5163550.0
2022-02-25 14:00:00	SPY	ETF	436.62	437.38	435.744	437.04	4264184.0
2022-02-25 14:30:00	SPY	ETF	437.02	437.54	435.01	436.0605	5493933.0
2022-02-25 15:00:00	SPY	ETF	436.07	437.41	435.11	436.6199	5339193.0
2022-02-25 15:30:00	SPY	ETF	436.61	437.84	435.9901	437.68	15522751.0
2022-02-25 16:00:00	SPY	ETF	437.67	438.0	437.41	437.98	4210429.0
2022-02-25 16:30:00	SPY	ETF	437.98	438.05	437.66	437.78	351216.0
2022-02-25 17:00:00	SPY	ETF	437.86	438.06	437.7	438.02	76833.0
2022-02-25 17:30:00	SPY	ETF	438.0	438.4	437.9	438.06	68382.0
2022-02-25 18:00:00	SPY	ETF	438.15	438.15	437.85	438.14	47371.0
2022-02-25 18:30:00	SPY	ETF	438.13	438.13	437.85	438.0	6054.0
2022-02-25 19:00:00	SPY	ETF	438.03	438.03	437.67	437.67	17839.0
2022-02-25 19:30:00	SPY	ETF	437.83	437.94	437.63	437.7	27578.0
2022-02-25 04:00:00	QQQ	ETF	337.89	337.89	335.84	336.2	55460.0
2022-02-25 04:30:00	QQQ	ETF	336.22	338.67	336.14	338.28	35301.0
2022-02-25 05:00:00	QQQ	ETF	338.27	339.54	338.0	339.01	57515.0
2022-02-25 05:30:00	QQQ	ETF	339.05	339.27	338.6	339.14	28456.0
2022-02-25 06:00:00	QQQ	ETF	339.22	339.22	337.47	338.57	48359.0
2022-02-25 06:30:00	QQQ	ETF	338.49	340.0	338.2	338.88	151745.0
2022-02-25 07:00:00	QQQ	ETF	338.79	340.4	338.73	339.84	130823.0
2022-02-25 07:30:00	QQQ	ETF	339.85	342.03	339.16	341.61	374276.0
2022-02-25 08:00:00	QQQ	ETF	339.8399	342.98	336.0296	342.55	692577.0
2022-02-25 08:30:00	QQQ	ETF	342.56	344.06	342.29	342.47	756332.0
2022-02-25 09:00:00	QQQ	ETF	342.41	342.58	340.84	341.32	692424.0
2022-02-25 09:30:00	QQQ	ETF	341.31	341.81	338.05	338.28	9542668.0
2022-02-25 10:00:00	QQQ	ETF	338.3	341.61	337.39	341.26	6271176.0
2022-02-25 10:30:00	QQQ	ETF	341.24	343.63	340.01	342.87	4710881.0
2022-02-25 11:00:00	QQQ	ETF	342.84	344.97	341.97	344.39	4894921.0
2022-02-25 11:30:00	QQQ	ETF	344.43	345.45	343.53	345.4029	3455622.0
2022-02-25 12:00:00	QQQ	ETF	345.44	345.74	343.955	344.9537	2813758.0
2022-02-25 12:30:00	QQQ	ETF	344.99	345.58	342.785	343.39	2946608.0

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

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