PREVIEW / etf_30min / 2006-07-20

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-07-20.parquet
  size:    77 KB
  rows:    2,663

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-07-20 05:30:00	SPY	ETF	126.0	126.0	126.0	126.0	2000.0
2006-07-20 06:00:00	SPY	ETF	126.05	126.05	126.05	126.05	25000.0
2006-07-20 06:30:00	SPY	ETF	125.98	125.98	125.95	125.95	65000.0
2006-07-20 07:00:00	SPY	ETF	125.95	125.95	125.86	125.95	106600.0
2006-07-20 07:30:00	SPY	ETF	125.99	126.04	125.95	125.95	242400.0
2006-07-20 08:00:00	SPY	ETF	125.95	126.2	125.86	126.17	1390600.0
2006-07-20 08:30:00	SPY	ETF	126.15	126.16	125.93	126.09	1865200.0
2006-07-20 09:00:00	SPY	ETF	126.09	126.19	126.06	126.11	603200.0
2006-07-20 09:30:00	SPY	ETF	126.12	126.3	125.83	125.87	10578800.0
2006-07-20 10:00:00	SPY	ETF	125.85	125.96	125.66	125.89	15606200.0
2006-07-20 10:30:00	SPY	ETF	125.89	126.06	125.68	126.05	7295100.0
2006-07-20 11:00:00	SPY	ETF	126.06	126.15	125.91	125.98	7751700.0
2006-07-20 11:30:00	SPY	ETF	125.97	126.1	125.89	125.95	4445200.0
2006-07-20 12:00:00	SPY	ETF	125.94	125.98	125.77	125.81	6351600.0
2006-07-20 12:30:00	SPY	ETF	125.82	125.85	125.68	125.85	4148600.0
2006-07-20 13:00:00	SPY	ETF	125.85	125.94	125.76	125.85	2843800.0
2006-07-20 13:30:00	SPY	ETF	125.86	125.9	125.49	125.67	6029900.0
2006-07-20 14:00:00	SPY	ETF	125.65	125.93	125.34	125.35	11187100.0
2006-07-20 14:30:00	SPY	ETF	125.38	125.65	125.27	125.31	6712700.0
2006-07-20 15:00:00	SPY	ETF	125.3	125.56	125.13	125.22	7657300.0
2006-07-20 15:30:00	SPY	ETF	125.23	125.26	124.92	124.96	11189900.0
2006-07-20 16:00:00	SPY	ETF	124.97	125.11	124.68	125.08	2171200.0
2006-07-20 16:30:00	SPY	ETF	125.06	125.27	125.06	125.24	997400.0
2006-07-20 17:00:00	SPY	ETF	125.2	125.24	125.14	125.15	46600.0
2006-07-20 17:30:00	SPY	ETF	125.18	125.18	125.11	125.13	38700.0
2006-07-20 18:00:00	SPY	ETF	125.1	125.15	125.06	125.06	6800.0
2006-07-20 18:30:00	SPY	ETF	125.1	125.1	125.01	125.01	5100.0
2006-07-20 19:30:00	SPY	ETF	125.13	125.17	125.13	125.17	1800.0
2006-07-20 09:30:00	QQQ	ETF	36.74	36.8	36.55	36.55	21888900.0
2006-07-20 10:00:00	QQQ	ETF	36.55	36.62	36.4	36.49	17954600.0
2006-07-20 10:30:00	QQQ	ETF	36.48	36.56	36.38	36.55	12375600.0
2006-07-20 11:00:00	QQQ	ETF	36.56	36.6	36.48	36.5	4939300.0
2006-07-20 11:30:00	QQQ	ETF	36.5	36.62	36.48	36.54	4954900.0
2006-07-20 12:00:00	QQQ	ETF	36.53	36.54	36.38	36.4	12023300.0
2006-07-20 12:30:00	QQQ	ETF	36.4	36.41	36.29	36.39	7492000.0
2006-07-20 13:00:00	QQQ	ETF	36.4	36.43	36.3	36.39	6600200.0
2006-07-20 13:30:00	QQQ	ETF	36.39	36.4	36.17	36.25	6374800.0
2006-07-20 14:00:00	QQQ	ETF	36.25	36.35	36.17	36.23	13774900.0
2006-07-20 14:30:00	QQQ	ETF	36.23	36.38	36.22	36.27	7653700.0
2006-07-20 15:00:00	QQQ	ETF	36.27	36.34	36.15	36.22	8569500.0
2006-07-20 15:30:00	QQQ	ETF	36.21	36.23	36.04	36.06	11096700.0
2006-07-20 07:30:00	IWM	ETF	69.8	69.8	69.8	69.8	1000.0
2006-07-20 08:00:00	IWM	ETF	69.8	70.04	69.8	70.04	96200.0
2006-07-20 08:30:00	IWM	ETF	70.02	70.05	69.86	70.04	73500.0
2006-07-20 09:00:00	IWM	ETF	70.03	70.09	69.98	70.04	512800.0
2006-07-20 09:30:00	IWM	ETF	70.04	70.37	69.54	69.56	8993000.0
2006-07-20 10:00:00	IWM	ETF	69.58	69.6	69.13	69.35	10531600.0
2006-07-20 10:30:00	IWM	ETF	69.35	69.46	69.06	69.4	5561700.0
2006-07-20 11:00:00	IWM	ETF	69.36	69.44	69.12	69.13	2268300.0
2006-07-20 11:30:00	IWM	ETF	69.14	69.34	69.02	69.24	2980300.0

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

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