PREVIEW / etf_30min / 2024-05-13

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-05-13.parquet
  size:    780 KB
  rows:    31,032

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-05-13 04:00:00	SPY	ETF	521.2	521.66	521.2	521.43	14674.0
2024-05-13 04:30:00	SPY	ETF	521.53	521.53	521.36	521.36	1237.0
2024-05-13 05:00:00	SPY	ETF	521.36	521.63	521.36	521.54	4446.0
2024-05-13 05:30:00	SPY	ETF	521.57	521.74	521.56	521.56	7086.0
2024-05-13 06:00:00	SPY	ETF	521.58	521.66	521.56	521.62	8255.0
2024-05-13 06:30:00	SPY	ETF	521.63	521.85	521.63	521.76	12946.0
2024-05-13 07:00:00	SPY	ETF	521.81	522.04	521.4	522.0	129273.0
2024-05-13 07:30:00	SPY	ETF	522.0	522.32	521.94	522.31	67983.0
2024-05-13 08:00:00	SPY	ETF	521.72	522.35	521.24	521.97	137428.0
2024-05-13 08:30:00	SPY	ETF	521.97	522.4101	521.94	522.33	121093.0
2024-05-13 09:00:00	SPY	ETF	522.3	522.73	522.07	522.56	236909.0
2024-05-13 09:30:00	SPY	ETF	522.55	522.67	521.1	521.695	4301176.0
2024-05-13 10:00:00	SPY	ETF	521.68	521.845	521.38	521.67	1974332.0
2024-05-13 10:30:00	SPY	ETF	521.665	521.67	521.12	521.26	1950928.0
2024-05-13 11:00:00	SPY	ETF	521.27	521.46	520.8	520.92	1615551.0
2024-05-13 11:30:00	SPY	ETF	520.92	521.14	520.4	521.0404	1699459.0
2024-05-13 12:00:00	SPY	ETF	521.045	521.375	521.01	521.285	971942.0
2024-05-13 12:30:00	SPY	ETF	521.29	521.35	520.995	521.005	1042562.0
2024-05-13 13:00:00	SPY	ETF	521.0	521.0	519.74	520.8665	2287141.0
2024-05-13 13:30:00	SPY	ETF	520.865	520.9	520.385	520.6888	1150199.0
2024-05-13 14:00:00	SPY	ETF	520.68	520.84	520.315	520.795	1362361.0
2024-05-13 14:30:00	SPY	ETF	520.795	520.99	520.64	520.92	1396659.0
2024-05-13 15:00:00	SPY	ETF	520.905	521.1396	520.47	520.79	1470137.0
2024-05-13 15:30:00	SPY	ETF	520.785	521.1	520.645	520.91	4842468.0
2024-05-13 16:00:00	SPY	ETF	520.9	521.1	520.52	520.67	2256177.0
2024-05-13 16:30:00	SPY	ETF	520.68	520.68	520.56	520.64	86585.0
2024-05-13 17:00:00	SPY	ETF	520.7	520.75	520.61	520.75	12107.0
2024-05-13 17:30:00	SPY	ETF	520.71	520.75	520.62	520.62	4587.0
2024-05-13 18:00:00	SPY	ETF	520.62	520.8299	520.6	520.67	16279.0
2024-05-13 18:30:00	SPY	ETF	520.65	520.77	520.65	520.77	3700.0
2024-05-13 19:00:00	SPY	ETF	520.73	520.8	520.7	520.8	10789.0
2024-05-13 19:30:00	SPY	ETF	520.8	520.88	520.77	520.79	14177.0
2024-05-13 04:00:00	QQQ	ETF	442.72	443.12	442.59	442.96	18292.0
2024-05-13 04:30:00	QQQ	ETF	442.92	442.92	442.65	442.75	9735.0
2024-05-13 05:00:00	QQQ	ETF	442.69	443.1	442.69	443.07	6216.0
2024-05-13 05:30:00	QQQ	ETF	443.25	443.28	442.94	442.94	10934.0
2024-05-13 06:00:00	QQQ	ETF	442.93	443.09	442.92	443.09	5268.0
2024-05-13 06:30:00	QQQ	ETF	443.1	443.26	443.1	443.26	17446.0
2024-05-13 07:00:00	QQQ	ETF	443.32	443.57	443.17	443.57	20606.0
2024-05-13 07:30:00	QQQ	ETF	443.5	443.701	443.38	443.66	18048.0
2024-05-13 08:00:00	QQQ	ETF	443.18	443.75	442.391	443.2898	54661.0
2024-05-13 08:30:00	QQQ	ETF	443.3	443.91	443.29	443.87	77861.0
2024-05-13 09:00:00	QQQ	ETF	443.85	444.1	443.32	443.99	82158.0
2024-05-13 09:30:00	QQQ	ETF	443.99	444.09	442.08	442.9	2719216.0
2024-05-13 10:00:00	QQQ	ETF	442.91	443.5	442.78	443.34	1200530.0
2024-05-13 10:30:00	QQQ	ETF	443.31	443.31	442.69	443.06	1352764.0
2024-05-13 11:00:00	QQQ	ETF	443.06	443.41	442.6	442.73	1265007.0
2024-05-13 11:30:00	QQQ	ETF	442.7	443.13	442.24	443.07	1160394.0
2024-05-13 12:00:00	QQQ	ETF	443.06	443.3601	443.04	443.265	498568.0
2024-05-13 12:30:00	QQQ	ETF	443.27	443.44	443.07	443.07	501138.0

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

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