PREVIEW / etf_30min / 2024-09-27

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-09-27.parquet
  size:    855 KB
  rows:    33,784

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-09-27 04:00:00	SPY	ETF	571.44	572.37	571.4	572.22	9137.0
2024-09-27 04:30:00	SPY	ETF	572.33	572.52	572.0	572.0	3926.0
2024-09-27 05:00:00	SPY	ETF	572.07	572.54	572.07	572.19	7148.0
2024-09-27 05:30:00	SPY	ETF	572.0	572.42	571.85	572.4	2096.0
2024-09-27 06:00:00	SPY	ETF	572.37	572.55	572.2	572.23	1537.0
2024-09-27 06:30:00	SPY	ETF	572.24	572.25	571.98	572.11	10698.0
2024-09-27 07:00:00	SPY	ETF	572.07	572.33	572.02	572.3	14642.0
2024-09-27 07:30:00	SPY	ETF	572.43	572.71	572.31	572.64	21373.0
2024-09-27 08:00:00	SPY	ETF	572.0942	573.08	571.5	573.03	109410.0
2024-09-27 08:30:00	SPY	ETF	573.0	573.9	572.85	573.58	233198.0
2024-09-27 09:00:00	SPY	ETF	573.55	573.7	573.23	573.38	137669.0
2024-09-27 09:30:00	SPY	ETF	573.39	573.56	572.705	573.0	2709184.0
2024-09-27 10:00:00	SPY	ETF	573.02	574.22	572.64	573.85	2094645.0
2024-09-27 10:30:00	SPY	ETF	573.855	573.951	573.24	573.71	1490780.0
2024-09-27 11:00:00	SPY	ETF	573.665	573.72	572.92	573.2827	1006849.0
2024-09-27 11:30:00	SPY	ETF	573.2975	573.31	572.41	572.44	1128141.0
2024-09-27 12:00:00	SPY	ETF	572.435	572.63	571.85	572.23	1392995.0
2024-09-27 12:30:00	SPY	ETF	572.2307	572.4857	572.02	572.19	730647.0
2024-09-27 13:00:00	SPY	ETF	572.1916	572.71	571.7502	571.775	954191.0
2024-09-27 13:30:00	SPY	ETF	571.77	572.46	571.53	572.43	1104191.0
2024-09-27 14:00:00	SPY	ETF	572.43	572.65	571.18	571.205	1597970.0
2024-09-27 14:30:00	SPY	ETF	571.21	572.39	570.42	572.19	2458949.0
2024-09-27 15:00:00	SPY	ETF	572.19	572.34	571.61	571.9771	1933367.0
2024-09-27 15:30:00	SPY	ETF	571.97	572.1143	571.32	571.41	4944580.0
2024-09-27 16:00:00	SPY	ETF	571.4	571.7531	571.01	571.24	2379513.0
2024-09-27 16:30:00	SPY	ETF	571.25	571.47	570.84	570.92	253435.0
2024-09-27 17:00:00	SPY	ETF	570.81	571.47	570.81	571.17	71663.0
2024-09-27 17:30:00	SPY	ETF	571.17	571.35	571.05	571.23	98553.0
2024-09-27 18:00:00	SPY	ETF	571.23	571.23	570.77	570.79	25328.0
2024-09-27 18:30:00	SPY	ETF	570.8	571.06	570.8	571.0	1383.0
2024-09-27 19:00:00	SPY	ETF	570.81	571.09	570.81	571.09	891.0
2024-09-27 19:30:00	SPY	ETF	571.0	571.0	570.65	570.67	14471.0
2024-09-27 04:00:00	QQQ	ETF	487.38	488.87	487.38	488.83	68000.0
2024-09-27 04:30:00	QQQ	ETF	488.87	489.18	488.26	488.38	28168.0
2024-09-27 05:00:00	QQQ	ETF	488.62	489.22	488.36	488.79	25497.0
2024-09-27 05:30:00	QQQ	ETF	488.54	489.04	488.22	488.81	11368.0
2024-09-27 06:00:00	QQQ	ETF	489.0	489.14	488.59	488.59	11002.0
2024-09-27 06:30:00	QQQ	ETF	488.65	488.71	488.23	488.53	13210.0
2024-09-27 07:00:00	QQQ	ETF	488.53	489.05	488.47	489.01	30543.0
2024-09-27 07:30:00	QQQ	ETF	489.01	489.75	489.01	489.73	46453.0
2024-09-27 08:00:00	QQQ	ETF	489.73	490.37	487.3	490.23	93934.0
2024-09-27 08:30:00	QQQ	ETF	490.27	490.96	489.98	490.5	219264.0
2024-09-27 09:00:00	QQQ	ETF	490.5	490.85	490.34	490.6	85963.0
2024-09-27 09:30:00	QQQ	ETF	490.5	490.64	488.9	489.2258	1757383.0
2024-09-27 10:00:00	QQQ	ETF	489.28	490.38	488.23	488.91	1429099.0
2024-09-27 10:30:00	QQQ	ETF	488.91	489.35	487.92	488.74	1074717.0
2024-09-27 11:00:00	QQQ	ETF	488.715	488.83	487.3	487.87	1047131.0
2024-09-27 11:30:00	QQQ	ETF	487.89	488.2392	486.98	487.08	1116060.0
2024-09-27 12:00:00	QQQ	ETF	487.06	487.66	486.48	487.48	939074.0
2024-09-27 12:30:00	QQQ	ETF	487.47	487.86	487.33	487.71	544777.0

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

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