PREVIEW / etf_30min / 2006-11-20

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-11-20.parquet
  size:    87 KB
  rows:    3,096

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-11-20 04:00:00	SPY	ETF	140.0	140.0	139.91	139.91	2200.0
2006-11-20 06:30:00	SPY	ETF	140.13	140.13	140.13	140.13	500.0
2006-11-20 07:00:00	SPY	ETF	140.13	140.13	140.01	140.08	121900.0
2006-11-20 07:30:00	SPY	ETF	140.09	140.21	140.06	140.21	204700.0
2006-11-20 08:00:00	SPY	ETF	140.11	140.35	139.92	140.3	3698500.0
2006-11-20 08:30:00	SPY	ETF	140.3	140.32	140.0825	140.26	1421000.0
2006-11-20 09:00:00	SPY	ETF	140.26	140.3	140.23	140.3	466300.0
2006-11-20 09:30:00	SPY	ETF	140.3	140.39	140.09	140.34	7819200.0
2006-11-20 10:00:00	SPY	ETF	140.34	140.5	140.19	140.36	6492100.0
2006-11-20 10:30:00	SPY	ETF	140.37	140.68	140.36	140.65	5272700.0
2006-11-20 11:00:00	SPY	ETF	140.65	140.73	140.5	140.65	3272300.0
2006-11-20 11:30:00	SPY	ETF	140.64	140.74	140.55	140.62	3081700.0
2006-11-20 12:00:00	SPY	ETF	140.62	140.7	140.55	140.57	2699600.0
2006-11-20 12:30:00	SPY	ETF	140.57	140.66	140.43	140.6	2558000.0
2006-11-20 13:00:00	SPY	ETF	140.6	140.66	140.45	140.58	2608400.0
2006-11-20 13:30:00	SPY	ETF	140.58	140.65	140.51	140.54	2098200.0
2006-11-20 14:00:00	SPY	ETF	140.54	140.7	140.13	140.21	5663600.0
2006-11-20 14:30:00	SPY	ETF	140.21	140.34	140.1	140.33	5100400.0
2006-11-20 15:00:00	SPY	ETF	140.32	140.38	140.16	140.25	3632100.0
2006-11-20 15:30:00	SPY	ETF	140.25	140.4	140.15	140.37	5815900.0
2006-11-20 16:00:00	SPY	ETF	140.37	140.53	140.34	140.45	1150800.0
2006-11-20 16:30:00	SPY	ETF	140.46	140.46	140.4	140.4	230100.0
2006-11-20 17:00:00	SPY	ETF	140.42	140.44	140.39	140.39	56700.0
2006-11-20 17:30:00	SPY	ETF	140.41	140.41	140.38	140.38	1300.0
2006-11-20 18:00:00	SPY	ETF	140.42	140.42	140.42	140.42	1300.0
2006-11-20 18:30:00	SPY	ETF	140.41	140.44	140.41	140.44	10500.0
2006-11-20 19:00:00	SPY	ETF	140.42	140.42	140.37	140.37	4200.0
2006-11-20 19:30:00	SPY	ETF	140.4	140.4	140.37	140.37	700.0
2006-11-20 09:30:00	QQQ	ETF	44.16	44.23	44.01	44.19	23450300.0
2006-11-20 10:00:00	QQQ	ETF	44.19	44.31	44.12	44.22	8803200.0
2006-11-20 10:30:00	QQQ	ETF	44.22	44.42	44.18	44.39	10061700.0
2006-11-20 11:00:00	QQQ	ETF	44.38	44.41	44.3	44.36	3494500.0
2006-11-20 11:30:00	QQQ	ETF	44.35	44.37	44.3	44.36	3579000.0
2006-11-20 12:00:00	QQQ	ETF	44.36	44.4	44.34	44.34	2358700.0
2006-11-20 12:30:00	QQQ	ETF	44.34	44.38	44.3	44.37	3301100.0
2006-11-20 13:00:00	QQQ	ETF	44.36	44.38	44.32	44.36	1545400.0
2006-11-20 13:30:00	QQQ	ETF	44.37	44.41	44.34	44.38	2062900.0
2006-11-20 14:00:00	QQQ	ETF	44.38	44.48	44.14	44.18	10142400.0
2006-11-20 14:30:00	QQQ	ETF	44.18	44.28	44.13	44.27	10006900.0
2006-11-20 15:00:00	QQQ	ETF	44.28	44.3	44.21	44.27	4448400.0
2006-11-20 15:30:00	QQQ	ETF	44.26	44.38	44.26	44.38	6624900.0
2006-11-20 07:30:00	IWM	ETF	78.34	78.34	78.34	78.34	100.0
2006-11-20 08:00:00	IWM	ETF	78.33	78.38	78.29	78.36	645100.0
2006-11-20 08:30:00	IWM	ETF	78.38	78.4	78.28	78.28	220100.0
2006-11-20 09:00:00	IWM	ETF	78.34	78.38	78.3	78.36	129000.0
2006-11-20 09:30:00	IWM	ETF	78.35	78.5	78.11	78.41	6105000.0
2006-11-20 10:00:00	IWM	ETF	78.41	78.69	78.33	78.59	5933000.0
2006-11-20 10:30:00	IWM	ETF	78.61	78.83	78.6	78.77	2432400.0
2006-11-20 11:00:00	IWM	ETF	78.78	78.83	78.68	78.77	1217500.0
2006-11-20 11:30:00	IWM	ETF	78.76	78.82	78.406	78.67	2913300.0

> showing 50 of 3,096 rows — these rows as CSV

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