PREVIEW / etf_30min / 2024-04-16

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-04-16.parquet
  size:    807 KB
  rows:    33,147

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-04-16 04:00:00	SPY	ETF	504.4	504.54	504.07	504.29	27761.0
2024-04-16 04:30:00	SPY	ETF	504.37	504.51	504.04	504.51	10187.0
2024-04-16 05:00:00	SPY	ETF	504.3	504.49	503.71	504.08	7745.0
2024-04-16 05:30:00	SPY	ETF	504.23	504.23	503.24	503.8	21411.0
2024-04-16 06:00:00	SPY	ETF	503.87	503.87	503.1	503.38	13284.0
2024-04-16 06:30:00	SPY	ETF	503.4	504.48	503.2	504.43	87051.0
2024-04-16 07:00:00	SPY	ETF	504.45	505.39	504.36	505.04	229440.0
2024-04-16 07:30:00	SPY	ETF	505.04	506.24	505.03	506.03	328472.0
2024-04-16 08:00:00	SPY	ETF	506.02	506.1682	503.4	504.83	321662.0
2024-04-16 08:30:00	SPY	ETF	504.96	506.19	504.61	505.5	295214.0
2024-04-16 09:00:00	SPY	ETF	505.5	505.76	504.79	504.9	345881.0
2024-04-16 09:30:00	SPY	ETF	504.94	505.2	502.95	504.44	6766535.0
2024-04-16 10:00:00	SPY	ETF	504.42	505.28	503.18	503.18	3803040.0
2024-04-16 10:30:00	SPY	ETF	503.17	503.77	502.42	503.1015	3997370.0
2024-04-16 11:00:00	SPY	ETF	503.1	504.34	502.875	504.1821	2859657.0
2024-04-16 11:30:00	SPY	ETF	504.185	505.36	503.63	504.245	2875448.0
2024-04-16 12:00:00	SPY	ETF	504.24	505.0	503.5	504.4901	2528339.0
2024-04-16 12:30:00	SPY	ETF	504.49	505.1	504.15	504.5187	1862262.0
2024-04-16 13:00:00	SPY	ETF	504.55	505.05	503.74	504.33	2412922.0
2024-04-16 13:30:00	SPY	ETF	504.34	504.855	502.21	503.9699	6560996.0
2024-04-16 14:00:00	SPY	ETF	503.96	506.5	502.6	503.04	6372993.0
2024-04-16 14:30:00	SPY	ETF	503.04	505.81	502.99	505.8	3309833.0
2024-04-16 15:00:00	SPY	ETF	505.81	505.8598	504.7	505.62	3257734.0
2024-04-16 15:30:00	SPY	ETF	505.63	505.63	503.295	503.49	9595864.0
2024-04-16 16:00:00	SPY	ETF	503.49	503.64	503.11	503.43	2777818.0
2024-04-16 16:30:00	SPY	ETF	503.51	503.81	503.43	503.721	299541.0
2024-04-16 17:00:00	SPY	ETF	503.78	503.95	503.769	503.94	17817.0
2024-04-16 17:30:00	SPY	ETF	503.9	503.98	503.86	503.97	53503.0
2024-04-16 18:00:00	SPY	ETF	503.97	504.37	503.86	503.91	139160.0
2024-04-16 18:30:00	SPY	ETF	503.99	504.25	503.95	504.15	25078.0
2024-04-16 19:00:00	SPY	ETF	504.1	504.45	503.97	504.45	11440.0
2024-04-16 19:30:00	SPY	ETF	504.42	505.0	504.42	504.91	65755.0
2024-04-16 04:00:00	QQQ	ETF	431.0	431.22	430.62	431.03	52603.0
2024-04-16 04:30:00	QQQ	ETF	431.0	431.13	430.68	431.02	24679.0
2024-04-16 05:00:00	QQQ	ETF	430.8	431.09	430.31	430.89	21431.0
2024-04-16 05:30:00	QQQ	ETF	430.78	430.78	429.83	430.16	34806.0
2024-04-16 06:00:00	QQQ	ETF	430.33	430.33	429.08	429.52	56960.0
2024-04-16 06:30:00	QQQ	ETF	429.48	430.69	429.42	430.6	48986.0
2024-04-16 07:00:00	QQQ	ETF	430.67	431.44	430.5	431.08	145640.0
2024-04-16 07:30:00	QQQ	ETF	431.1	432.06	431.01	431.91	138643.0
2024-04-16 08:00:00	QQQ	ETF	430.9	432.01	429.3404	431.09	258712.0
2024-04-16 08:30:00	QQQ	ETF	431.16	432.05	430.89	431.56	171147.0
2024-04-16 09:00:00	QQQ	ETF	431.46	431.65	430.86	430.89	210863.0
2024-04-16 09:30:00	QQQ	ETF	430.89	431.9285	429.78	431.6	4627214.0
2024-04-16 10:00:00	QQQ	ETF	431.6	432.41	430.64	430.64	2715871.0
2024-04-16 10:30:00	QQQ	ETF	430.63	431.25	430.07	430.74	2894298.0
2024-04-16 11:00:00	QQQ	ETF	430.77	432.11	430.49	431.93	2243929.0
2024-04-16 11:30:00	QQQ	ETF	431.93	432.53	431.26	431.42	1665454.0
2024-04-16 12:00:00	QQQ	ETF	431.42	432.2	430.74	431.655	1455688.0
2024-04-16 12:30:00	QQQ	ETF	431.62	432.38	431.455	431.95	1192843.0

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

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