PREVIEW / etf_30min / 2006-12-20

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-12-20.parquet
  size:    88 KB
  rows:    3,175

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-12-20 05:30:00	SPY	ETF	142.59	142.59	142.59	142.59	1800.0
2006-12-20 06:00:00	SPY	ETF	142.56	142.56	142.56	142.56	2500.0
2006-12-20 07:00:00	SPY	ETF	142.51	142.51	142.48	142.48	7500.0
2006-12-20 07:30:00	SPY	ETF	142.48	142.5	142.43	142.45	120600.0
2006-12-20 08:00:00	SPY	ETF	142.45	142.51	142.37	142.41	353700.0
2006-12-20 08:30:00	SPY	ETF	142.42	142.45	142.37	142.38	223200.0
2006-12-20 09:00:00	SPY	ETF	142.38	142.41	142.29	142.29	315700.0
2006-12-20 09:30:00	SPY	ETF	142.28	142.53	142.23	142.53	6474500.0
2006-12-20 10:00:00	SPY	ETF	142.52	142.66	142.42	142.46	3986200.0
2006-12-20 10:30:00	SPY	ETF	142.47	142.62	142.42	142.59	4329900.0
2006-12-20 11:00:00	SPY	ETF	142.6	142.66	142.48	142.49	2150600.0
2006-12-20 11:30:00	SPY	ETF	142.4986	142.56	142.46	142.54	2010200.0
2006-12-20 12:00:00	SPY	ETF	142.55	142.59	142.49	142.52	779500.0
2006-12-20 12:30:00	SPY	ETF	142.53	142.54	142.4	142.46	1305700.0
2006-12-20 13:00:00	SPY	ETF	142.45	142.468	142.2	142.25	2545300.0
2006-12-20 13:30:00	SPY	ETF	142.25	142.25	142.05	142.2	4485700.0
2006-12-20 14:00:00	SPY	ETF	142.2	142.37	142.17	142.25	3522600.0
2006-12-20 14:30:00	SPY	ETF	142.25	142.32	142.16	142.2	2244000.0
2006-12-20 15:00:00	SPY	ETF	142.22	142.29	142.15	142.25	1738500.0
2006-12-20 15:30:00	SPY	ETF	142.25	142.28	142.08	142.08	2900400.0
2006-12-20 16:00:00	SPY	ETF	142.08	142.2	142.02	142.11	975100.0
2006-12-20 16:30:00	SPY	ETF	142.14	142.2	142.11	142.2	31200.0
2006-12-20 17:00:00	SPY	ETF	142.2	142.2	142.17	142.17	4100.0
2006-12-20 17:30:00	SPY	ETF	142.2	142.23	142.2	142.23	2600.0
2006-12-20 18:00:00	SPY	ETF	142.17	142.17	142.17	142.17	900.0
2006-12-20 18:30:00	SPY	ETF	142.23	142.23	142.23	142.23	100.0
2006-12-20 19:00:00	SPY	ETF	142.24	142.24	142.24	142.24	100.0
2006-12-20 19:30:00	SPY	ETF	142.23	142.24	142.23	142.24	500.0
2006-12-20 09:30:00	QQQ	ETF	43.9	44.06	43.86	44.06	9472700.0
2006-12-20 10:00:00	QQQ	ETF	44.05	44.11	43.94	43.96	10138300.0
2006-12-20 10:30:00	QQQ	ETF	43.97	44.07	43.95	44.03	5610200.0
2006-12-20 11:00:00	QQQ	ETF	44.04	44.06	43.96	43.96	3070200.0
2006-12-20 11:30:00	QQQ	ETF	43.96	44.02	43.95	44.01	3424000.0
2006-12-20 12:00:00	QQQ	ETF	44.0	44.03	43.97	43.99	2235900.0
2006-12-20 12:30:00	QQQ	ETF	43.98	43.99	43.9	43.95	2535700.0
2006-12-20 13:00:00	QQQ	ETF	43.94	43.96	43.75	43.78	6950300.0
2006-12-20 13:30:00	QQQ	ETF	43.79	43.79	43.67	43.74	5236600.0
2006-12-20 14:00:00	QQQ	ETF	43.75	43.86	43.75	43.81	2722600.0
2006-12-20 14:30:00	QQQ	ETF	43.81	43.84	43.76	43.78	2228100.0
2006-12-20 15:00:00	QQQ	ETF	43.77	43.85	43.76	43.83	1809600.0
2006-12-20 15:30:00	QQQ	ETF	43.82	43.83	43.68	43.69	6330700.0
2006-12-20 07:30:00	IWM	ETF	78.06	78.06	78.06	78.06	3000.0
2006-12-20 08:00:00	IWM	ETF	78.06	78.07	77.65	77.78	248300.0
2006-12-20 08:30:00	IWM	ETF	77.79	77.86	77.74	77.77	261300.0
2006-12-20 09:00:00	IWM	ETF	77.76	77.76	77.6	77.6	60000.0
2006-12-20 09:30:00	IWM	ETF	77.62	78.05	77.62	78.04	5960900.0
2006-12-20 10:00:00	IWM	ETF	78.04	78.25	78.04	78.08	4998600.0
2006-12-20 10:30:00	IWM	ETF	78.07	78.26	78.06	78.23	2292600.0
2006-12-20 11:00:00	IWM	ETF	78.23	78.25	78.1	78.14	1670600.0
2006-12-20 11:30:00	IWM	ETF	78.15	78.18	78.1	78.16	1114900.0

> showing 50 of 3,175 rows — these rows as CSV

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