PREVIEW / etf_30min / 2006-09-20

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-09-20.parquet
  size:    81 KB
  rows:    2,901

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-20 06:30:00	SPY	ETF	132.27	132.34	132.27	132.34	5000.0
2006-09-20 07:00:00	SPY	ETF	132.25	132.25	132.25	132.25	8400.0
2006-09-20 07:30:00	SPY	ETF	132.24	132.35	132.23	132.3	98000.0
2006-09-20 08:00:00	SPY	ETF	132.3	132.38	132.23	132.33	580400.0
2006-09-20 08:30:00	SPY	ETF	132.33	132.33	132.27	132.28	131800.0
2006-09-20 09:00:00	SPY	ETF	132.29	132.34	132.23	132.23	436000.0
2006-09-20 09:30:00	SPY	ETF	132.25	132.56	132.23	132.48	9199300.0
2006-09-20 10:00:00	SPY	ETF	132.48	132.61	132.34	132.6	5317900.0
2006-09-20 10:30:00	SPY	ETF	132.6	132.68	132.53	132.55	6311800.0
2006-09-20 11:00:00	SPY	ETF	132.54	132.62	132.48	132.54	3439100.0
2006-09-20 11:30:00	SPY	ETF	132.54	132.61	132.46	132.48	2483300.0
2006-09-20 12:00:00	SPY	ETF	132.48	132.55	132.42	132.48	1910900.0
2006-09-20 12:30:00	SPY	ETF	132.48	132.58	132.46	132.46	1887300.0
2006-09-20 13:00:00	SPY	ETF	132.46	132.55	132.41	132.46	1410800.0
2006-09-20 13:30:00	SPY	ETF	132.44	132.65	132.41	132.62	1649200.0
2006-09-20 14:00:00	SPY	ETF	132.62	132.77	132.17	132.21	12930500.0
2006-09-20 14:30:00	SPY	ETF	132.26	132.61	132.06	132.35	10675300.0
2006-09-20 15:00:00	SPY	ETF	132.35	132.58	132.3	132.51	7051100.0
2006-09-20 15:30:00	SPY	ETF	132.5	132.58	132.39	132.41	5953300.0
2006-09-20 16:00:00	SPY	ETF	132.42	132.56	132.4	132.53	916100.0
2006-09-20 16:30:00	SPY	ETF	132.49	132.53	132.45	132.49	262900.0
2006-09-20 17:00:00	SPY	ETF	132.49	132.49	132.45	132.45	12400.0
2006-09-20 17:30:00	SPY	ETF	132.49	132.49	132.49	132.49	500.0
2006-09-20 18:00:00	SPY	ETF	132.46	132.48	132.46	132.48	4200.0
2006-09-20 18:30:00	SPY	ETF	132.49	132.5	132.49	132.5	4500.0
2006-09-20 19:00:00	SPY	ETF	132.45	132.45	132.44	132.44	600.0
2006-09-20 09:30:00	QQQ	ETF	40.2	40.38	40.19	40.33	17016700.0
2006-09-20 10:00:00	QQQ	ETF	40.33	40.46	40.25	40.46	9820800.0
2006-09-20 10:30:00	QQQ	ETF	40.45	40.51	40.39	40.46	8020200.0
2006-09-20 11:00:00	QQQ	ETF	40.46	40.54	40.44	40.48	7043200.0
2006-09-20 11:30:00	QQQ	ETF	40.48	40.5	40.44	40.45	3561000.0
2006-09-20 12:00:00	QQQ	ETF	40.45	40.46	40.42	40.43	2380100.0
2006-09-20 12:30:00	QQQ	ETF	40.44	40.49	40.39	40.39	2929700.0
2006-09-20 13:00:00	QQQ	ETF	40.4	40.42	40.36	40.4	2292500.0
2006-09-20 13:30:00	QQQ	ETF	40.4	40.48	40.39	40.46	2896000.0
2006-09-20 14:00:00	QQQ	ETF	40.46	40.53	40.25	40.26	23829200.0
2006-09-20 14:30:00	QQQ	ETF	40.25	40.37	40.21	40.34	11061000.0
2006-09-20 15:00:00	QQQ	ETF	40.34	40.48	40.31	40.43	6309300.0
2006-09-20 15:30:00	QQQ	ETF	40.42	40.48	40.4	40.45	6693400.0
2006-09-20 07:00:00	IWM	ETF	72.2	72.3	72.2	72.3	400.0
2006-09-20 07:30:00	IWM	ETF	72.4	72.4	72.4	72.4	200.0
2006-09-20 08:00:00	IWM	ETF	72.56	72.81	72.56	72.7	120700.0
2006-09-20 08:30:00	IWM	ETF	72.71	72.81	72.71	72.76	399700.0
2006-09-20 09:00:00	IWM	ETF	72.75	72.81	72.7	72.8	611400.0
2006-09-20 09:30:00	IWM	ETF	72.79	73.06	72.78	73.02	7565400.0
2006-09-20 10:00:00	IWM	ETF	73.02	73.39	72.91	73.37	6895400.0
2006-09-20 10:30:00	IWM	ETF	73.37	73.5	73.27	73.29	5525100.0
2006-09-20 11:00:00	IWM	ETF	73.29	73.4	73.22	73.31	2227800.0
2006-09-20 11:30:00	IWM	ETF	73.32	73.37	73.19	73.24	1142000.0
2006-09-20 12:00:00	IWM	ETF	73.24	73.28	73.19	73.25	1067700.0

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

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