PREVIEW / etf_30min / 2005-08-18

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-08-18.parquet
  size:    46 KB
  rows:    1,626

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-08-18 07:00:00	SPY	ETF	121.99	122.01	121.97	122.01	85300.0
2005-08-18 07:30:00	SPY	ETF	121.99	122.03	121.99	122.01	19700.0
2005-08-18 08:00:00	SPY	ETF	121.95	122.02	121.95	121.98	359400.0
2005-08-18 08:30:00	SPY	ETF	122.01	122.02	121.96	122.0	223800.0
2005-08-18 09:00:00	SPY	ETF	121.99	122.05	121.98	122.04	121700.0
2005-08-18 09:30:00	SPY	ETF	122.05	122.11	121.84	122.05	7683400.0
2005-08-18 10:00:00	SPY	ETF	122.06	122.2	121.96	122.15	5457500.0
2005-08-18 10:30:00	SPY	ETF	122.15	122.32	121.97	122.04	4252000.0
2005-08-18 11:00:00	SPY	ETF	122.02	122.18	121.93	122.06	2808000.0
2005-08-18 11:30:00	SPY	ETF	122.05	122.1	121.94	121.96	1771200.0
2005-08-18 12:00:00	SPY	ETF	121.98	122.25	121.98	122.21	3352900.0
2005-08-18 12:30:00	SPY	ETF	122.2	122.3	122.13	122.15	1608200.0
2005-08-18 13:00:00	SPY	ETF	122.16	122.49	122.14	122.49	2178600.0
2005-08-18 13:30:00	SPY	ETF	122.49	122.56	122.32	122.35	4326400.0
2005-08-18 14:00:00	SPY	ETF	122.35	122.35	122.0	122.03	3040100.0
2005-08-18 14:30:00	SPY	ETF	122.03	122.36	121.96	122.24	4346000.0
2005-08-18 15:00:00	SPY	ETF	122.23	122.39	122.09	122.13	3003300.0
2005-08-18 15:30:00	SPY	ETF	122.14	122.45	122.08	122.11	6130200.0
2005-08-18 16:00:00	SPY	ETF	122.1	122.25	122.03	122.2	1094800.0
2005-08-18 16:30:00	SPY	ETF	122.19	122.2	122.1	122.14	491500.0
2005-08-18 17:00:00	SPY	ETF	122.18	122.19	122.16	122.16	27200.0
2005-08-18 18:00:00	SPY	ETF	122.22	122.25	122.22	122.25	1300.0
2005-08-18 18:30:00	SPY	ETF	122.25	122.28	122.24	122.25	4700.0
2005-08-18 19:00:00	SPY	ETF	122.26	122.26	122.26	122.26	100.0
2005-08-18 09:30:00	QQQ	ETF	38.87	38.89	38.79	38.84	6929600.0
2005-08-18 10:00:00	QQQ	ETF	38.84	38.91	38.81	38.87	5806700.0
2005-08-18 10:30:00	QQQ	ETF	38.87	38.92	38.77	38.82	5888300.0
2005-08-18 11:00:00	QQQ	ETF	38.82	38.89	38.78	38.84	4872100.0
2005-08-18 11:30:00	QQQ	ETF	38.84	38.84	38.77	38.8	3544400.0
2005-08-18 12:00:00	QQQ	ETF	38.8	38.89	38.78	38.88	3726100.0
2005-08-18 12:30:00	QQQ	ETF	38.88	38.9	38.83	38.84	2158500.0
2005-08-18 13:00:00	QQQ	ETF	38.85	39.02	38.84	39.01	6665500.0
2005-08-18 13:30:00	QQQ	ETF	39.01	39.09	38.98	38.98	6929900.0
2005-08-18 14:00:00	QQQ	ETF	38.98	39.1	38.82	38.85	4324000.0
2005-08-18 14:30:00	QQQ	ETF	38.85	38.91	38.78	38.84	4483000.0
2005-08-18 15:00:00	QQQ	ETF	38.85	38.91	38.79	38.82	5000400.0
2005-08-18 15:30:00	QQQ	ETF	38.83	38.92	38.81	38.84	6683400.0
2005-08-18 08:00:00	IWM	ETF	64.84	64.84	64.84	64.84	200.0
2005-08-18 08:30:00	IWM	ETF	64.86	64.86	64.83	64.85	16300.0
2005-08-18 09:00:00	IWM	ETF	64.84	64.85	64.79	64.79	9000.0
2005-08-18 09:30:00	IWM	ETF	64.77	64.82	64.47	64.61	4012500.0
2005-08-18 10:00:00	IWM	ETF	64.61	64.88	64.552	64.85	2536800.0
2005-08-18 10:30:00	IWM	ETF	64.85	64.98	64.69	64.76	1449000.0
2005-08-18 11:00:00	IWM	ETF	64.75	64.87	64.66	64.75	592200.0
2005-08-18 11:30:00	IWM	ETF	64.76	64.84	64.68	64.74	930700.0
2005-08-18 12:00:00	IWM	ETF	64.75	64.88	64.74	64.85	1290700.0
2005-08-18 12:30:00	IWM	ETF	64.85	64.92	64.82	64.87	789400.0
2005-08-18 13:00:00	IWM	ETF	64.87	65.09	64.86	65.09	1098600.0
2005-08-18 13:30:00	IWM	ETF	65.09	65.15	65.0	65.07	850100.0
2005-08-18 14:00:00	IWM	ETF	65.07	65.1	64.88	64.89	2130800.0

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

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