PREVIEW / etf_30min / 2006-08-14

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-08-14.parquet
  size:    76 KB
  rows:    2,665

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-08-14 06:00:00	SPY	ETF	127.74	127.75	127.73	127.75	250000.0
2006-08-14 06:30:00	SPY	ETF	127.75	127.75	127.74	127.74	800.0
2006-08-14 07:00:00	SPY	ETF	127.75	127.79	127.71	127.74	47400.0
2006-08-14 07:30:00	SPY	ETF	127.74	127.74	127.65	127.65	55100.0
2006-08-14 08:00:00	SPY	ETF	127.68	127.75	127.01	127.01	398600.0
2006-08-14 08:30:00	SPY	ETF	127.67	127.77	127.61	127.68	835800.0
2006-08-14 09:00:00	SPY	ETF	127.67	127.67	127.61	127.64	90400.0
2006-08-14 09:30:00	SPY	ETF	127.63	127.77	127.46	127.52	8067500.0
2006-08-14 10:00:00	SPY	ETF	127.52	127.59	127.38	127.47	3012300.0
2006-08-14 10:30:00	SPY	ETF	127.47	127.59	127.41	127.56	2712900.0
2006-08-14 11:00:00	SPY	ETF	127.55	127.99	127.54	127.87	6802300.0
2006-08-14 11:30:00	SPY	ETF	127.86	128.09	127.83	128.03	4188700.0
2006-08-14 12:00:00	SPY	ETF	128.02	128.16	127.97	128.05	2987700.0
2006-08-14 12:30:00	SPY	ETF	128.05	128.08	127.93	127.94	2082200.0
2006-08-14 13:00:00	SPY	ETF	127.94	127.97	127.84	127.88	1374500.0
2006-08-14 13:30:00	SPY	ETF	127.89	127.99	127.73	127.75	2004700.0
2006-08-14 14:00:00	SPY	ETF	127.76	127.85	127.35	127.47	5410200.0
2006-08-14 14:30:00	SPY	ETF	127.47	127.58	127.17	127.24	3714200.0
2006-08-14 15:00:00	SPY	ETF	127.24	127.24	126.96	127.1	6620200.0
2006-08-14 15:30:00	SPY	ETF	127.1	127.12	126.92	127.04	4540400.0
2006-08-14 16:00:00	SPY	ETF	127.08	127.2	127.05	127.13	374300.0
2006-08-14 16:30:00	SPY	ETF	127.12	127.17	127.11	127.12	315800.0
2006-08-14 17:00:00	SPY	ETF	127.11	127.16	127.11	127.16	25000.0
2006-08-14 17:30:00	SPY	ETF	127.1	127.1	127.1	127.1	200000.0
2006-08-14 18:00:00	SPY	ETF	127.12	127.19	127.1	127.18	205500.0
2006-08-14 09:30:00	QQQ	ETF	36.86	36.94	36.81	36.86	12636200.0
2006-08-14 10:00:00	QQQ	ETF	36.85	36.89	36.74	36.78	5767300.0
2006-08-14 10:30:00	QQQ	ETF	36.79	36.91	36.78	36.89	4800100.0
2006-08-14 11:00:00	QQQ	ETF	36.89	37.16	36.89	37.12	14670900.0
2006-08-14 11:30:00	QQQ	ETF	37.12	37.24	37.09	37.22	10343400.0
2006-08-14 12:00:00	QQQ	ETF	37.22	37.27	37.2	37.22	4715400.0
2006-08-14 12:30:00	QQQ	ETF	37.22	37.23	37.15	37.16	2453600.0
2006-08-14 13:00:00	QQQ	ETF	37.16	37.19	37.09	37.12	3612800.0
2006-08-14 13:30:00	QQQ	ETF	37.11	37.18	37.05	37.06	5185200.0
2006-08-14 14:00:00	QQQ	ETF	37.06	37.11	36.93	37.02	12718800.0
2006-08-14 14:30:00	QQQ	ETF	37.01	37.06	36.87	36.89	6937300.0
2006-08-14 15:00:00	QQQ	ETF	36.9	36.9	36.75	36.8	11775300.0
2006-08-14 15:30:00	QQQ	ETF	36.8	36.82	36.7	36.76	8484500.0
2006-08-14 08:00:00	IWM	ETF	68.1	68.25	67.6	68.18	518500.0
2006-08-14 08:30:00	IWM	ETF	68.18	68.2	68.08	68.13	59400.0
2006-08-14 09:00:00	IWM	ETF	68.18	68.22	68.07	68.09	523400.0
2006-08-14 09:30:00	IWM	ETF	68.09	68.26	67.91	68.05	5431300.0
2006-08-14 10:00:00	IWM	ETF	68.05	68.11	67.94	68.01	3381500.0
2006-08-14 10:30:00	IWM	ETF	68.02	68.28	68.01	68.25	2389100.0
2006-08-14 11:00:00	IWM	ETF	68.25	68.7	68.24	68.62	5740100.0
2006-08-14 11:30:00	IWM	ETF	68.61	68.82	68.56	68.76	2044300.0
2006-08-14 12:00:00	IWM	ETF	68.76	68.8	68.7	68.75	1434900.0
2006-08-14 12:30:00	IWM	ETF	68.75	68.76	68.62	68.63	727600.0
2006-08-14 13:00:00	IWM	ETF	68.62	68.64	68.5	68.54	3537700.0
2006-08-14 13:30:00	IWM	ETF	68.53	68.6	68.32	68.37	1581100.0

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

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