PREVIEW / etf_30min / 2005-07-08

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-07-08.parquet
  size:    47 KB
  rows:    1,595

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-07-08 07:00:00	SPY	ETF	120.25	120.25	120.25	120.25	3400.0
2005-07-08 07:30:00	SPY	ETF	120.24	120.32	120.24	120.28	61100.0
2005-07-08 08:00:00	SPY	ETF	120.27	120.48	120.27	120.34	475100.0
2005-07-08 08:30:00	SPY	ETF	120.32	120.4	120.16	120.22	470100.0
2005-07-08 09:00:00	SPY	ETF	120.24	120.27	119.98	119.98	538500.0
2005-07-08 09:30:00	SPY	ETF	119.97	120.22	119.72	120.0	9733700.0
2005-07-08 10:00:00	SPY	ETF	120.01	120.19	119.93	120.16	5423000.0
2005-07-08 10:30:00	SPY	ETF	120.16	120.53	120.12	120.4	7527500.0
2005-07-08 11:00:00	SPY	ETF	120.42	120.53	120.31	120.46	2739100.0
2005-07-08 11:30:00	SPY	ETF	120.46	120.66	120.46	120.64	3197100.0
2005-07-08 12:00:00	SPY	ETF	120.64	120.97	120.6	120.94	4905300.0
2005-07-08 12:30:00	SPY	ETF	120.94	121.1	120.88	120.98	3316100.0
2005-07-08 13:00:00	SPY	ETF	120.98	120.99	120.85	120.92	3470200.0
2005-07-08 13:30:00	SPY	ETF	120.92	120.95	120.78	120.95	1560100.0
2005-07-08 14:00:00	SPY	ETF	120.94	121.09	120.93	121.06	2179600.0
2005-07-08 14:30:00	SPY	ETF	121.06	121.14	120.93	121.1	3742700.0
2005-07-08 15:00:00	SPY	ETF	121.1	121.32	120.98	121.28	4050200.0
2005-07-08 15:30:00	SPY	ETF	121.28	121.32	121.12	121.21	6439800.0
2005-07-08 16:00:00	SPY	ETF	121.22	121.33	121.2	121.25	1811500.0
2005-07-08 16:30:00	SPY	ETF	121.26	121.28	121.25	121.28	49500.0
2005-07-08 17:00:00	SPY	ETF	121.26	121.34	121.26	121.33	5300.0
2005-07-08 17:30:00	SPY	ETF	121.32	121.32	121.3	121.3	2500.0
2005-07-08 18:00:00	SPY	ETF	121.32	121.32	121.32	121.32	2200.0
2005-07-08 18:30:00	SPY	ETF	121.33	121.33	121.33	121.33	100.0
2005-07-08 19:00:00	SPY	ETF	121.33	121.33	121.33	121.33	200.0
2005-07-08 09:30:00	QQQ	ETF	37.07	37.14	37.01	37.03	11488300.0
2005-07-08 10:00:00	QQQ	ETF	37.04	37.11	36.99	37.11	4304100.0
2005-07-08 10:30:00	QQQ	ETF	37.11	37.25	37.1	37.2	8782600.0
2005-07-08 11:00:00	QQQ	ETF	37.2	37.23	37.16	37.2	6907700.0
2005-07-08 11:30:00	QQQ	ETF	37.2	37.26	37.2	37.25	4529900.0
2005-07-08 12:00:00	QQQ	ETF	37.25	37.47	37.25	37.47	11440900.0
2005-07-08 12:30:00	QQQ	ETF	37.46	37.56	37.46	37.5	7270800.0
2005-07-08 13:00:00	QQQ	ETF	37.51	37.52	37.48	37.51	2147100.0
2005-07-08 13:30:00	QQQ	ETF	37.5	37.55	37.47	37.54	2353200.0
2005-07-08 14:00:00	QQQ	ETF	37.54	37.68	37.54	37.66	6297300.0
2005-07-08 14:30:00	QQQ	ETF	37.66	37.72	37.63	37.69	5930500.0
2005-07-08 15:00:00	QQQ	ETF	37.69	37.81	37.65	37.8	8392400.0
2005-07-08 15:30:00	QQQ	ETF	37.8	37.81	37.7	37.79	12168400.0
2005-07-08 08:00:00	IWM	ETF	64.75	64.92	64.75	64.92	42700.0
2005-07-08 08:30:00	IWM	ETF	64.92	64.92	64.73	64.76	41800.0
2005-07-08 09:00:00	IWM	ETF	64.76	64.84	64.64	64.64	63300.0
2005-07-08 09:30:00	IWM	ETF	64.64	64.83	64.55	64.65	2857300.0
2005-07-08 10:00:00	IWM	ETF	64.66	64.8	64.56	64.79	2547100.0
2005-07-08 10:30:00	IWM	ETF	64.79	64.94	64.7	64.85	1666600.0
2005-07-08 11:00:00	IWM	ETF	64.85	64.89	64.71	64.85	1465200.0
2005-07-08 11:30:00	IWM	ETF	64.85	65.05	64.85	65.05	1162800.0
2005-07-08 12:00:00	IWM	ETF	65.06	65.3	65.06	65.29	1204200.0
2005-07-08 12:30:00	IWM	ETF	65.29	65.47	65.29	65.41	1713900.0
2005-07-08 13:00:00	IWM	ETF	65.41	65.43	65.34	65.38	959500.0
2005-07-08 13:30:00	IWM	ETF	65.39	65.5	65.37	65.45	849200.0

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

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