PREVIEW / etf_30min / 2024-06-20

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-06-20.parquet
  size:    852 KB
  rows:    33,880

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-20 04:00:00	SPY	ETF	550.12	550.54	549.52	550.44	11583.0
2024-06-20 04:30:00	SPY	ETF	550.33	550.53	550.2	550.51	4005.0
2024-06-20 05:00:00	SPY	ETF	550.51	550.57	550.34	550.54	3358.0
2024-06-20 05:30:00	SPY	ETF	550.51	550.59	550.32	550.59	5373.0
2024-06-20 06:00:00	SPY	ETF	550.41	550.71	550.41	550.69	1232.0
2024-06-20 06:30:00	SPY	ETF	550.62	550.73	550.58	550.6	2820.0
2024-06-20 07:00:00	SPY	ETF	550.43	550.77	550.4	550.55	61500.0
2024-06-20 07:30:00	SPY	ETF	550.54	550.58	550.16	550.261	16196.0
2024-06-20 08:00:00	SPY	ETF	550.69	551.12	549.59	550.3	93038.0
2024-06-20 08:30:00	SPY	ETF	550.39	550.5	549.48	549.6	109168.0
2024-06-20 09:00:00	SPY	ETF	549.56	549.66	549.34	549.44	132333.0
2024-06-20 09:30:00	SPY	ETF	549.44	550.12	548.81	549.61	2620833.0
2024-06-20 10:00:00	SPY	ETF	549.6	549.82	548.4	549.075	2318021.0
2024-06-20 10:30:00	SPY	ETF	549.06	549.39	548.67	549.23	1422852.0
2024-06-20 11:00:00	SPY	ETF	549.23	549.53	548.69	548.81	1435566.0
2024-06-20 11:30:00	SPY	ETF	548.81	549.12	548.32	548.36	1293310.0
2024-06-20 12:00:00	SPY	ETF	548.34	548.66	546.9401	546.96	2291167.0
2024-06-20 12:30:00	SPY	ETF	546.96	547.705	545.99	547.28	2605513.0
2024-06-20 13:00:00	SPY	ETF	547.27	547.27	545.74	546.02	1695516.0
2024-06-20 13:30:00	SPY	ETF	546.0	547.05	545.18	547.02	2719913.0
2024-06-20 14:00:00	SPY	ETF	547.03	548.1401	546.95	548.055	2900404.0
2024-06-20 14:30:00	SPY	ETF	548.06	548.19	547.15	547.18	2747824.0
2024-06-20 15:00:00	SPY	ETF	547.18	547.3	545.77	547.15	2685831.0
2024-06-20 15:30:00	SPY	ETF	547.16	547.76	546.58	546.95	8277872.0
2024-06-20 16:00:00	SPY	ETF	546.95	547.08	546.44	546.81	2922655.0
2024-06-20 16:30:00	SPY	ETF	546.83	546.97	546.83	546.92	217606.0
2024-06-20 17:00:00	SPY	ETF	546.93	546.93	546.75	546.91	38282.0
2024-06-20 17:30:00	SPY	ETF	546.91	546.91	546.79	546.85	36989.0
2024-06-20 18:00:00	SPY	ETF	546.86	547.13	546.85	547.06	16709.0
2024-06-20 18:30:00	SPY	ETF	547.05	547.08	546.93	547.0	9535.0
2024-06-20 19:00:00	SPY	ETF	547.04	547.24	547.0	547.22	16634.0
2024-06-20 19:30:00	SPY	ETF	547.19	547.2	546.97	547.18	26938.0
2024-06-20 20:00:00	SPY	ETF	547.17	547.17	547.17	547.17	1000.0
2024-06-20 04:00:00	QQQ	ETF	487.71	488.66	487.71	488.15	56856.0
2024-06-20 04:30:00	QQQ	ETF	488.02	488.35	487.93	488.35	20538.0
2024-06-20 05:00:00	QQQ	ETF	488.34	488.38	487.92	488.21	15805.0
2024-06-20 05:30:00	QQQ	ETF	488.22	488.29	487.88	488.23	17516.0
2024-06-20 06:00:00	QQQ	ETF	488.16	488.43	487.92	488.35	24581.0
2024-06-20 06:30:00	QQQ	ETF	488.21	488.49	488.21	488.22	41289.0
2024-06-20 07:00:00	QQQ	ETF	488.09	488.34	487.94	488.13	47180.0
2024-06-20 07:30:00	QQQ	ETF	488.1	488.12	487.5	487.61	47210.0
2024-06-20 08:00:00	QQQ	ETF	487.61	489.07	485.573	487.74	113632.0
2024-06-20 08:30:00	QQQ	ETF	487.8	487.8	486.72	486.94	107412.0
2024-06-20 09:00:00	QQQ	ETF	486.93	486.99	486.37	486.41	119486.0
2024-06-20 09:30:00	QQQ	ETF	486.42	486.8387	485.27	486.15	2528741.0
2024-06-20 10:00:00	QQQ	ETF	486.1709	486.31	483.37	484.59	2399394.0
2024-06-20 10:30:00	QQQ	ETF	484.55	485.735	484.39	485.73	1185317.0
2024-06-20 11:00:00	QQQ	ETF	485.74	486.035	484.95	485.1014	864675.0
2024-06-20 11:30:00	QQQ	ETF	485.12	485.6254	484.31	484.485	863227.0
2024-06-20 12:00:00	QQQ	ETF	484.47	484.815	482.0704	482.11	1421370.0

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

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