PREVIEW / etf_30min / 2005-10-06

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-10-06.parquet
  size:    52 KB
  rows:    1,765

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-06 07:00:00	SPY	ETF	119.53	119.55	119.5	119.55	15000.0
2005-10-06 07:30:00	SPY	ETF	119.55	119.59	119.54	119.57	77500.0
2005-10-06 08:00:00	SPY	ETF	119.57	119.91	119.47	119.85	2731300.0
2005-10-06 08:30:00	SPY	ETF	119.83	120.08	119.4	119.94	1798800.0
2005-10-06 09:00:00	SPY	ETF	119.94	119.95	119.78	119.8	661100.0
2005-10-06 09:30:00	SPY	ETF	119.78	120.02	119.5	119.95	14034200.0
2005-10-06 10:00:00	SPY	ETF	119.96	120.04	119.52	119.77	10691500.0
2005-10-06 10:30:00	SPY	ETF	119.76	119.97	119.61	119.93	10216400.0
2005-10-06 11:00:00	SPY	ETF	119.92	120.26	119.57	120.05	8570600.0
2005-10-06 11:30:00	SPY	ETF	120.05	120.15	119.9	120.04	3820300.0
2005-10-06 12:00:00	SPY	ETF	120.05	120.21	119.66	119.67	5870400.0
2005-10-06 12:30:00	SPY	ETF	119.67	119.87	119.43	119.78	7655800.0
2005-10-06 13:00:00	SPY	ETF	119.78	119.96	119.61	119.73	3296700.0
2005-10-06 13:30:00	SPY	ETF	119.74	119.82	119.15	119.21	8944100.0
2005-10-06 14:00:00	SPY	ETF	119.18	119.6	118.98	119.24	11898200.0
2005-10-06 14:30:00	SPY	ETF	119.26	119.26	118.82	119.01	8208100.0
2005-10-06 15:00:00	SPY	ETF	119.02	119.04	118.47	118.48	10298800.0
2005-10-06 15:30:00	SPY	ETF	118.5	119.45	118.17	119.15	22665200.0
2005-10-06 16:00:00	SPY	ETF	119.16	119.3	119.12	119.21	695300.0
2005-10-06 16:30:00	SPY	ETF	119.21	119.43	119.19	119.43	264400.0
2005-10-06 17:00:00	SPY	ETF	119.43	119.46	119.23	119.23	808600.0
2005-10-06 17:30:00	SPY	ETF	119.22	119.22	119.01	119.2	706800.0
2005-10-06 18:00:00	SPY	ETF	119.19	119.41	119.18	119.32	100700.0
2005-10-06 18:30:00	SPY	ETF	119.32	119.34	119.31	119.31	11500.0
2005-10-06 19:00:00	SPY	ETF	119.29	119.34	119.29	119.34	3500.0
2005-10-06 19:30:00	SPY	ETF	119.34	119.37	119.31	119.35	87700.0
2005-10-06 09:30:00	QQQ	ETF	38.73	38.8	38.54	38.7	19589900.0
2005-10-06 10:00:00	QQQ	ETF	38.7	38.75	38.56	38.66	10673100.0
2005-10-06 10:30:00	QQQ	ETF	38.66	38.77	38.6	38.68	10921800.0
2005-10-06 11:00:00	QQQ	ETF	38.68	38.86	38.63	38.76	11446000.0
2005-10-06 11:30:00	QQQ	ETF	38.76	38.79	38.65	38.68	7052200.0
2005-10-06 12:00:00	QQQ	ETF	38.68	38.75	38.58	38.59	4388600.0
2005-10-06 12:30:00	QQQ	ETF	38.59	38.63	38.52	38.6	10402600.0
2005-10-06 13:00:00	QQQ	ETF	38.6	38.69	38.54	38.62	5774500.0
2005-10-06 13:30:00	QQQ	ETF	38.61	38.64	38.36	38.37	11773600.0
2005-10-06 14:00:00	QQQ	ETF	38.38	38.42	38.27	38.35	14312800.0
2005-10-06 14:30:00	QQQ	ETF	38.35	38.4	38.23	38.29	9222200.0
2005-10-06 15:00:00	QQQ	ETF	38.29	38.32	38.02	38.03	16227800.0
2005-10-06 15:30:00	QQQ	ETF	38.03	38.37	37.92	38.25	22218000.0
2005-10-06 07:30:00	IWM	ETF	64.07	64.07	64.07	64.07	200.0
2005-10-06 08:00:00	IWM	ETF	64.0	64.22	64.0	64.1	221500.0
2005-10-06 08:30:00	IWM	ETF	64.18	64.25	64.1	64.25	1367600.0
2005-10-06 09:00:00	IWM	ETF	64.21	64.24	64.16	64.2	60600.0
2005-10-06 09:30:00	IWM	ETF	64.09	64.43	63.78	64.18	8036400.0
2005-10-06 10:00:00	IWM	ETF	64.17	64.29	63.69	63.86	6327400.0
2005-10-06 10:30:00	IWM	ETF	63.86	64.1	63.64	64.0	6378600.0
2005-10-06 11:00:00	IWM	ETF	64.0	64.53	63.94	64.18	4905400.0
2005-10-06 11:30:00	IWM	ETF	64.17	64.42	64.12	64.24	1911200.0
2005-10-06 12:00:00	IWM	ETF	64.23	64.4	64.0	64.05	1143900.0
2005-10-06 12:30:00	IWM	ETF	64.05	64.23	63.9	64.17	2364800.0

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

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