PREVIEW / etf_30min / 2022-03-02

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-03-02.parquet
  size:    684 KB
  rows:    27,044

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-02 04:00:00	SPY	ETF	429.3	430.86	428.87	429.87	21736.0
2022-03-02 04:30:00	SPY	ETF	430.08	433.6	429.98	433.16	48799.0
2022-03-02 05:00:00	SPY	ETF	433.03	434.0	432.65	433.24	38826.0
2022-03-02 05:30:00	SPY	ETF	432.93	433.2	432.11	432.41	34860.0
2022-03-02 06:00:00	SPY	ETF	432.59	433.18	432.01	433.18	12323.0
2022-03-02 06:30:00	SPY	ETF	433.2	433.59	432.74	433.02	27361.0
2022-03-02 07:00:00	SPY	ETF	432.95	433.61	432.42	432.58	143566.0
2022-03-02 07:30:00	SPY	ETF	432.58	432.71	431.62	432.6	148733.0
2022-03-02 08:00:00	SPY	ETF	433.15	433.57	427.87	431.86	390167.0
2022-03-02 08:30:00	SPY	ETF	431.9	432.38	430.42	431.46	418991.0
2022-03-02 09:00:00	SPY	ETF	431.43	432.56	431.42	432.38	338959.0
2022-03-02 09:30:00	SPY	ETF	432.41	434.77	431.9	433.63	8220778.0
2022-03-02 10:00:00	SPY	ETF	433.61	435.08	431.57	434.36	8491116.0
2022-03-02 10:30:00	SPY	ETF	434.34	435.68	433.35	434.51	8106561.0
2022-03-02 11:00:00	SPY	ETF	434.52	437.53	433.6	436.73	8128862.0
2022-03-02 11:30:00	SPY	ETF	436.73	438.3	436.26	437.1	6047282.0
2022-03-02 12:00:00	SPY	ETF	437.09	438.12	436.51	437.47	4522381.0
2022-03-02 12:30:00	SPY	ETF	437.5	438.08	437.13	437.7812	3713696.0
2022-03-02 13:00:00	SPY	ETF	437.78	439.085	437.78	438.5	4216225.0
2022-03-02 13:30:00	SPY	ETF	438.51	439.32	438.21	438.75	3198878.0
2022-03-02 14:00:00	SPY	ETF	438.77	439.46	437.9	438.39	4075596.0
2022-03-02 14:30:00	SPY	ETF	438.385	439.23	437.6304	437.9986	4027203.0
2022-03-02 15:00:00	SPY	ETF	437.97	439.01	437.68	438.6901	5080410.0
2022-03-02 15:30:00	SPY	ETF	438.705	439.72	437.67	437.83	14659146.0
2022-03-02 16:00:00	SPY	ETF	437.84	438.01	437.28	437.31	5194278.0
2022-03-02 16:30:00	SPY	ETF	437.3	437.41	436.7	437.05	331916.0
2022-03-02 17:00:00	SPY	ETF	437.0	437.89	436.9	437.02	72436.0
2022-03-02 17:30:00	SPY	ETF	436.98	437.2	436.55	436.82	48113.0
2022-03-02 18:00:00	SPY	ETF	436.94	437.32	436.78	437.08	36069.0
2022-03-02 18:30:00	SPY	ETF	437.1	437.33	436.87	437.2	52024.0
2022-03-02 19:00:00	SPY	ETF	437.26	437.43	437.06	437.15	25360.0
2022-03-02 19:30:00	SPY	ETF	437.2	437.3	437.01	437.28	50638.0
2022-03-02 04:00:00	QQQ	ETF	341.19	342.23	340.65	341.5	40426.0
2022-03-02 04:30:00	QQQ	ETF	341.67	344.19	341.67	343.69	55002.0
2022-03-02 05:00:00	QQQ	ETF	343.6	344.88	343.3	344.32	45858.0
2022-03-02 05:30:00	QQQ	ETF	344.15	344.3	343.24	343.8	49224.0
2022-03-02 06:00:00	QQQ	ETF	343.78	344.62	343.62	344.5	47514.0
2022-03-02 06:30:00	QQQ	ETF	344.64	344.85	343.88	344.08	36026.0
2022-03-02 07:00:00	QQQ	ETF	343.95	344.55	343.62	343.63	124729.0
2022-03-02 07:30:00	QQQ	ETF	343.7	343.75	343.08	343.59	99989.0
2022-03-02 08:00:00	QQQ	ETF	344.12	344.9296	339.79	342.7	281004.0
2022-03-02 08:30:00	QQQ	ETF	342.77	343.3	341.41	342.26	1634430.0
2022-03-02 09:00:00	QQQ	ETF	342.21	343.3	342.209	343.01	281555.0
2022-03-02 09:30:00	QQQ	ETF	343.08	344.62	341.725	343.26	7385360.0
2022-03-02 10:00:00	QQQ	ETF	343.25	344.07	340.24	343.595	6662318.0
2022-03-02 10:30:00	QQQ	ETF	343.56	344.47	341.76	342.62	6684150.0
2022-03-02 11:00:00	QQQ	ETF	342.63	346.22	341.76	345.47	5250866.0
2022-03-02 11:30:00	QQQ	ETF	345.5	346.87	344.88	345.415	3419658.0
2022-03-02 12:00:00	QQQ	ETF	345.41	346.57	345.07	345.83	2444825.0
2022-03-02 12:30:00	QQQ	ETF	345.85	346.49	345.4937	346.09	1607381.0

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

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