PREVIEW / etf_30min / 2023-03-16

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-03-16.parquet
  size:    696 KB
  rows:    28,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
2023-03-16 04:00:00	SPY	ETF	390.54	390.96	389.48	389.77	50034.0
2023-03-16 04:30:00	SPY	ETF	390.12	390.34	389.34	389.34	32503.0
2023-03-16 05:00:00	SPY	ETF	389.32	389.5	388.11	388.66	48841.0
2023-03-16 05:30:00	SPY	ETF	388.8	389.04	388.0	388.74	25619.0
2023-03-16 06:00:00	SPY	ETF	388.74	389.06	388.39	389.03	65856.0
2023-03-16 06:30:00	SPY	ETF	389.01	389.06	388.2	389.0	72513.0
2023-03-16 07:00:00	SPY	ETF	389.02	389.03	387.53	387.9	204729.0
2023-03-16 07:30:00	SPY	ETF	387.9	389.07	387.77	388.48	221474.0
2023-03-16 08:00:00	SPY	ETF	387.96	390.85	387.54	389.37	395914.0
2023-03-16 08:30:00	SPY	ETF	388.8	389.34	387.51	387.96	624627.0
2023-03-16 09:00:00	SPY	ETF	387.93	388.13	386.46	386.83	1008079.0
2023-03-16 09:30:00	SPY	ETF	386.82	388.65	386.29	388.59	8831261.0
2023-03-16 10:00:00	SPY	ETF	388.59	388.9601	386.59	387.85	6448222.0
2023-03-16 10:30:00	SPY	ETF	387.84	392.06	387.6	391.58	10634617.0
2023-03-16 11:00:00	SPY	ETF	391.59	393.5	390.804	393.025	9996083.0
2023-03-16 11:30:00	SPY	ETF	393.02	394.45	392.52	393.86	8354818.0
2023-03-16 12:00:00	SPY	ETF	393.86	394.08	392.4	393.77	5816570.0
2023-03-16 12:30:00	SPY	ETF	393.765	395.49	392.99	395.255	7315997.0
2023-03-16 13:00:00	SPY	ETF	395.26	396.14	394.56	395.115	6925068.0
2023-03-16 13:30:00	SPY	ETF	395.11	395.32	394.33	395.025	4180764.0
2023-03-16 14:00:00	SPY	ETF	395.02	395.07	394.0	394.7	4266467.0
2023-03-16 14:30:00	SPY	ETF	394.7	395.2499	393.62	395.21	4626311.0
2023-03-16 15:00:00	SPY	ETF	395.21	396.13	395.0501	395.98	5460504.0
2023-03-16 15:30:00	SPY	ETF	395.98	396.47	395.32	396.03	17450289.0
2023-03-16 16:00:00	SPY	ETF	396.03	396.52	395.0	396.46	5357217.0
2023-03-16 16:30:00	SPY	ETF	396.4	396.43	395.9503	396.13	624967.0
2023-03-16 17:00:00	SPY	ETF	396.15	396.16	395.9	396.0	94491.0
2023-03-16 17:30:00	SPY	ETF	396.0	396.04	395.85	395.919	70186.0
2023-03-16 18:00:00	SPY	ETF	395.95	396.04	395.27	395.38	469106.0
2023-03-16 18:30:00	SPY	ETF	395.39	395.98	395.36	395.91	57768.0
2023-03-16 19:00:00	SPY	ETF	395.9	396.29	395.8599	396.16	43815.0
2023-03-16 19:30:00	SPY	ETF	396.09	396.18	395.94	396.02	71887.0
2023-03-16 04:00:00	QQQ	ETF	300.3	300.54	299.53	300.0	71601.0
2023-03-16 04:30:00	QQQ	ETF	300.13	300.27	299.62	299.65	17101.0
2023-03-16 05:00:00	QQQ	ETF	299.6	299.82	298.89	299.35	34935.0
2023-03-16 05:30:00	QQQ	ETF	299.39	299.67	298.67	299.28	38934.0
2023-03-16 06:00:00	QQQ	ETF	299.4	299.6	299.02	299.58	9860.0
2023-03-16 06:30:00	QQQ	ETF	299.59	299.69	298.91	299.61	18670.0
2023-03-16 07:00:00	QQQ	ETF	299.61	299.66	298.78	299.1	90848.0
2023-03-16 07:30:00	QQQ	ETF	299.13	299.88	299.03	299.47	97231.0
2023-03-16 08:00:00	QQQ	ETF	299.42	300.27	298.78	299.59	325621.0
2023-03-16 08:30:00	QQQ	ETF	299.43	299.72	298.1	298.6	501598.0
2023-03-16 09:00:00	QQQ	ETF	298.58	298.87	297.6303	297.9	1008425.0
2023-03-16 09:30:00	QQQ	ETF	297.95	299.7	297.19	299.7	6387320.0
2023-03-16 10:00:00	QQQ	ETF	299.67	300.09	298.38	299.44	4081125.0
2023-03-16 10:30:00	QQQ	ETF	299.445	302.5	299.06	302.1	5683972.0
2023-03-16 11:00:00	QQQ	ETF	302.1	304.0	301.64	303.95	7024253.0
2023-03-16 11:30:00	QQQ	ETF	303.93	305.57	303.64	305.05	6166046.0
2023-03-16 12:00:00	QQQ	ETF	305.05	305.28	303.72	304.84	4446247.0
2023-03-16 12:30:00	QQQ	ETF	304.86	305.98	304.25	305.77	4657469.0

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

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