PREVIEW / etf_30min / 2006-08-31

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-08-31.parquet
  size:    74 KB
  rows:    2,741

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-31 04:30:00	SPY	ETF	130.68	130.68	130.67	130.67	200.0
2006-08-31 05:00:00	SPY	ETF	130.6	130.6	130.6	130.6	100.0
2006-08-31 05:30:00	SPY	ETF	130.57	130.57	130.57	130.57	100.0
2006-08-31 06:30:00	SPY	ETF	130.59	130.59	130.59	130.59	50000.0
2006-08-31 07:00:00	SPY	ETF	130.62	130.71	130.62	130.68	130300.0
2006-08-31 07:30:00	SPY	ETF	130.71	130.74	130.7	130.74	27400.0
2006-08-31 08:00:00	SPY	ETF	130.75	130.78	130.62	130.69	409300.0
2006-08-31 08:30:00	SPY	ETF	130.71	131.02	130.71	130.92	1488700.0
2006-08-31 09:00:00	SPY	ETF	130.91	130.91	130.8	130.85	159200.0
2006-08-31 09:30:00	SPY	ETF	130.85	130.9	130.71	130.81	4231500.0
2006-08-31 10:00:00	SPY	ETF	130.8	130.95	130.72	130.74	3527900.0
2006-08-31 10:30:00	SPY	ETF	130.74	130.83	130.58	130.8	4296100.0
2006-08-31 11:00:00	SPY	ETF	130.79	130.88	130.65	130.67	2023200.0
2006-08-31 11:30:00	SPY	ETF	130.66	130.8	130.62	130.68	1445300.0
2006-08-31 12:00:00	SPY	ETF	130.67	130.76	130.63	130.67	1739200.0
2006-08-31 12:30:00	SPY	ETF	130.66	130.82	130.63	130.73	1069900.0
2006-08-31 13:00:00	SPY	ETF	130.73	130.79	130.63	130.71	650000.0
2006-08-31 13:30:00	SPY	ETF	130.71	130.76	130.64	130.67	689700.0
2006-08-31 14:00:00	SPY	ETF	130.69	130.81	130.67	130.78	1869600.0
2006-08-31 14:30:00	SPY	ETF	130.78	130.93	130.72	130.91	1971600.0
2006-08-31 15:00:00	SPY	ETF	130.91	130.99	130.88	130.95	1988200.0
2006-08-31 15:30:00	SPY	ETF	130.95	130.96	130.69	130.69	3826100.0
2006-08-31 16:00:00	SPY	ETF	130.68	130.77	130.61	130.61	1314800.0
2006-08-31 16:30:00	SPY	ETF	130.7	130.76	130.68	130.72	37200.0
2006-08-31 17:00:00	SPY	ETF	130.71	130.71	130.71	130.71	100.0
2006-08-31 17:30:00	SPY	ETF	130.7	130.7	130.69	130.69	1100.0
2006-08-31 18:00:00	SPY	ETF	130.7	130.7	130.69	130.69	600.0
2006-08-31 18:30:00	SPY	ETF	130.74	130.74	130.69	130.69	41800.0
2006-08-31 19:00:00	SPY	ETF	130.74	130.75	130.74	130.75	1000.0
2006-08-31 19:30:00	SPY	ETF	130.74	130.74	130.74	130.74	20000.0
2006-08-31 09:30:00	QQQ	ETF	38.94	39.03	38.82	38.93	12440300.0
2006-08-31 10:00:00	QQQ	ETF	38.92	39.02	38.86	38.87	7625300.0
2006-08-31 10:30:00	QQQ	ETF	38.88	38.91	38.76	38.88	6495700.0
2006-08-31 11:00:00	QQQ	ETF	38.88	38.91	38.8	38.82	3389000.0
2006-08-31 11:30:00	QQQ	ETF	38.81	38.84	38.76	38.81	2714100.0
2006-08-31 12:00:00	QQQ	ETF	38.81	38.86	38.79	38.83	1745800.0
2006-08-31 12:30:00	QQQ	ETF	38.83	38.93	38.81	38.88	2212800.0
2006-08-31 13:00:00	QQQ	ETF	38.89	38.89	38.8	38.84	2223600.0
2006-08-31 13:30:00	QQQ	ETF	38.85	38.86	38.8	38.82	1282200.0
2006-08-31 14:00:00	QQQ	ETF	38.83	38.9	38.82	38.89	1755000.0
2006-08-31 14:30:00	QQQ	ETF	38.89	38.97	38.85	38.95	3105800.0
2006-08-31 15:00:00	QQQ	ETF	38.94	38.98	38.89	38.96	4079700.0
2006-08-31 15:30:00	QQQ	ETF	38.97	38.97	38.85	38.86	6432800.0
2006-08-31 07:30:00	IWM	ETF	71.8	71.8	71.8	71.8	2700.0
2006-08-31 08:00:00	IWM	ETF	71.88	71.88	71.78	71.81	70700.0
2006-08-31 08:30:00	IWM	ETF	71.92	72.12	71.92	72.06	346400.0
2006-08-31 09:00:00	IWM	ETF	72.06	72.06	71.92	71.98	399300.0
2006-08-31 09:30:00	IWM	ETF	71.96	72.12	71.86	72.08	5905800.0
2006-08-31 10:00:00	IWM	ETF	72.08	72.24	71.92	71.96	3971300.0
2006-08-31 10:30:00	IWM	ETF	71.96	71.965	71.79	71.9	3449800.0

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

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