PREVIEW / etf_30min / 2001-06-26

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-06-26.parquet
  size:    15 KB
  rows:    374

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
2001-06-26 09:30:00	SPY	ETF	120.9	121.39	120.57	121.34	1347700.0
2001-06-26 10:00:00	SPY	ETF	121.31	121.69	120.94	121.07	1019300.0
2001-06-26 10:30:00	SPY	ETF	121.09	121.27	120.78	120.97	508400.0
2001-06-26 11:00:00	SPY	ETF	120.95	121.29	120.91	120.98	343500.0
2001-06-26 11:30:00	SPY	ETF	121.0	121.14	120.65	120.81	345400.0
2001-06-26 12:00:00	SPY	ETF	120.88	121.09	120.73	120.9	212300.0
2001-06-26 12:30:00	SPY	ETF	120.85	121.26	120.81	121.26	323700.0
2001-06-26 13:00:00	SPY	ETF	121.17	121.62	121.17	121.56	641800.0
2001-06-26 13:30:00	SPY	ETF	121.54	122.14	121.54	122.0	945000.0
2001-06-26 14:00:00	SPY	ETF	122.0	122.27	121.96	122.2	491900.0
2001-06-26 14:30:00	SPY	ETF	122.23	122.39	121.9	121.98	561300.0
2001-06-26 15:00:00	SPY	ETF	121.96	122.19	121.82	122.1	298100.0
2001-06-26 15:30:00	SPY	ETF	122.14	122.21	121.73	121.84	357200.0
2001-06-26 16:00:00	SPY	ETF	121.82	121.87	121.23	121.23	305200.0
2001-06-26 16:30:00	SPY	ETF	121.47	121.6	121.16	121.6	2800.0
2001-06-26 17:00:00	SPY	ETF	121.6	121.6	121.6	121.6	100.0
2001-06-26 17:30:00	SPY	ETF	121.6	121.6	121.6	121.6	100.0
2001-06-26 18:00:00	SPY	ETF	121.11	121.65	121.11	121.65	1000.0
2001-06-26 09:30:00	QQQ	ETF	42.54	43.15	42.48	43.13	8660000.0
2001-06-26 10:00:00	QQQ	ETF	43.09	43.29	42.64	42.8	7077900.0
2001-06-26 10:30:00	QQQ	ETF	42.8	43.0	42.66	42.76	2738500.0
2001-06-26 11:00:00	QQQ	ETF	42.76	43.03	42.73	42.78	1634900.0
2001-06-26 11:30:00	QQQ	ETF	42.8	42.85	42.5	42.63	2479300.0
2001-06-26 12:00:00	QQQ	ETF	42.64	42.75	42.6	42.63	1295000.0
2001-06-26 12:30:00	QQQ	ETF	42.65	42.85	42.61	42.82	1071000.0
2001-06-26 13:00:00	QQQ	ETF	42.83	43.17	42.76	43.15	2479900.0
2001-06-26 13:30:00	QQQ	ETF	43.13	43.55	43.01	43.55	6403000.0
2001-06-26 14:00:00	QQQ	ETF	43.47	43.75	43.45	43.66	4769500.0
2001-06-26 14:30:00	QQQ	ETF	43.65	43.85	43.5	43.51	3457100.0
2001-06-26 15:00:00	QQQ	ETF	43.51	43.79	43.45	43.77	3459000.0
2001-06-26 15:30:00	QQQ	ETF	43.78	43.89	43.52	43.6	3632900.0
2001-06-26 16:00:00	QQQ	ETF	43.65	43.75	43.4	43.4	2290300.0
2001-06-26 16:30:00	QQQ	ETF	43.45	43.48	43.29	43.38	472600.0
2001-06-26 17:00:00	QQQ	ETF	43.39	43.6	43.37	43.5	72900.0
2001-06-26 17:30:00	QQQ	ETF	43.5	43.55	43.46	43.5	11500.0
2001-06-26 18:00:00	QQQ	ETF	43.5	43.59	43.5	43.59	5500.0
2001-06-26 09:30:00	IWM	ETF	48.0	48.205	47.925	48.2	122400.0
2001-06-26 10:00:00	IWM	ETF	48.25	48.375	48.25	48.295	82400.0
2001-06-26 10:30:00	IWM	ETF	48.255	48.375	48.255	48.3	69600.0
2001-06-26 11:00:00	IWM	ETF	48.345	48.5	48.335	48.445	18800.0
2001-06-26 11:30:00	IWM	ETF	48.475	48.485	48.3	48.425	55800.0
2001-06-26 12:00:00	IWM	ETF	48.415	48.495	48.415	48.475	51600.0
2001-06-26 12:30:00	IWM	ETF	48.445	48.5	48.445	48.5	30600.0
2001-06-26 13:00:00	IWM	ETF	48.55	48.75	48.55	48.75	48400.0
2001-06-26 13:30:00	IWM	ETF	48.715	48.915	48.715	48.905	87800.0
2001-06-26 14:00:00	IWM	ETF	48.935	49.05	48.9	49.0	163800.0
2001-06-26 14:30:00	IWM	ETF	49.0	49.015	48.975	48.975	49000.0
2001-06-26 15:00:00	IWM	ETF	48.86	48.975	48.825	48.9	69600.0
2001-06-26 15:30:00	IWM	ETF	48.93	48.995	48.925	48.995	64400.0
2001-06-26 16:00:00	IWM	ETF	48.935	49.0	48.935	49.0	59000.0

> showing 50 of 374 rows — these rows as CSV

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