PREVIEW / etf_30min / 2024-02-20

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-02-20.parquet
  size:    807 KB
  rows:    32,618

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
2024-02-20 04:00:00	SPY	ETF	498.33	498.65	498.01	498.01	21630.0
2024-02-20 04:30:00	SPY	ETF	498.05	498.26	497.84	498.1	8704.0
2024-02-20 05:00:00	SPY	ETF	497.89	497.89	497.38	497.62	12191.0
2024-02-20 05:30:00	SPY	ETF	497.56	497.75	497.45	497.45	15685.0
2024-02-20 06:00:00	SPY	ETF	497.5	497.53	497.0	497.42	23348.0
2024-02-20 06:30:00	SPY	ETF	497.59	497.93	497.43	497.92	9765.0
2024-02-20 07:00:00	SPY	ETF	497.95	498.25	497.64	498.2	71406.0
2024-02-20 07:30:00	SPY	ETF	498.27	498.28	497.75	497.96	17890.0
2024-02-20 08:00:00	SPY	ETF	497.78	498.6896	497.4204	497.82	87050.0
2024-02-20 08:30:00	SPY	ETF	497.79	499.51	497.51	497.75	107769.0
2024-02-20 09:00:00	SPY	ETF	497.79	497.91	497.45	497.66	154799.0
2024-02-20 09:30:00	SPY	ETF	497.72	498.41	496.17	496.6801	6223388.0
2024-02-20 10:00:00	SPY	ETF	496.68	496.74	495.86	496.2199	4579656.0
2024-02-20 10:30:00	SPY	ETF	496.21	497.03	495.745	497.02	3750074.0
2024-02-20 11:00:00	SPY	ETF	497.02	497.3	496.56	496.92	2451090.0
2024-02-20 11:30:00	SPY	ETF	496.93	496.98	495.67	495.74	2674222.0
2024-02-20 12:00:00	SPY	ETF	495.75	495.76	494.77	495.06	3547424.0
2024-02-20 12:30:00	SPY	ETF	495.06	495.62	494.45	495.4889	3197491.0
2024-02-20 13:00:00	SPY	ETF	495.48	495.98	494.9	495.2	2570496.0
2024-02-20 13:30:00	SPY	ETF	495.2	495.9196	494.75	495.8982	2509178.0
2024-02-20 14:00:00	SPY	ETF	495.9	496.06	495.205	496.01	2770669.0
2024-02-20 14:30:00	SPY	ETF	496.01	496.8	495.69	496.715	2795074.0
2024-02-20 15:00:00	SPY	ETF	496.72	496.88	496.24	496.71	2919904.0
2024-02-20 15:30:00	SPY	ETF	496.72	496.835	495.1	496.74	12558238.0
2024-02-20 16:00:00	SPY	ETF	496.74	496.78	496.13	496.42	2295953.0
2024-02-20 16:30:00	SPY	ETF	496.45	496.7	496.4	496.5	126479.0
2024-02-20 17:00:00	SPY	ETF	496.51	496.6	496.26	496.26	66660.0
2024-02-20 17:30:00	SPY	ETF	496.26	496.76	496.21	496.45	76576.0
2024-02-20 18:00:00	SPY	ETF	496.35	496.8	496.26	496.78	42894.0
2024-02-20 18:30:00	SPY	ETF	496.71	496.71	496.31	496.39	20000.0
2024-02-20 19:00:00	SPY	ETF	496.33	496.65	496.26	496.49	5450.0
2024-02-20 19:30:00	SPY	ETF	496.46	496.46	496.03	496.06	16370.0
2024-02-20 04:00:00	QQQ	ETF	429.07	429.81	428.71	428.8	44295.0
2024-02-20 04:30:00	QQQ	ETF	428.74	428.82	428.46	428.75	42010.0
2024-02-20 05:00:00	QQQ	ETF	428.39	428.39	427.56	427.84	37202.0
2024-02-20 05:30:00	QQQ	ETF	427.88	428.05	427.72	427.73	23276.0
2024-02-20 06:00:00	QQQ	ETF	427.6	427.98	427.44	427.84	30840.0
2024-02-20 06:30:00	QQQ	ETF	427.96	428.39	427.8	428.32	52493.0
2024-02-20 07:00:00	QQQ	ETF	428.39	429.06	428.25	429.06	114153.0
2024-02-20 07:30:00	QQQ	ETF	429.05	429.15	428.58	428.84	95850.0
2024-02-20 08:00:00	QQQ	ETF	428.79	429.96	427.8104	428.7	150108.0
2024-02-20 08:30:00	QQQ	ETF	428.9	429.47	428.44	428.82	467849.0
2024-02-20 09:00:00	QQQ	ETF	428.79	429.0	428.22	428.54	164109.0
2024-02-20 09:30:00	QQQ	ETF	428.54	430.08	425.69	426.16	6756214.0
2024-02-20 10:00:00	QQQ	ETF	426.14	426.22	424.72	424.85	3957725.0
2024-02-20 10:30:00	QQQ	ETF	424.85	426.5	424.21	426.45	3405301.0
2024-02-20 11:00:00	QQQ	ETF	426.45	427.02	425.98	426.4	2385076.0
2024-02-20 11:30:00	QQQ	ETF	426.41	426.42	424.7413	424.77	2090949.0
2024-02-20 12:00:00	QQQ	ETF	424.77	424.95	423.655	423.99	2532258.0
2024-02-20 12:30:00	QQQ	ETF	424.0	425.01	423.5	424.74	2417308.0

> showing 50 of 32,618 rows — these rows as CSV

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