PREVIEW / etf_30min / 2006-09-05

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-09-05.parquet
  size:    78 KB
  rows:    2,814

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-09-05 06:30:00	SPY	ETF	131.36	131.38	131.36	131.37	300.0
2006-09-05 07:00:00	SPY	ETF	131.47	131.47	131.44	131.44	6500.0
2006-09-05 07:30:00	SPY	ETF	131.59	131.6	131.56	131.56	15100.0
2006-09-05 08:00:00	SPY	ETF	131.56	131.69	131.42	131.67	1099800.0
2006-09-05 08:30:00	SPY	ETF	131.65	131.67	131.53	131.54	46200.0
2006-09-05 09:00:00	SPY	ETF	131.52	131.63	131.45	131.51	299100.0
2006-09-05 09:30:00	SPY	ETF	131.51	131.54	131.2	131.34	7216100.0
2006-09-05 10:00:00	SPY	ETF	131.35	131.55	131.26	131.43	4340500.0
2006-09-05 10:30:00	SPY	ETF	131.43	131.44	131.26	131.32	4445700.0
2006-09-05 11:00:00	SPY	ETF	131.33	131.55	131.3	131.54	2939100.0
2006-09-05 11:30:00	SPY	ETF	131.54	131.82	131.51	131.78	6184900.0
2006-09-05 12:00:00	SPY	ETF	131.79	131.84	131.69	131.77	1280800.0
2006-09-05 12:30:00	SPY	ETF	131.77	131.78	131.61	131.63	1871300.0
2006-09-05 13:00:00	SPY	ETF	131.64	131.69	131.52	131.64	1909000.0
2006-09-05 13:30:00	SPY	ETF	131.65	131.69	131.42	131.54	2280500.0
2006-09-05 14:00:00	SPY	ETF	131.54	131.83	131.46	131.74	7438600.0
2006-09-05 14:30:00	SPY	ETF	131.74	131.85	131.66	131.8	2602000.0
2006-09-05 15:00:00	SPY	ETF	131.81	131.82	131.63	131.68	2637400.0
2006-09-05 15:30:00	SPY	ETF	131.68	131.79	131.67	131.7	2848500.0
2006-09-05 16:00:00	SPY	ETF	131.69	131.72	131.61	131.68	359500.0
2006-09-05 16:30:00	SPY	ETF	131.68	131.7	131.62	131.67	980000.0
2006-09-05 17:00:00	SPY	ETF	131.65	131.65	131.59	131.6	13300.0
2006-09-05 17:30:00	SPY	ETF	131.64	131.64	131.64	131.64	500.0
2006-09-05 19:00:00	SPY	ETF	131.6	131.6	131.6	131.6	200.0
2006-09-05 19:30:00	SPY	ETF	131.58	131.58	131.58	131.58	1400.0
2006-09-05 09:30:00	QQQ	ETF	39.12	39.13	38.85	38.94	12205400.0
2006-09-05 10:00:00	QQQ	ETF	38.93	39.08	38.9	39.01	9634700.0
2006-09-05 10:30:00	QQQ	ETF	39.01	39.02	38.92	38.95	5084400.0
2006-09-05 11:00:00	QQQ	ETF	38.96	39.15	38.94	39.15	3497400.0
2006-09-05 11:30:00	QQQ	ETF	39.15	39.4	39.13	39.38	12542100.0
2006-09-05 12:00:00	QQQ	ETF	39.38	39.43	39.32	39.36	5037700.0
2006-09-05 12:30:00	QQQ	ETF	39.37	39.37	39.31	39.32	5070400.0
2006-09-05 13:00:00	QQQ	ETF	39.32	39.34	39.06	39.33	3356400.0
2006-09-05 13:30:00	QQQ	ETF	39.33	39.35	39.2	39.29	3141200.0
2006-09-05 14:00:00	QQQ	ETF	39.29	39.45	39.25	39.4	5263400.0
2006-09-05 14:30:00	QQQ	ETF	39.4	39.48	39.35	39.47	4805600.0
2006-09-05 15:00:00	QQQ	ETF	39.47	39.47	39.38	39.43	3770500.0
2006-09-05 15:30:00	QQQ	ETF	39.43	39.47	39.42	39.46	5849000.0
2006-09-05 07:00:00	IWM	ETF	71.8	71.8	71.8	71.8	1100.0
2006-09-05 07:30:00	IWM	ETF	71.8	71.8	71.8	71.8	700.0
2006-09-05 08:00:00	IWM	ETF	71.9	71.9	71.72	71.84	227500.0
2006-09-05 08:30:00	IWM	ETF	71.84	72.01	71.84	71.97	321200.0
2006-09-05 09:00:00	IWM	ETF	71.97	71.97	71.86	71.96	914300.0
2006-09-05 09:30:00	IWM	ETF	71.93	72.06	71.7	71.91	5285600.0
2006-09-05 10:00:00	IWM	ETF	71.91	72.31	71.85	72.2	4646000.0
2006-09-05 10:30:00	IWM	ETF	72.2	72.2	71.94	72.02	2692200.0
2006-09-05 11:00:00	IWM	ETF	72.02	72.31	72.01	72.31	2260100.0
2006-09-05 11:30:00	IWM	ETF	72.3	72.52	72.3	72.45	3272700.0
2006-09-05 12:00:00	IWM	ETF	72.45	72.5	72.41	72.46	2496600.0
2006-09-05 12:30:00	IWM	ETF	72.46	72.47	72.27	72.28	1987200.0

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

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