PREVIEW / etf_30min / 2023-10-04

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-10-04.parquet
  size:    726 KB
  rows:    29,237

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
2023-10-04 04:00:00	SPY	ETF	420.33	421.0	420.07	420.98	20639.0
2023-10-04 04:30:00	SPY	ETF	421.04	421.31	420.84	421.04	23486.0
2023-10-04 05:00:00	SPY	ETF	420.93	421.26	420.87	421.21	8623.0
2023-10-04 05:30:00	SPY	ETF	421.4	421.75	421.38	421.68	54192.0
2023-10-04 06:00:00	SPY	ETF	421.68	421.95	421.63	421.91	83773.0
2023-10-04 06:30:00	SPY	ETF	421.68	421.68	421.05	421.45	21518.0
2023-10-04 07:00:00	SPY	ETF	421.42	422.45	421.24	422.01	311838.0
2023-10-04 07:30:00	SPY	ETF	422.0	422.57	421.89	422.37	213367.0
2023-10-04 08:00:00	SPY	ETF	422.2385	423.24	418.81	422.54	585407.0
2023-10-04 08:30:00	SPY	ETF	422.54	423.28	422.34	422.63	545210.0
2023-10-04 09:00:00	SPY	ETF	422.62	422.76	421.94	422.01	382198.0
2023-10-04 09:30:00	SPY	ETF	422.07	423.37	421.91	422.5201	6129861.0
2023-10-04 10:00:00	SPY	ETF	422.52	422.91	420.56	420.6196	6916784.0
2023-10-04 10:30:00	SPY	ETF	420.615	422.599	420.58	421.05	5655351.0
2023-10-04 11:00:00	SPY	ETF	421.05	423.05	420.68	422.77	5049910.0
2023-10-04 11:30:00	SPY	ETF	422.77	423.965	422.16	423.955	4638857.0
2023-10-04 12:00:00	SPY	ETF	423.93	424.16	423.25	423.99	3843579.0
2023-10-04 12:30:00	SPY	ETF	423.985	424.36	423.42	423.6017	3664844.0
2023-10-04 13:00:00	SPY	ETF	423.645	423.72	422.565	422.6197	3004030.0
2023-10-04 13:30:00	SPY	ETF	422.62	422.87	422.04	422.2	3852557.0
2023-10-04 14:00:00	SPY	ETF	422.17	422.74	421.64	422.47	4278153.0
2023-10-04 14:30:00	SPY	ETF	422.46	423.33	422.1	423.19	3345549.0
2023-10-04 15:00:00	SPY	ETF	423.2	424.74	423.04	424.42	5309829.0
2023-10-04 15:30:00	SPY	ETF	424.42	425.4299	424.19	424.71	12565199.0
2023-10-04 16:00:00	SPY	ETF	424.7	424.7562	423.2127	424.4	3064045.0
2023-10-04 16:30:00	SPY	ETF	424.42	424.42	424.15	424.18	137957.0
2023-10-04 17:00:00	SPY	ETF	424.23	424.23	424.01	424.15	54103.0
2023-10-04 17:30:00	SPY	ETF	424.16	424.17	424.04	424.15	34890.0
2023-10-04 18:00:00	SPY	ETF	424.15	424.19	423.97	424.06	79661.0
2023-10-04 18:30:00	SPY	ETF	424.12	424.28	424.1	424.16	18830.0
2023-10-04 19:00:00	SPY	ETF	424.2	424.25	424.06	424.22	3572.0
2023-10-04 19:30:00	SPY	ETF	424.17	424.19	424.05	424.19	31742.0
2023-10-04 04:00:00	QQQ	ETF	353.2	353.95	352.89	353.77	45140.0
2023-10-04 04:30:00	QQQ	ETF	353.82	354.1	353.71	353.85	15171.0
2023-10-04 05:00:00	QQQ	ETF	353.85	354.25	353.74	354.14	21339.0
2023-10-04 05:30:00	QQQ	ETF	354.22	354.58	354.22	354.48	27765.0
2023-10-04 06:00:00	QQQ	ETF	354.53	354.92	354.42	354.74	22462.0
2023-10-04 06:30:00	QQQ	ETF	354.7	354.7	353.95	354.43	50429.0
2023-10-04 07:00:00	QQQ	ETF	354.48	355.67	354.33	355.18	261914.0
2023-10-04 07:30:00	QQQ	ETF	355.19	355.8	355.07	355.48	127107.0
2023-10-04 08:00:00	QQQ	ETF	355.22	356.68	351.96	356.14	657960.0
2023-10-04 08:30:00	QQQ	ETF	356.18	356.91	355.89	356.39	316045.0
2023-10-04 09:00:00	QQQ	ETF	356.36	356.48	354.654	355.8	425642.0
2023-10-04 09:30:00	QQQ	ETF	355.76	357.73	355.69	356.9501	5152149.0
2023-10-04 10:00:00	QQQ	ETF	356.93	357.32	355.3	355.42	4590480.0
2023-10-04 10:30:00	QQQ	ETF	355.42	358.08	355.42	356.31	3644180.0
2023-10-04 11:00:00	QQQ	ETF	356.29	358.25	355.94	357.83	2611478.0
2023-10-04 11:30:00	QQQ	ETF	357.82	359.23	357.5901	359.195	2851835.0
2023-10-04 12:00:00	QQQ	ETF	359.17	359.26	358.261	358.83	2070250.0
2023-10-04 12:30:00	QQQ	ETF	358.84	359.12	358.4	358.69	1596349.0

> showing 50 of 29,237 rows — these rows as CSV

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