PREVIEW / etf_30min / 2005-11-02

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-11-02.parquet
  size:    51 KB
  rows:    1,782

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-11-02 07:00:00	SPY	ETF	120.6	120.6	120.5	120.5	26400.0
2005-11-02 07:30:00	SPY	ETF	120.43	120.45	120.42	120.42	19600.0
2005-11-02 08:00:00	SPY	ETF	120.37	120.61	120.21	120.29	406100.0
2005-11-02 08:30:00	SPY	ETF	120.28	120.44	120.26	120.27	776500.0
2005-11-02 09:00:00	SPY	ETF	120.27	120.34	120.17	120.17	254500.0
2005-11-02 09:30:00	SPY	ETF	120.17	120.77	120.13	120.63	7029200.0
2005-11-02 10:00:00	SPY	ETF	120.64	120.77	120.58	120.68	3426100.0
2005-11-02 10:30:00	SPY	ETF	120.69	121.07	120.58	120.98	9402700.0
2005-11-02 11:00:00	SPY	ETF	120.98	121.23	120.96	121.22	7092400.0
2005-11-02 11:30:00	SPY	ETF	121.2	121.38	121.18	121.25	3655700.0
2005-11-02 12:00:00	SPY	ETF	121.26	121.27	121.1	121.23	1796900.0
2005-11-02 12:30:00	SPY	ETF	121.2399	121.56	121.13	121.5	5982500.0
2005-11-02 13:00:00	SPY	ETF	121.49	121.54	121.36	121.4	2295700.0
2005-11-02 13:30:00	SPY	ETF	121.4	121.5	121.35	121.47	3273500.0
2005-11-02 14:00:00	SPY	ETF	121.46	121.66	121.34	121.48	5336100.0
2005-11-02 14:30:00	SPY	ETF	121.48	121.51	121.23	121.33	5179500.0
2005-11-02 15:00:00	SPY	ETF	121.33	121.6	121.29	121.55	3998700.0
2005-11-02 15:30:00	SPY	ETF	121.56	121.66	121.4	121.63	8932700.0
2005-11-02 16:00:00	SPY	ETF	121.63	121.75	121.55	121.65	1606900.0
2005-11-02 16:30:00	SPY	ETF	121.67	121.71	121.65	121.7	157800.0
2005-11-02 17:00:00	SPY	ETF	121.7	121.74	121.4495	121.74	62800.0
2005-11-02 18:00:00	SPY	ETF	121.7	121.73	121.68	121.7	15900.0
2005-11-02 09:30:00	QQQ	ETF	38.72	39.01	38.71	38.91	13601300.0
2005-11-02 10:00:00	QQQ	ETF	38.91	38.96	38.88	38.94	7351800.0
2005-11-02 10:30:00	QQQ	ETF	38.94	39.12	38.93	39.09	10662700.0
2005-11-02 11:00:00	QQQ	ETF	39.09	39.24	39.09	39.21	9308800.0
2005-11-02 11:30:00	QQQ	ETF	39.21	39.26	39.19	39.22	5790800.0
2005-11-02 12:00:00	QQQ	ETF	39.22	39.23	39.14	39.19	3477400.0
2005-11-02 12:30:00	QQQ	ETF	39.19	39.46	39.16	39.41	12226500.0
2005-11-02 13:00:00	QQQ	ETF	39.4	39.41	39.34	39.34	4543300.0
2005-11-02 13:30:00	QQQ	ETF	39.35	39.41	39.31	39.39	4718000.0
2005-11-02 14:00:00	QQQ	ETF	39.39	39.45	39.29	39.35	6911400.0
2005-11-02 14:30:00	QQQ	ETF	39.37	39.38	39.21	39.25	5538100.0
2005-11-02 15:00:00	QQQ	ETF	39.26	39.38	39.25	39.34	3979300.0
2005-11-02 15:30:00	QQQ	ETF	39.34	39.4	39.27	39.34	6457600.0
2005-11-02 07:30:00	IWM	ETF	64.11	64.11	64.1	64.11	27000.0
2005-11-02 08:00:00	IWM	ETF	64.1	64.14	63.91	63.91	777400.0
2005-11-02 08:30:00	IWM	ETF	63.96	64.0	63.96	63.97	15000.0
2005-11-02 09:00:00	IWM	ETF	63.97	63.97	63.89	63.89	4900.0
2005-11-02 09:30:00	IWM	ETF	63.92	64.59	63.85	64.42	3810000.0
2005-11-02 10:00:00	IWM	ETF	64.42	64.56	64.32	64.39	2423100.0
2005-11-02 10:30:00	IWM	ETF	64.39	64.78	64.36	64.75	3569900.0
2005-11-02 11:00:00	IWM	ETF	64.74	64.95	64.74	64.9	5083300.0
2005-11-02 11:30:00	IWM	ETF	64.91	64.95	64.82	64.88	1336600.0
2005-11-02 12:00:00	IWM	ETF	64.88	64.95	64.76	64.84	1024200.0
2005-11-02 12:30:00	IWM	ETF	64.84	65.09	64.75	65.02	2756400.0
2005-11-02 13:00:00	IWM	ETF	65.02	65.1	64.98	65.01	1460900.0
2005-11-02 13:30:00	IWM	ETF	65.0	65.14	64.96	65.04	1565200.0
2005-11-02 14:00:00	IWM	ETF	65.05	65.19	65.0	65.19	2056000.0
2005-11-02 14:30:00	IWM	ETF	65.19	65.22	65.03	65.1	1695700.0

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

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