PREVIEW / etf_30min / 2024-06-17

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-06-17.parquet
  size:    834 KB
  rows:    33,185

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-06-17 04:00:00	SPY	ETF	542.55	543.4	542.55	542.93	12280.0
2024-06-17 04:30:00	SPY	ETF	542.87	542.87	542.33	542.42	2415.0
2024-06-17 05:00:00	SPY	ETF	542.43	542.63	542.38	542.54	15269.0
2024-06-17 05:30:00	SPY	ETF	542.57	542.57	542.55	542.57	805.0
2024-06-17 06:00:00	SPY	ETF	542.41	542.41	541.94	541.98	18331.0
2024-06-17 06:30:00	SPY	ETF	542.06	542.36	542.06	542.18	6217.0
2024-06-17 07:00:00	SPY	ETF	542.41	542.82	542.34	542.82	24705.0
2024-06-17 07:30:00	SPY	ETF	542.81	542.81	542.59	542.71	24583.0
2024-06-17 08:00:00	SPY	ETF	542.47	543.38	542.3296	542.56	61631.0
2024-06-17 08:30:00	SPY	ETF	542.5	542.56	542.03	542.34	92204.0
2024-06-17 09:00:00	SPY	ETF	542.3	542.3	542.09	542.09	72909.0
2024-06-17 09:30:00	SPY	ETF	542.08	542.4799	541.6072	542.1	2615093.0
2024-06-17 10:00:00	SPY	ETF	542.1	542.89	541.89	542.31	1881059.0
2024-06-17 10:30:00	SPY	ETF	542.3	542.99	542.2107	542.93	1498331.0
2024-06-17 11:00:00	SPY	ETF	542.9405	544.03	542.9405	543.82	1600541.0
2024-06-17 11:30:00	SPY	ETF	543.82	543.91	543.48	543.7	1049059.0
2024-06-17 12:00:00	SPY	ETF	543.69	545.43	543.66	545.41	1599710.0
2024-06-17 12:30:00	SPY	ETF	545.42	545.91	545.16	545.4099	1890851.0
2024-06-17 13:00:00	SPY	ETF	545.4	546.55	545.4	546.35	1551503.0
2024-06-17 13:30:00	SPY	ETF	546.375	547.53	546.31	547.41	2598801.0
2024-06-17 14:00:00	SPY	ETF	547.4	548.53	547.31	548.01	2755446.0
2024-06-17 14:30:00	SPY	ETF	548.01	548.17	547.46	547.7657	2057243.0
2024-06-17 15:00:00	SPY	ETF	547.76	548.39	547.46	548.27	2143368.0
2024-06-17 15:30:00	SPY	ETF	548.27	548.29	546.74	547.05	7237952.0
2024-06-17 16:00:00	SPY	ETF	547.03	547.1	546.59	547.03	4145239.0
2024-06-17 16:30:00	SPY	ETF	547.07	547.1	546.91	547.03	78104.0
2024-06-17 17:00:00	SPY	ETF	546.94	547.05	546.94	547.0154	51362.0
2024-06-17 17:30:00	SPY	ETF	547.0	547.07	546.99	547.07	27424.0
2024-06-17 18:00:00	SPY	ETF	547.03	547.64	546.99	547.5	89599.0
2024-06-17 18:30:00	SPY	ETF	547.42	547.5	547.36	547.36	4476.0
2024-06-17 19:00:00	SPY	ETF	547.48	547.51	547.21	547.39	8673.0
2024-06-17 19:30:00	SPY	ETF	547.55	547.6	547.46	547.54	8575.0
2024-06-17 04:00:00	QQQ	ETF	479.6	480.74	479.6	480.26	48703.0
2024-06-17 04:30:00	QQQ	ETF	480.22	480.22	479.52	479.84	31172.0
2024-06-17 05:00:00	QQQ	ETF	479.82	479.88	479.59	479.87	4721.0
2024-06-17 05:30:00	QQQ	ETF	479.88	480.04	479.8	479.94	6196.0
2024-06-17 06:00:00	QQQ	ETF	480.05	480.07	479.41	479.41	18426.0
2024-06-17 06:30:00	QQQ	ETF	479.6	479.76	479.54	479.63	23698.0
2024-06-17 07:00:00	QQQ	ETF	479.68	480.15	479.66	480.15	41849.0
2024-06-17 07:30:00	QQQ	ETF	480.14	480.16	479.8	479.98	64649.0
2024-06-17 08:00:00	QQQ	ETF	479.69	480.22	479.05	479.8201	142617.0
2024-06-17 08:30:00	QQQ	ETF	479.83	479.83	479.15	479.42	140210.0
2024-06-17 09:00:00	QQQ	ETF	479.43	479.49	479.17	479.43	104719.0
2024-06-17 09:30:00	QQQ	ETF	479.46	479.82	478.14	479.38	2637494.0
2024-06-17 10:00:00	QQQ	ETF	479.38	480.09	478.79	479.23	1687341.0
2024-06-17 10:30:00	QQQ	ETF	479.27	479.98	479.17	479.93	1034568.0
2024-06-17 11:00:00	QQQ	ETF	479.95	480.94	479.95	480.75	1249356.0
2024-06-17 11:30:00	QQQ	ETF	480.745	481.05	480.53	480.82	880652.0
2024-06-17 12:00:00	QQQ	ETF	480.82	482.47	480.6621	482.44	1082924.0
2024-06-17 12:30:00	QQQ	ETF	482.45	483.22	482.15	482.695	2089016.0

> showing 50 of 33,185 rows — these rows as CSV

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