PREVIEW / etf_30min / 2024-05-10

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-05-10.parquet
  size:    770 KB
  rows:    30,768

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-10 04:00:00	SPY	ETF	521.0	521.42	520.86	521.4	7166.0
2024-05-10 04:30:00	SPY	ETF	521.41	521.91	521.41	521.91	2377.0
2024-05-10 05:00:00	SPY	ETF	521.9	522.28	521.9	522.16	18947.0
2024-05-10 05:30:00	SPY	ETF	522.12	522.32	522.12	522.22	4976.0
2024-05-10 06:00:00	SPY	ETF	522.11	522.11	521.94	521.97	38042.0
2024-05-10 06:30:00	SPY	ETF	522.05	522.11	521.8	521.92	57031.0
2024-05-10 07:00:00	SPY	ETF	521.91	522.0	520.94	521.8	126652.0
2024-05-10 07:30:00	SPY	ETF	521.78	521.84	521.62	521.73	68080.0
2024-05-10 08:00:00	SPY	ETF	521.88	522.32	520.78	522.03	160988.0
2024-05-10 08:30:00	SPY	ETF	522.04	522.04	521.31	521.34	165827.0
2024-05-10 09:00:00	SPY	ETF	521.3108	521.83	521.3	521.81	101372.0
2024-05-10 09:30:00	SPY	ETF	521.81	522.635	521.36	522.42	4688430.0
2024-05-10 10:00:00	SPY	ETF	522.41	522.43	520.6	520.78	4561225.0
2024-05-10 10:30:00	SPY	ETF	520.77	521.37	520.01	520.48	3493656.0
2024-05-10 11:00:00	SPY	ETF	520.5	520.63	520.1	520.54	2010460.0
2024-05-10 11:30:00	SPY	ETF	520.55	520.66	519.59	520.365	2539649.0
2024-05-10 12:00:00	SPY	ETF	520.37	520.5401	519.83	520.31	1862866.0
2024-05-10 12:30:00	SPY	ETF	520.31	520.77	520.09	520.53	1608363.0
2024-05-10 13:00:00	SPY	ETF	520.535	520.62	520.005	520.11	1476094.0
2024-05-10 13:30:00	SPY	ETF	520.13	520.84	519.91	520.8	1499533.0
2024-05-10 14:00:00	SPY	ETF	520.79	520.9499	520.41	520.67	1649769.0
2024-05-10 14:30:00	SPY	ETF	520.66	520.945	520.115	520.9322	1399571.0
2024-05-10 15:00:00	SPY	ETF	520.93	521.1399	520.62	521.03	1489989.0
2024-05-10 15:30:00	SPY	ETF	521.03	521.34	520.76	520.84	5765133.0
2024-05-10 16:00:00	SPY	ETF	520.84	520.95	520.59	520.59	3507808.0
2024-05-10 16:30:00	SPY	ETF	520.59	520.6	520.41	520.45	114813.0
2024-05-10 17:00:00	SPY	ETF	520.45	520.5	520.35	520.5	10901.0
2024-05-10 17:30:00	SPY	ETF	520.5	520.53	520.07	520.0822	56146.0
2024-05-10 18:00:00	SPY	ETF	520.1	520.1	520.0	520.0	39641.0
2024-05-10 18:30:00	SPY	ETF	520.01	520.13	519.98	520.07	20352.0
2024-05-10 19:00:00	SPY	ETF	520.1	520.13	519.98	519.98	7409.0
2024-05-10 19:30:00	SPY	ETF	520.02	520.02	519.75	519.92	27330.0
2024-05-10 04:00:00	QQQ	ETF	441.82	442.32	441.53	442.28	13159.0
2024-05-10 04:30:00	QQQ	ETF	442.25	442.77	442.25	442.76	3632.0
2024-05-10 05:00:00	QQQ	ETF	442.92	443.15	442.86	442.93	11330.0
2024-05-10 05:30:00	QQQ	ETF	443.14	443.24	443.14	443.16	7430.0
2024-05-10 06:00:00	QQQ	ETF	443.01	443.09	442.89	442.94	7568.0
2024-05-10 06:30:00	QQQ	ETF	442.93	443.13	442.84	442.84	20832.0
2024-05-10 07:00:00	QQQ	ETF	442.89	443.16	442.72	442.89	46562.0
2024-05-10 07:30:00	QQQ	ETF	442.85	442.96	442.66	442.82	18437.0
2024-05-10 08:00:00	QQQ	ETF	442.8	443.2	441.1	443.16	69890.0
2024-05-10 08:30:00	QQQ	ETF	443.06	443.1	441.9502	442.04	115835.0
2024-05-10 09:00:00	QQQ	ETF	442.01	442.61	441.92	442.52	106586.0
2024-05-10 09:30:00	QQQ	ETF	442.54	444.31	442.13	443.8	3168327.0
2024-05-10 10:00:00	QQQ	ETF	443.8	443.81	441.37	441.515	2886573.0
2024-05-10 10:30:00	QQQ	ETF	441.55	442.145	440.499	441.22	2379810.0
2024-05-10 11:00:00	QQQ	ETF	441.24	441.77	441.01	441.68	1611810.0
2024-05-10 11:30:00	QQQ	ETF	441.685	441.8199	440.61	441.63	1458429.0
2024-05-10 12:00:00	QQQ	ETF	441.63	441.79	440.96	441.61	978041.0
2024-05-10 12:30:00	QQQ	ETF	441.5907	442.03	441.27	441.835	803468.0

> showing 50 of 30,768 rows — these rows as CSV

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