PREVIEW / etf_30min / 2024-10-09

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-10-09.parquet
  size:    844 KB
  rows:    33,481

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-10-09 04:00:00	SPY	ETF	571.8	572.09	571.52	571.53	15604.0
2024-10-09 04:30:00	SPY	ETF	571.53	572.14	571.53	572.02	3818.0
2024-10-09 05:00:00	SPY	ETF	572.14	572.49	572.13	572.39	7526.0
2024-10-09 05:30:00	SPY	ETF	572.44	572.71	572.42	572.66	6537.0
2024-10-09 06:00:00	SPY	ETF	572.59	573.0	572.46	572.92	12510.0
2024-10-09 06:30:00	SPY	ETF	572.89	573.2	572.87	572.93	6426.0
2024-10-09 07:00:00	SPY	ETF	573.0	573.15	572.771	572.8	42884.0
2024-10-09 07:30:00	SPY	ETF	572.84	573.1	572.7	572.7	53728.0
2024-10-09 08:00:00	SPY	ETF	573.02	573.12	571.56	573.03	186846.0
2024-10-09 08:30:00	SPY	ETF	572.94	573.05	572.5	572.94	43236.0
2024-10-09 09:00:00	SPY	ETF	572.94	573.66	572.89	573.17	136257.0
2024-10-09 09:30:00	SPY	ETF	573.16	573.79	572.55	573.532	2512916.0
2024-10-09 10:00:00	SPY	ETF	573.53	574.44	573.449	574.11	1808479.0
2024-10-09 10:30:00	SPY	ETF	574.1	574.98	573.95	574.896	1336168.0
2024-10-09 11:00:00	SPY	ETF	574.9	575.94	574.9	575.71	2212691.0
2024-10-09 11:30:00	SPY	ETF	575.7201	577.06	575.7	576.89	2073988.0
2024-10-09 12:00:00	SPY	ETF	576.9	576.91	575.81	576.257	1520279.0
2024-10-09 12:30:00	SPY	ETF	576.26	576.505	575.56	575.9	916090.0
2024-10-09 13:00:00	SPY	ETF	575.89	576.6099	575.63	576.4801	1089097.0
2024-10-09 13:30:00	SPY	ETF	576.47	576.85	575.0	575.736	1235832.0
2024-10-09 14:00:00	SPY	ETF	575.77	576.55	575.46	576.4	1312380.0
2024-10-09 14:30:00	SPY	ETF	576.38	576.45	575.97	576.22	923963.0
2024-10-09 15:00:00	SPY	ETF	576.22	576.81	575.72	576.7133	1533705.0
2024-10-09 15:30:00	SPY	ETF	576.71	577.71	576.69	577.1	6650490.0
2024-10-09 16:00:00	SPY	ETF	577.09	577.18	576.26	576.37	2114986.0
2024-10-09 16:30:00	SPY	ETF	576.37	576.79	576.3	576.77	135249.0
2024-10-09 17:00:00	SPY	ETF	576.83	577.14	576.75	576.75	75078.0
2024-10-09 17:30:00	SPY	ETF	576.72	576.75	576.64	576.7	12254.0
2024-10-09 18:00:00	SPY	ETF	576.75	576.9	576.51	576.86	22379.0
2024-10-09 18:30:00	SPY	ETF	576.85	576.95	576.85	576.88	17394.0
2024-10-09 19:00:00	SPY	ETF	576.88	577.107	576.85	576.878	13488.0
2024-10-09 19:30:00	SPY	ETF	576.84	577.1281	576.84	577.0	20695.0
2024-10-09 04:00:00	QQQ	ETF	487.99	488.07	487.26	487.42	58263.0
2024-10-09 04:30:00	QQQ	ETF	487.37	488.14	487.27	488.0	19673.0
2024-10-09 05:00:00	QQQ	ETF	488.17	488.55	488.12	488.34	15305.0
2024-10-09 05:30:00	QQQ	ETF	488.33	488.63	488.33	488.55	9783.0
2024-10-09 06:00:00	QQQ	ETF	488.48	489.13	488.47	488.95	14272.0
2024-10-09 06:30:00	QQQ	ETF	488.99	489.18	488.83	488.9	19249.0
2024-10-09 07:00:00	QQQ	ETF	488.94	489.18	488.74	488.81	43313.0
2024-10-09 07:30:00	QQQ	ETF	488.84	488.95	488.35	488.35	30503.0
2024-10-09 08:00:00	QQQ	ETF	489.15	489.198	487.0	488.78	101799.0
2024-10-09 08:30:00	QQQ	ETF	488.72	488.8509	488.24	488.72	55415.0
2024-10-09 09:00:00	QQQ	ETF	488.72	489.39	488.72	489.01	87377.0
2024-10-09 09:30:00	QQQ	ETF	488.98	489.38	487.95	488.595	1958991.0
2024-10-09 10:00:00	QQQ	ETF	488.59	490.7	488.51	490.42	1832106.0
2024-10-09 10:30:00	QQQ	ETF	490.44	490.92	489.77	490.888	1036966.0
2024-10-09 11:00:00	QQQ	ETF	490.91	491.8	490.91	491.4694	1274949.0
2024-10-09 11:30:00	QQQ	ETF	491.46	492.9	491.43	492.8589	1464795.0
2024-10-09 12:00:00	QQQ	ETF	492.84	492.865	491.02	492.1	1206036.0
2024-10-09 12:30:00	QQQ	ETF	492.085	492.34	491.32	491.6599	1117025.0

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

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