PREVIEW / etf_30min / 2024-02-07

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-02-07.parquet
  size:    811 KB
  rows:    31,960

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-07 04:00:00	SPY	ETF	493.98	494.17	493.89	494.01	4143.0
2024-02-07 04:30:00	SPY	ETF	494.09	494.19	494.02	494.12	3465.0
2024-02-07 05:00:00	SPY	ETF	494.07	494.18	494.03	494.1	8355.0
2024-02-07 05:30:00	SPY	ETF	494.07	494.07	493.5	493.71	35329.0
2024-02-07 06:00:00	SPY	ETF	493.73	494.02	493.73	494.02	14213.0
2024-02-07 06:30:00	SPY	ETF	493.98	494.09	493.85	493.85	27208.0
2024-02-07 07:00:00	SPY	ETF	494.0	494.06	493.72	494.06	34592.0
2024-02-07 07:30:00	SPY	ETF	494.06	494.94	494.06	494.86	52714.0
2024-02-07 08:00:00	SPY	ETF	493.82	495.51	493.7502	495.44	182927.0
2024-02-07 08:30:00	SPY	ETF	495.44	495.75	495.33	495.53	110447.0
2024-02-07 09:00:00	SPY	ETF	495.56	496.3	495.55	496.28	284019.0
2024-02-07 09:30:00	SPY	ETF	496.29	496.44	495.36	495.89	5247056.0
2024-02-07 10:00:00	SPY	ETF	495.87	497.975	495.502	497.95	5872649.0
2024-02-07 10:30:00	SPY	ETF	497.96	498.04	497.03	497.26	5226953.0
2024-02-07 11:00:00	SPY	ETF	497.25	497.63	496.83	497.135	3207935.0
2024-02-07 11:30:00	SPY	ETF	497.14	497.86	496.87	497.5891	2883034.0
2024-02-07 12:00:00	SPY	ETF	497.59	497.855	497.205	497.3087	2123264.0
2024-02-07 12:30:00	SPY	ETF	497.32	497.6	496.79	497.56	2393056.0
2024-02-07 13:00:00	SPY	ETF	497.56	498.205	497.08	498.2	3338204.0
2024-02-07 13:30:00	SPY	ETF	498.21	498.43	497.66	498.071	2466355.0
2024-02-07 14:00:00	SPY	ETF	498.08	498.27	497.835	497.95	2327335.0
2024-02-07 14:30:00	SPY	ETF	497.96	498.35	497.79	498.325	1845724.0
2024-02-07 15:00:00	SPY	ETF	498.33	498.53	497.88	498.15	3348134.0
2024-02-07 15:30:00	SPY	ETF	498.15	498.27	497.61	498.05	7944925.0
2024-02-07 16:00:00	SPY	ETF	498.05	498.1	497.7699	497.93	2760995.0
2024-02-07 16:30:00	SPY	ETF	497.91	498.11	497.85	498.06	237855.0
2024-02-07 17:00:00	SPY	ETF	498.06	498.11	498.04	498.0984	42171.0
2024-02-07 17:30:00	SPY	ETF	498.08	498.1	497.99	498.01	16033.0
2024-02-07 18:00:00	SPY	ETF	498.01	498.06	497.7	497.83	79543.0
2024-02-07 18:30:00	SPY	ETF	497.84	497.87	497.77	497.87	11766.0
2024-02-07 19:00:00	SPY	ETF	497.88	497.92	497.81	497.85	5024.0
2024-02-07 19:30:00	SPY	ETF	497.83	497.87	497.7001	497.76	35209.0
2024-02-07 04:00:00	QQQ	ETF	427.57	428.06	427.41	427.93	32318.0
2024-02-07 04:30:00	QQQ	ETF	427.91	428.09	427.83	428.09	8226.0
2024-02-07 05:00:00	QQQ	ETF	427.98	428.24	427.93	428.14	16793.0
2024-02-07 05:30:00	QQQ	ETF	428.06	428.07	427.55	427.78	12415.0
2024-02-07 06:00:00	QQQ	ETF	427.67	428.07	427.66	428.04	27405.0
2024-02-07 06:30:00	QQQ	ETF	428.13	428.4	428.03	428.15	32394.0
2024-02-07 07:00:00	QQQ	ETF	428.18	428.18	427.56	428.04	36327.0
2024-02-07 07:30:00	QQQ	ETF	428.07	428.88	428.04	428.85	49569.0
2024-02-07 08:00:00	QQQ	ETF	427.9685	429.53	427.01	429.48	110638.0
2024-02-07 08:30:00	QQQ	ETF	429.49	429.75	429.3	429.5	100652.0
2024-02-07 09:00:00	QQQ	ETF	429.51	430.5	429.51	430.36	281052.0
2024-02-07 09:30:00	QQQ	ETF	430.41	430.51	429.09	429.755	3878025.0
2024-02-07 10:00:00	QQQ	ETF	429.73	432.6597	429.255	432.61	3834450.0
2024-02-07 10:30:00	QQQ	ETF	432.61	432.83	431.77	431.8399	3107656.0
2024-02-07 11:00:00	QQQ	ETF	431.83	432.3	431.24	431.69	2275000.0
2024-02-07 11:30:00	QQQ	ETF	431.72	432.3	431.09	432.08	1629510.0
2024-02-07 12:00:00	QQQ	ETF	432.0921	432.31	431.4299	431.4391	1413852.0
2024-02-07 12:30:00	QQQ	ETF	431.47	431.53	430.55	431.4899	1689873.0

> showing 50 of 31,960 rows — these rows as CSV

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