PREVIEW / etf_30min / 2011-04-20

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-04-20.parquet
  size:    291 KB
  rows:    9,749

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
2011-04-20 04:00:00	SPY	ETF	131.39	132.26	131.39	132.22	5040.0
2011-04-20 04:30:00	SPY	ETF	132.32	132.5	132.32	132.47	3900.0
2011-04-20 05:00:00	SPY	ETF	132.55	132.8	132.5	132.78	5700.0
2011-04-20 05:30:00	SPY	ETF	132.78	132.92	132.78	132.83	18175.0
2011-04-20 06:00:00	SPY	ETF	132.81	132.95	132.75	132.89	16490.0
2011-04-20 06:30:00	SPY	ETF	132.89	133.31	132.89	133.02	182995.0
2011-04-20 07:00:00	SPY	ETF	133.0	133.33	132.99	133.12	1061966.0
2011-04-20 07:30:00	SPY	ETF	133.12	133.16	133.0	133.08	528393.0
2011-04-20 08:00:00	SPY	ETF	133.02	133.16	133.02	133.14	1305307.0
2011-04-20 08:30:00	SPY	ETF	133.15	133.15	133.02	133.03	936202.0
2011-04-20 09:00:00	SPY	ETF	133.03	133.08	132.87	132.87	1932992.0
2011-04-20 09:30:00	SPY	ETF	132.88	133.05	132.79	132.94	20198104.0
2011-04-20 10:00:00	SPY	ETF	132.95	133.39	132.88	133.2	13993796.0
2011-04-20 10:30:00	SPY	ETF	133.19	133.27	133.13	133.23	6775995.0
2011-04-20 11:00:00	SPY	ETF	133.23	133.24	133.0	133.16	7980999.0
2011-04-20 11:30:00	SPY	ETF	133.16	133.31	133.06	133.23	9353762.0
2011-04-20 12:00:00	SPY	ETF	133.23	133.26	133.02	133.02	8010891.0
2011-04-20 12:30:00	SPY	ETF	133.02	133.14	132.93	132.95	10505572.0
2011-04-20 13:00:00	SPY	ETF	132.95	133.01	132.84	132.96	6059333.0
2011-04-20 13:30:00	SPY	ETF	132.97	133.08	132.86	133.025	5756416.0
2011-04-20 14:00:00	SPY	ETF	133.03	133.03	132.87	132.93	4735359.0
2011-04-20 14:30:00	SPY	ETF	132.93	133.09	132.93	133.01	4790707.0
2011-04-20 15:00:00	SPY	ETF	133.0	133.13	132.88	133.12	10610517.0
2011-04-20 15:30:00	SPY	ETF	133.12	133.2	133.04	133.13	19488121.0
2011-04-20 16:00:00	SPY	ETF	133.13	133.48	133.1	133.25	9218446.0
2011-04-20 16:30:00	SPY	ETF	133.27	133.8	133.26	133.77	9550444.0
2011-04-20 17:00:00	SPY	ETF	133.77	133.9	133.74	133.83	374552.0
2011-04-20 17:30:00	SPY	ETF	133.85	133.87	133.76	133.82	103185.0
2011-04-20 18:00:00	SPY	ETF	133.82	133.98	133.16	133.9	529393.0
2011-04-20 18:30:00	SPY	ETF	133.89	134.0	133.86	133.88	155694.0
2011-04-20 19:00:00	SPY	ETF	133.9	133.95	133.84	133.88	27840.0
2011-04-20 19:30:00	SPY	ETF	133.89	133.91	133.82	133.89	66379.0
2011-04-20 04:00:00	QQQ	ETF	57.16	57.16	57.16	57.16	200.0
2011-04-20 04:30:00	QQQ	ETF	57.23	57.3	57.23	57.3	2800.0
2011-04-20 06:00:00	QQQ	ETF	57.43	57.46	57.43	57.46	3800.0
2011-04-20 06:30:00	QQQ	ETF	57.47	57.61	57.46	57.5	4281.0
2011-04-20 07:00:00	QQQ	ETF	57.5	57.63	57.5	57.6	252971.0
2011-04-20 07:30:00	QQQ	ETF	57.59	57.59	57.48	57.48	178761.0
2011-04-20 08:00:00	QQQ	ETF	57.48	57.54	57.46	57.53	155650.0
2011-04-20 08:30:00	QQQ	ETF	57.55	57.56	57.52	57.53	553182.0
2011-04-20 09:00:00	QQQ	ETF	57.54	57.6	57.52	57.58	1500489.0
2011-04-20 09:30:00	QQQ	ETF	57.59	57.71	57.53	57.6301	7669977.0
2011-04-20 10:00:00	QQQ	ETF	57.63	57.92	57.59	57.88	7619604.0
2011-04-20 10:30:00	QQQ	ETF	57.88	57.94	57.87	57.891	3618785.0
2011-04-20 11:00:00	QQQ	ETF	57.8994	57.91	57.76	57.8101	2175781.0
2011-04-20 11:30:00	QQQ	ETF	57.81	57.92	57.8	57.8708	1986407.0
2011-04-20 12:00:00	QQQ	ETF	57.87	57.89	57.82	57.83	2381388.0
2011-04-20 12:30:00	QQQ	ETF	57.84	57.87	57.76	57.76	2133990.0
2011-04-20 13:00:00	QQQ	ETF	57.765	57.81	57.715	57.79	1352764.0
2011-04-20 13:30:00	QQQ	ETF	57.8	57.85	57.73	57.84	1447846.0

> showing 50 of 9,749 rows — these rows as CSV

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