PREVIEW / etf_30min / 2006-04-20

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-04-20.parquet
  size:    62 KB
  rows:    2,218

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
2006-04-20 05:00:00	SPY	ETF	131.02	131.02	131.02	131.02	15000.0
2006-04-20 05:30:00	SPY	ETF	131.04	131.04	131.02	131.02	10100.0
2006-04-20 06:00:00	SPY	ETF	131.04	131.04	131.04	131.04	100.0
2006-04-20 06:30:00	SPY	ETF	131.07	131.07	131.07	131.07	100.0
2006-04-20 07:00:00	SPY	ETF	131.1	131.12	131.02	131.02	69600.0
2006-04-20 07:30:00	SPY	ETF	131.09	131.13	131.09	131.09	28500.0
2006-04-20 08:00:00	SPY	ETF	131.11	131.11	131.01	131.11	832400.0
2006-04-20 08:30:00	SPY	ETF	131.12	131.12	130.95	131.09	337400.0
2006-04-20 09:00:00	SPY	ETF	131.08	131.08	130.99	131.01	415300.0
2006-04-20 09:30:00	SPY	ETF	131.0	131.06	130.86	131.0	5626200.0
2006-04-20 10:00:00	SPY	ETF	131.0	131.86	130.97	131.75	21758700.0
2006-04-20 10:30:00	SPY	ETF	131.73	131.85	131.0	131.13	9840100.0
2006-04-20 11:00:00	SPY	ETF	131.13	131.25	130.6	130.9	7517100.0
2006-04-20 11:30:00	SPY	ETF	130.92	131.2	130.92	131.18	4936600.0
2006-04-20 12:00:00	SPY	ETF	131.18	131.24	130.97	131.12	5129800.0
2006-04-20 12:30:00	SPY	ETF	131.14	131.43	131.1	131.43	2136200.0
2006-04-20 13:00:00	SPY	ETF	131.41	131.48	131.08	131.19	5662800.0
2006-04-20 13:30:00	SPY	ETF	131.19	131.29	131.13	131.26	1596900.0
2006-04-20 14:00:00	SPY	ETF	131.24	131.29	131.0058	131.25	4556600.0
2006-04-20 14:30:00	SPY	ETF	131.25	131.39	131.14	131.22	4729000.0
2006-04-20 15:00:00	SPY	ETF	131.23	131.4	131.16	131.28	2522600.0
2006-04-20 15:30:00	SPY	ETF	131.28	131.3	131.13	131.15	2719900.0
2006-04-20 16:00:00	SPY	ETF	131.15	131.23	131.08	131.15	700500.0
2006-04-20 16:30:00	SPY	ETF	131.16	131.26	131.15	131.25	529100.0
2006-04-20 17:00:00	SPY	ETF	131.26	131.32	131.26	131.3	27000.0
2006-04-20 17:30:00	SPY	ETF	131.3	131.35	131.2	131.29	17200.0
2006-04-20 18:00:00	SPY	ETF	131.25	131.25	131.22	131.22	1200.0
2006-04-20 18:30:00	SPY	ETF	131.25	131.25	131.25	131.25	300.0
2006-04-20 19:00:00	SPY	ETF	131.24	131.24	131.2	131.23	1100.0
2006-04-20 19:30:00	SPY	ETF	131.23	131.23	131.23	131.23	200.0
2006-04-20 09:30:00	QQQ	ETF	42.62	42.64	42.49	42.55	6674200.0
2006-04-20 10:00:00	QQQ	ETF	42.54	42.82	42.0	42.77	12004400.0
2006-04-20 10:30:00	QQQ	ETF	42.78	42.78	42.47	42.54	12556500.0
2006-04-20 11:00:00	QQQ	ETF	42.54	42.61	42.38	42.48	8715900.0
2006-04-20 11:30:00	QQQ	ETF	42.48	42.55	42.46	42.53	3305800.0
2006-04-20 12:00:00	QQQ	ETF	42.53	42.56	42.44	42.48	5068400.0
2006-04-20 12:30:00	QQQ	ETF	42.49	42.6	42.46	42.6	3546100.0
2006-04-20 13:00:00	QQQ	ETF	42.6	42.61	42.5	42.56	4278200.0
2006-04-20 13:30:00	QQQ	ETF	42.56	42.56	42.5	42.52	3324000.0
2006-04-20 14:00:00	QQQ	ETF	42.52	42.54	42.44	42.5	3424200.0
2006-04-20 14:30:00	QQQ	ETF	42.51	42.55	42.48	42.54	2204300.0
2006-04-20 15:00:00	QQQ	ETF	42.54	42.58	42.51	42.53	3031800.0
2006-04-20 15:30:00	QQQ	ETF	42.53	42.55	42.46	42.5	6163700.0
2006-04-20 07:00:00	IWM	ETF	77.1	77.1	77.1	77.1	100.0
2006-04-20 07:30:00	IWM	ETF	77.2	77.2	77.2	77.2	100.0
2006-04-20 08:00:00	IWM	ETF	77.3	77.4	77.3	77.4	5000.0
2006-04-20 08:30:00	IWM	ETF	77.4	77.45	77.26	77.44	131100.0
2006-04-20 09:00:00	IWM	ETF	77.43	77.43	77.32	77.33	91200.0
2006-04-20 09:30:00	IWM	ETF	77.33	77.33	76.93	77.08	2451400.0
2006-04-20 10:00:00	IWM	ETF	77.08	77.32	77.01	77.25	4366100.0

> showing 50 of 2,218 rows — these rows as CSV

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