PREVIEW / etf_30min / 2010-09-10

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-09-10.parquet
  size:    243 KB
  rows:    8,139

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
2010-09-10 04:00:00	SPY	ETF	111.09	111.09	111.04	111.04	900.0
2010-09-10 04:30:00	SPY	ETF	111.07	111.07	111.07	111.07	100.0
2010-09-10 05:00:00	SPY	ETF	111.11	111.11	111.11	111.11	250.0
2010-09-10 05:30:00	SPY	ETF	111.0	111.0	110.91	110.91	200.0
2010-09-10 06:00:00	SPY	ETF	110.95	111.05	110.95	111.05	9400.0
2010-09-10 06:30:00	SPY	ETF	111.07	111.13	111.07	111.11	65615.0
2010-09-10 07:00:00	SPY	ETF	111.12	111.35	111.11	111.33	1338395.0
2010-09-10 07:30:00	SPY	ETF	111.3	111.31	111.18	111.26	505462.0
2010-09-10 08:00:00	SPY	ETF	111.25	111.29	111.15	111.22	2462642.0
2010-09-10 08:30:00	SPY	ETF	111.2	111.24	111.07	111.08	388764.0
2010-09-10 09:00:00	SPY	ETF	111.09	111.21	111.08	111.1	993521.0
2010-09-10 09:30:00	SPY	ETF	111.12	111.41	110.87	111.25	15644012.0
2010-09-10 10:00:00	SPY	ETF	111.25	111.47	111.15	111.42	9933820.0
2010-09-10 10:30:00	SPY	ETF	111.42	111.56	111.36	111.48	7716017.0
2010-09-10 11:00:00	SPY	ETF	111.48	111.5	111.27	111.4361	8723872.0
2010-09-10 11:30:00	SPY	ETF	111.435	111.45	111.05	111.13	6151041.0
2010-09-10 12:00:00	SPY	ETF	111.13	111.22	111.0	111.18	5827417.0
2010-09-10 12:30:00	SPY	ETF	111.175	111.32	111.04	111.225	4256579.0
2010-09-10 13:00:00	SPY	ETF	111.23	111.34	111.21	111.33	3660863.0
2010-09-10 13:30:00	SPY	ETF	111.32	111.42	111.26	111.327	8945401.0
2010-09-10 14:00:00	SPY	ETF	111.325	111.5	111.29	111.45	5721939.0
2010-09-10 14:30:00	SPY	ETF	111.45	111.56	111.38	111.44	6155776.0
2010-09-10 15:00:00	SPY	ETF	111.45	111.59	111.38	111.56	7211701.0
2010-09-10 15:30:00	SPY	ETF	111.565	111.61	111.36	111.52	18041616.0
2010-09-10 16:00:00	SPY	ETF	111.52	111.56	111.055	111.55	10126429.0
2010-09-10 16:30:00	SPY	ETF	111.56	111.58	111.4771	111.57	183446.0
2010-09-10 17:00:00	SPY	ETF	111.57	111.6	111.51	111.58	59399.0
2010-09-10 17:30:00	SPY	ETF	111.58	111.66	111.53	111.57	27331.0
2010-09-10 18:00:00	SPY	ETF	111.56	111.58	111.54	111.58	31818.0
2010-09-10 18:30:00	SPY	ETF	111.54	111.57	111.54	111.57	2680.0
2010-09-10 19:00:00	SPY	ETF	111.57	111.6	111.55	111.56	19882.0
2010-09-10 19:30:00	SPY	ETF	111.55	111.62	111.55	111.6	12415.0
2010-09-10 04:00:00	QQQ	ETF	46.55	46.57	46.47	46.47	16835.0
2010-09-10 04:30:00	QQQ	ETF	46.48	46.48	46.48	46.48	100.0
2010-09-10 05:30:00	QQQ	ETF	46.46	46.46	46.45	46.45	9500.0
2010-09-10 06:00:00	QQQ	ETF	46.5	46.5	46.5	46.5	200.0
2010-09-10 07:00:00	QQQ	ETF	46.53	46.6	46.53	46.6	100650.0
2010-09-10 07:30:00	QQQ	ETF	46.6	46.6	46.55	46.58	76115.0
2010-09-10 08:00:00	QQQ	ETF	46.6	46.6	46.52	46.57	1660430.0
2010-09-10 08:30:00	QQQ	ETF	46.58	46.58	46.51	46.51	284204.0
2010-09-10 09:00:00	QQQ	ETF	46.51	46.55	46.46	46.49	387829.0
2010-09-10 09:30:00	QQQ	ETF	46.48	46.63	46.33	46.52	8432782.0
2010-09-10 10:00:00	QQQ	ETF	46.52	46.63	46.43	46.58	5866092.0
2010-09-10 10:30:00	QQQ	ETF	46.58	46.67	46.52	46.59	4893833.0
2010-09-10 11:00:00	QQQ	ETF	46.59	46.6	46.44	46.5	3449494.0
2010-09-10 11:30:00	QQQ	ETF	46.505	46.51	46.33	46.365	2547552.0
2010-09-10 12:00:00	QQQ	ETF	46.37	46.37	46.25	46.33	3597331.0
2010-09-10 12:30:00	QQQ	ETF	46.32	46.4	46.27	46.3501	1214022.0
2010-09-10 13:00:00	QQQ	ETF	46.3537	46.4	46.33	46.3901	1439272.0
2010-09-10 13:30:00	QQQ	ETF	46.39	46.44	46.3601	46.41	3505481.0

> showing 50 of 8,139 rows — these rows as CSV

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