PREVIEW / etf_30min / 2024-03-22

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-03-22.parquet
  size:    782 KB
  rows:    31,190

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-03-22 04:00:00	SPY	ETF	522.22	522.59	522.11	522.49	12679.0
2024-03-22 04:30:00	SPY	ETF	522.72	522.87	522.57	522.84	5151.0
2024-03-22 05:00:00	SPY	ETF	522.88	523.09	522.74	522.79	8249.0
2024-03-22 05:30:00	SPY	ETF	522.83	522.83	522.7	522.79	1712.0
2024-03-22 06:00:00	SPY	ETF	522.92	522.97	522.83	522.93	5716.0
2024-03-22 06:30:00	SPY	ETF	522.97	523.09	522.76	522.78	11029.0
2024-03-22 07:00:00	SPY	ETF	522.81	523.08	522.55	522.64	24802.0
2024-03-22 07:30:00	SPY	ETF	522.62	522.62	521.39	521.51	109212.0
2024-03-22 08:00:00	SPY	ETF	521.52	523.09	521.26	521.44	137792.0
2024-03-22 08:30:00	SPY	ETF	521.44	521.83	521.25	521.81	81122.0
2024-03-22 09:00:00	SPY	ETF	521.86	522.14	521.7	522.09	122135.0
2024-03-22 09:30:00	SPY	ETF	522.11	522.44	521.42	521.77	3490582.0
2024-03-22 10:00:00	SPY	ETF	521.78	522.305	521.41	521.8	2791026.0
2024-03-22 10:30:00	SPY	ETF	521.79	521.82	521.02	521.06	2714604.0
2024-03-22 11:00:00	SPY	ETF	521.06	521.7501	521.03	521.7	2132472.0
2024-03-22 11:30:00	SPY	ETF	521.705	521.835	521.4	521.68	1884998.0
2024-03-22 12:00:00	SPY	ETF	521.68	521.7779	521.1905	521.45	1874675.0
2024-03-22 12:30:00	SPY	ETF	521.455	521.88	520.97	521.84	2381821.0
2024-03-22 13:00:00	SPY	ETF	521.83	522.21	521.76	522.0427	2215025.0
2024-03-22 13:30:00	SPY	ETF	522.045	522.59	521.9	522.545	2053373.0
2024-03-22 14:00:00	SPY	ETF	522.54	522.605	521.955	522.5099	1849032.0
2024-03-22 14:30:00	SPY	ETF	522.51	522.53	521.95	522.17	2006200.0
2024-03-22 15:00:00	SPY	ETF	522.17	522.1901	521.12	521.69	3817589.0
2024-03-22 15:30:00	SPY	ETF	521.7	522.36	521.23	521.27	11617069.0
2024-03-22 16:00:00	SPY	ETF	521.27	522.1424	520.82	520.84	7864741.0
2024-03-22 16:30:00	SPY	ETF	520.85	521.4073	520.84	520.95	2930818.0
2024-03-22 17:00:00	SPY	ETF	520.97	521.05	520.9	520.98	114115.0
2024-03-22 17:30:00	SPY	ETF	520.9008	521.0	520.87	520.9	47347.0
2024-03-22 18:00:00	SPY	ETF	520.91	520.91	520.78	520.79	9785.0
2024-03-22 18:30:00	SPY	ETF	520.79	520.8	520.77	520.8	9741.0
2024-03-22 19:00:00	SPY	ETF	520.82	520.83	520.8	520.83	3382.0
2024-03-22 19:30:00	SPY	ETF	520.85	520.94	520.75	520.75	14237.0
2024-03-22 04:00:00	QQQ	ETF	446.11	446.4	445.91	446.34	26909.0
2024-03-22 04:30:00	QQQ	ETF	446.33	446.74	446.33	446.74	31814.0
2024-03-22 05:00:00	QQQ	ETF	446.73	446.99	446.37	446.4	16784.0
2024-03-22 05:30:00	QQQ	ETF	446.41	446.7	446.3	446.7	8484.0
2024-03-22 06:00:00	QQQ	ETF	446.6	446.67	446.31	446.51	20397.0
2024-03-22 06:30:00	QQQ	ETF	446.46	446.68	446.17	446.23	13939.0
2024-03-22 07:00:00	QQQ	ETF	446.27	446.42	445.86	445.95	33360.0
2024-03-22 07:30:00	QQQ	ETF	445.96	445.99	444.6	444.74	137794.0
2024-03-22 08:00:00	QQQ	ETF	446.35	446.8904	444.34	444.6	139056.0
2024-03-22 08:30:00	QQQ	ETF	444.58	445.22	444.3	445.2	105244.0
2024-03-22 09:00:00	QQQ	ETF	445.199	445.52	444.96	445.34	100809.0
2024-03-22 09:30:00	QQQ	ETF	445.35	445.58	444.49	445.2	2392529.0
2024-03-22 10:00:00	QQQ	ETF	445.2	446.04	444.73	445.265	1820632.0
2024-03-22 10:30:00	QQQ	ETF	445.29	445.38	444.56	444.78	1004256.0
2024-03-22 11:00:00	QQQ	ETF	444.75	445.86	444.72	445.76	1129017.0
2024-03-22 11:30:00	QQQ	ETF	445.77	445.9629	445.36	445.89	1158336.0
2024-03-22 12:00:00	QQQ	ETF	445.91	446.11	445.27	445.7694	900031.0
2024-03-22 12:30:00	QQQ	ETF	445.8	446.44	445.17	446.41	1346840.0

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

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