PREVIEW / etf_30min / 2024-08-12

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-08-12.parquet
  size:    809 KB
  rows:    32,972

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-08-12 04:00:00	SPY	ETF	533.5	534.45	533.5	534.17	20930.0
2024-08-12 04:30:00	SPY	ETF	534.0	534.0	533.49	533.49	12136.0
2024-08-12 05:00:00	SPY	ETF	533.41	533.64	533.35	533.61	6089.0
2024-08-12 05:30:00	SPY	ETF	533.64	533.9	533.52	533.57	3835.0
2024-08-12 06:00:00	SPY	ETF	533.66	534.22	533.36	534.14	15671.0
2024-08-12 06:30:00	SPY	ETF	534.03	534.22	534.0	534.05	13610.0
2024-08-12 07:00:00	SPY	ETF	534.14	534.74	533.54	534.57	190494.0
2024-08-12 07:30:00	SPY	ETF	534.51	534.62	533.9	534.5	47220.0
2024-08-12 08:00:00	SPY	ETF	533.95	534.98	532.94	534.97	214068.0
2024-08-12 08:30:00	SPY	ETF	534.9602	535.0	534.16	534.34	78635.0
2024-08-12 09:00:00	SPY	ETF	534.31	534.51	534.01	534.23	131942.0
2024-08-12 09:30:00	SPY	ETF	534.22	534.48	530.95	531.41	4229620.0
2024-08-12 10:00:00	SPY	ETF	531.44	534.73	531.23	534.19	2473218.0
2024-08-12 10:30:00	SPY	ETF	534.18	535.31	534.05	535.21	2125455.0
2024-08-12 11:00:00	SPY	ETF	535.22	535.73	531.86	532.89	2595267.0
2024-08-12 11:30:00	SPY	ETF	532.86	534.97	532.13	534.83	2068507.0
2024-08-12 12:00:00	SPY	ETF	534.8325	535.15	533.76	534.08	1570632.0
2024-08-12 12:30:00	SPY	ETF	534.07	534.56	532.74	532.76	1255783.0
2024-08-12 13:00:00	SPY	ETF	532.78	534.23	532.1	533.4399	1296389.0
2024-08-12 13:30:00	SPY	ETF	533.44	533.8708	531.76	532.43	1169019.0
2024-08-12 14:00:00	SPY	ETF	532.42	533.16	532.18	532.64	1340683.0
2024-08-12 14:30:00	SPY	ETF	532.62	533.2599	532.39	533.2099	1291538.0
2024-08-12 15:00:00	SPY	ETF	533.21	533.23	532.36	532.63	1832454.0
2024-08-12 15:30:00	SPY	ETF	532.65	533.3	531.765	533.25	5687718.0
2024-08-12 16:00:00	SPY	ETF	533.25	533.51	532.72	532.94	2261084.0
2024-08-12 16:30:00	SPY	ETF	532.94	533.0	532.87	533.0	125082.0
2024-08-12 17:00:00	SPY	ETF	533.008	533.1	532.91	533.0001	15753.0
2024-08-12 17:30:00	SPY	ETF	533.02	533.25	533.0	533.11	9385.0
2024-08-12 18:00:00	SPY	ETF	533.25	533.44	533.12	533.37	26749.0
2024-08-12 18:30:00	SPY	ETF	533.16	533.25	533.059	533.18	13099.0
2024-08-12 19:00:00	SPY	ETF	533.23	533.44	533.11	533.44	16666.0
2024-08-12 19:30:00	SPY	ETF	533.49	533.67	533.0	533.28	114768.0
2024-08-12 04:00:00	QQQ	ETF	452.23	452.44	452.0	452.21	18882.0
2024-08-12 04:30:00	QQQ	ETF	452.1	452.13	451.17	451.22	5469.0
2024-08-12 05:00:00	QQQ	ETF	451.26	451.63	451.21	451.38	2403.0
2024-08-12 05:30:00	QQQ	ETF	451.41	451.82	451.41	451.68	2796.0
2024-08-12 06:00:00	QQQ	ETF	451.6	452.04	451.18	452.04	6452.0
2024-08-12 06:30:00	QQQ	ETF	452.0	452.03	451.76	451.76	3691.0
2024-08-12 07:00:00	QQQ	ETF	451.84	452.33	451.5	452.129	53669.0
2024-08-12 07:30:00	QQQ	ETF	452.099	452.099	451.31	451.9	54652.0
2024-08-12 08:00:00	QQQ	ETF	451.8614	452.55	449.46	452.55	106845.0
2024-08-12 08:30:00	QQQ	ETF	452.48	452.54	451.61	451.86	61231.0
2024-08-12 09:00:00	QQQ	ETF	451.87	452.11	451.26	451.36	119831.0
2024-08-12 09:30:00	QQQ	ETF	451.39	452.14	448.5546	448.96	3286808.0
2024-08-12 10:00:00	QQQ	ETF	448.97	453.46	448.74	452.71	2311916.0
2024-08-12 10:30:00	QQQ	ETF	452.72	453.81	452.57	453.45	1546478.0
2024-08-12 11:00:00	QQQ	ETF	453.45	454.37	449.85	451.13	2331619.0
2024-08-12 11:30:00	QQQ	ETF	451.11	453.47	450.19	453.285	1721848.0
2024-08-12 12:00:00	QQQ	ETF	453.28	453.56	452.2	452.675	1039774.0
2024-08-12 12:30:00	QQQ	ETF	452.6	453.16	450.88	450.905	925309.0

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

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