PREVIEW / etf_30min / 2024-06-14

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-06-14.parquet
  size:    796 KB
  rows:    31,926

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-14 04:00:00	SPY	ETF	542.53	542.53	541.78	541.81	5756.0
2024-06-14 04:30:00	SPY	ETF	542.13	542.2	541.67	541.67	2892.0
2024-06-14 05:00:00	SPY	ETF	541.68	541.79	541.35	541.35	3083.0
2024-06-14 05:30:00	SPY	ETF	541.1	541.1	540.38	540.38	32796.0
2024-06-14 06:00:00	SPY	ETF	540.38	540.43	539.33	539.62	69496.0
2024-06-14 06:30:00	SPY	ETF	539.63	540.24	539.63	539.69	27748.0
2024-06-14 07:00:00	SPY	ETF	539.71	540.31	538.87	540.31	240122.0
2024-06-14 07:30:00	SPY	ETF	540.32	540.76	540.0	540.1	126024.0
2024-06-14 08:00:00	SPY	ETF	539.47	543.16	539.03	540.6	188444.0
2024-06-14 08:30:00	SPY	ETF	540.55	540.82	540.34	540.49	111347.0
2024-06-14 09:00:00	SPY	ETF	540.42	540.87	540.28	540.87	211234.0
2024-06-14 09:30:00	SPY	ETF	540.88	541.6295	540.665	541.53	2868698.0
2024-06-14 10:00:00	SPY	ETF	541.51	541.51	539.96	540.87	2933477.0
2024-06-14 10:30:00	SPY	ETF	540.88	541.28	539.85	541.23	1742400.0
2024-06-14 11:00:00	SPY	ETF	541.22	541.65	540.705	541.43	1242012.0
2024-06-14 11:30:00	SPY	ETF	541.46	541.79	540.28	541.405	1944261.0
2024-06-14 12:00:00	SPY	ETF	541.42	541.8594	541.065	541.12	1307232.0
2024-06-14 12:30:00	SPY	ETF	541.11	541.91	540.9301	541.805	1168328.0
2024-06-14 13:00:00	SPY	ETF	541.81	542.4201	541.7	542.1	1250799.0
2024-06-14 13:30:00	SPY	ETF	542.08	542.36	541.54	541.77	980951.0
2024-06-14 14:00:00	SPY	ETF	541.765	542.19	541.172	541.87	1344683.0
2024-06-14 14:30:00	SPY	ETF	541.88	542.33	541.33	542.075	1271961.0
2024-06-14 15:00:00	SPY	ETF	542.07	542.43	541.87	542.36	1725091.0
2024-06-14 15:30:00	SPY	ETF	542.37	542.81	541.86	542.73	4413777.0
2024-06-14 16:00:00	SPY	ETF	542.72	542.78	542.36	542.5	3395273.0
2024-06-14 16:30:00	SPY	ETF	542.5	542.6379	542.4	542.46	777829.0
2024-06-14 17:00:00	SPY	ETF	542.48	543.07	542.35	542.95	123886.0
2024-06-14 17:30:00	SPY	ETF	542.87	543.1	542.86	543.07	20719.0
2024-06-14 18:00:00	SPY	ETF	543.07	543.08	542.81	542.83	18810.0
2024-06-14 18:30:00	SPY	ETF	542.82	542.9255	542.72	542.76	16379.0
2024-06-14 19:00:00	SPY	ETF	542.72	542.72	542.56	542.59	2112.0
2024-06-14 19:30:00	SPY	ETF	542.67	542.82	542.56	542.82	13183.0
2024-06-14 20:00:00	SPY	ETF	542.85	542.85	542.85	542.85	200.0
2024-06-14 04:00:00	QQQ	ETF	477.36	478.39	477.36	477.83	38216.0
2024-06-14 04:30:00	QQQ	ETF	477.87	478.03	477.45	477.51	8764.0
2024-06-14 05:00:00	QQQ	ETF	477.52	477.55	477.02	477.19	23290.0
2024-06-14 05:30:00	QQQ	ETF	477.1	477.1	476.08	476.11	73790.0
2024-06-14 06:00:00	QQQ	ETF	476.0	476.05	475.18	475.62	147159.0
2024-06-14 06:30:00	QQQ	ETF	475.62	476.14	475.49	475.79	117666.0
2024-06-14 07:00:00	QQQ	ETF	475.57	475.82	474.7	475.82	103842.0
2024-06-14 07:30:00	QQQ	ETF	475.77	476.25	475.45	475.54	77708.0
2024-06-14 08:00:00	QQQ	ETF	475.5	478.34	474.75	476.23	140140.0
2024-06-14 08:30:00	QQQ	ETF	476.19	476.47	475.97	476.11	65682.0
2024-06-14 09:00:00	QQQ	ETF	476.02	476.53	475.95	476.53	85192.0
2024-06-14 09:30:00	QQQ	ETF	476.52	478.14	476.05	478.04	2270784.0
2024-06-14 10:00:00	QQQ	ETF	478.02	478.27	476.754	477.69	1673734.0
2024-06-14 10:30:00	QQQ	ETF	477.72	477.9	476.46	477.8	1388577.0
2024-06-14 11:00:00	QQQ	ETF	477.8	477.88	477.07	477.52	887996.0
2024-06-14 11:30:00	QQQ	ETF	477.54	477.85	476.2	477.53	1419082.0
2024-06-14 12:00:00	QQQ	ETF	477.51	478.12	477.24	477.3	788402.0

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

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