PREVIEW / etf_30min / 2005-10-05

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-10-05.parquet
  size:    51 KB
  rows:    1,736

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
2005-10-05 07:00:00	SPY	ETF	121.24	121.24	121.24	121.24	2500.0
2005-10-05 07:30:00	SPY	ETF	121.28	121.28	121.25	121.25	2000.0
2005-10-05 08:00:00	SPY	ETF	121.28	121.32	121.19	121.29	260700.0
2005-10-05 08:30:00	SPY	ETF	121.29	121.32	121.22	121.31	1490600.0
2005-10-05 09:00:00	SPY	ETF	121.31	121.35	121.23	121.31	430600.0
2005-10-05 09:30:00	SPY	ETF	121.29	121.31	121.09	121.25	7704500.0
2005-10-05 10:00:00	SPY	ETF	121.25	121.25	120.67	120.84	12563800.0
2005-10-05 10:30:00	SPY	ETF	120.83	121.09	120.77	120.93	7307000.0
2005-10-05 11:00:00	SPY	ETF	120.92	121.03	120.42	120.46	6624200.0
2005-10-05 11:30:00	SPY	ETF	120.46	120.8	120.28	120.4	7468500.0
2005-10-05 12:00:00	SPY	ETF	120.41	120.6	120.22	120.55	6391800.0
2005-10-05 12:30:00	SPY	ETF	120.53	120.73	120.53	120.66	5222300.0
2005-10-05 13:00:00	SPY	ETF	120.66	120.98	120.61	120.85	5655800.0
2005-10-05 13:30:00	SPY	ETF	120.83	120.9	120.57	120.67	2810400.0
2005-10-05 14:00:00	SPY	ETF	120.67	120.96	120.56	120.8	7349700.0
2005-10-05 14:30:00	SPY	ETF	120.8	121.28	120.47	120.5	7506700.0
2005-10-05 15:00:00	SPY	ETF	120.47	120.87	112.09	120.1	10606200.0
2005-10-05 15:30:00	SPY	ETF	120.13	120.4	119.6	119.63	13195800.0
2005-10-05 16:00:00	SPY	ETF	119.62	119.74	119.56	119.57	798400.0
2005-10-05 16:30:00	SPY	ETF	119.6	119.75	119.59	119.6	137500.0
2005-10-05 17:00:00	SPY	ETF	119.62	119.65	119.6	119.65	12000.0
2005-10-05 17:30:00	SPY	ETF	119.66	119.68	119.66	119.66	6300.0
2005-10-05 18:00:00	SPY	ETF	119.67	119.67	119.62	119.67	7200.0
2005-10-05 18:30:00	SPY	ETF	119.7	119.7	119.7	119.7	300.0
2005-10-05 19:00:00	SPY	ETF	119.69	119.71	119.69	119.7	1600.0
2005-10-05 19:30:00	SPY	ETF	119.7	119.7	119.68	119.68	3200.0
2005-10-05 09:30:00	QQQ	ETF	39.31	39.34	39.25	39.28	9707500.0
2005-10-05 10:00:00	QQQ	ETF	39.29	39.29	38.98	39.08	17186600.0
2005-10-05 10:30:00	QQQ	ETF	39.08	39.17	39.02	39.1	11084000.0
2005-10-05 11:00:00	QQQ	ETF	39.1	39.15	38.99	39.0	3842100.0
2005-10-05 11:30:00	QQQ	ETF	39.01	39.06	38.9	38.97	8854100.0
2005-10-05 12:00:00	QQQ	ETF	38.97	39.03	38.9	39.01	6236100.0
2005-10-05 12:30:00	QQQ	ETF	39.01	39.11	39.01	39.07	5897800.0
2005-10-05 13:00:00	QQQ	ETF	39.07	39.2	39.06	39.14	3650400.0
2005-10-05 13:30:00	QQQ	ETF	39.13	39.15	39.02	39.06	3508400.0
2005-10-05 14:00:00	QQQ	ETF	39.06	39.19	39.03	39.12	5291500.0
2005-10-05 14:30:00	QQQ	ETF	39.12	39.15	39.05	39.05	3571500.0
2005-10-05 15:00:00	QQQ	ETF	39.05	39.1	38.84	38.92	10964200.0
2005-10-05 15:30:00	QQQ	ETF	38.92	39.15	38.74	38.74	12118800.0
2005-10-05 08:00:00	IWM	ETF	65.78	65.78	65.78	65.78	1000.0
2005-10-05 08:30:00	IWM	ETF	65.79	65.82	65.79	65.82	15800.0
2005-10-05 09:00:00	IWM	ETF	65.82	65.82	65.74	65.74	24700.0
2005-10-05 09:30:00	IWM	ETF	65.77	65.77	65.43	65.5	4006700.0
2005-10-05 10:00:00	IWM	ETF	65.49	65.49	64.8	64.96	6612400.0
2005-10-05 10:30:00	IWM	ETF	64.96	65.2	64.86	64.99	4772100.0
2005-10-05 11:00:00	IWM	ETF	64.98	65.01	64.63	64.66	1728200.0
2005-10-05 11:30:00	IWM	ETF	64.66	64.71	64.42	64.54	1550500.0
2005-10-05 12:00:00	IWM	ETF	64.54	64.76	64.46	64.69	1941300.0
2005-10-05 12:30:00	IWM	ETF	64.7	64.89	64.66	64.86	2195300.0
2005-10-05 13:00:00	IWM	ETF	64.87	65.22	64.87	65.15	4446300.0

> showing 50 of 1,736 rows — these rows as CSV

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