PREVIEW / etf_30min / 2012-02-08

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-02-08.parquet
  size:    289 KB
  rows:    9,750

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
2012-02-08 04:00:00	SPY	ETF	135.19	135.2	135.13	135.13	26233.0
2012-02-08 04:30:00	SPY	ETF	135.13	135.17	135.02	135.02	13630.0
2012-02-08 05:00:00	SPY	ETF	135.06	135.06	134.91	134.91	6800.0
2012-02-08 05:30:00	SPY	ETF	134.99	135.01	134.99	134.99	3640.0
2012-02-08 06:00:00	SPY	ETF	134.96	135.02	134.89	135.0	26000.0
2012-02-08 06:30:00	SPY	ETF	134.88	135.07	134.88	135.07	81285.0
2012-02-08 07:00:00	SPY	ETF	135.04	135.08	134.92	134.98	317384.0
2012-02-08 07:30:00	SPY	ETF	134.98	135.09	134.95	135.03	139407.0
2012-02-08 08:00:00	SPY	ETF	135.02	135.09	134.95	135.08	334448.0
2012-02-08 08:30:00	SPY	ETF	135.08	135.09	134.94	134.94	475119.0
2012-02-08 09:00:00	SPY	ETF	134.94	134.96	134.82	134.87	740072.0
2012-02-08 09:30:00	SPY	ETF	134.86	135.18	134.7746	135.13	15230354.0
2012-02-08 10:00:00	SPY	ETF	135.13	135.22	135.07	135.135	8977267.0
2012-02-08 10:30:00	SPY	ETF	135.14	135.16	134.79	134.93	10510097.0
2012-02-08 11:00:00	SPY	ETF	134.93	135.0	134.36	134.45	16195052.0
2012-02-08 11:30:00	SPY	ETF	134.45	134.59	134.31	134.56	10596207.0
2012-02-08 12:00:00	SPY	ETF	134.56	134.7	134.53	134.69	7439643.0
2012-02-08 12:30:00	SPY	ETF	134.684	134.84	134.61	134.83	5878738.0
2012-02-08 13:00:00	SPY	ETF	134.82	134.885	134.69	134.879	6340810.0
2012-02-08 13:30:00	SPY	ETF	134.88	134.91	134.77	134.78	4701686.0
2012-02-08 14:00:00	SPY	ETF	134.78	135.0	134.75	134.92	6535544.0
2012-02-08 14:30:00	SPY	ETF	134.92	135.16	134.9	135.06	9488727.0
2012-02-08 15:00:00	SPY	ETF	135.07	135.11	134.98	135.07	5195142.0
2012-02-08 15:30:00	SPY	ETF	135.08	135.15	134.985	135.13	13333338.0
2012-02-08 16:00:00	SPY	ETF	135.15	135.21	134.46	135.18	11993583.0
2012-02-08 16:30:00	SPY	ETF	135.17	135.17	135.02	135.08	388874.0
2012-02-08 17:00:00	SPY	ETF	135.08	135.09	134.86	134.88	351270.0
2012-02-08 17:30:00	SPY	ETF	134.91	134.96	134.8344	134.87	1077462.0
2012-02-08 18:00:00	SPY	ETF	134.86	134.87	134.73	134.86	331610.0
2012-02-08 18:30:00	SPY	ETF	134.87	134.92	134.84	134.88	133321.0
2012-02-08 19:00:00	SPY	ETF	134.85	134.89	134.81	134.83	137719.0
2012-02-08 19:30:00	SPY	ETF	134.82	134.87	134.65	134.7	276665.0
2012-02-08 05:30:00	QQQ	ETF	62.24	62.24	62.24	62.24	100.0
2012-02-08 06:00:00	QQQ	ETF	62.23	62.23	62.2	62.2	6468.0
2012-02-08 06:30:00	QQQ	ETF	62.16	62.24	62.16	62.24	5775.0
2012-02-08 07:00:00	QQQ	ETF	62.22	62.22	62.17	62.17	3550.0
2012-02-08 07:30:00	QQQ	ETF	62.19	62.22	62.19	62.19	3616.0
2012-02-08 08:00:00	QQQ	ETF	62.2	62.24	62.19	62.24	86400.0
2012-02-08 08:30:00	QQQ	ETF	62.23	62.24	62.18	62.18	131288.0
2012-02-08 09:00:00	QQQ	ETF	62.18	62.18	62.13	62.15	374757.0
2012-02-08 09:30:00	QQQ	ETF	62.15	62.285	62.08	62.27	5486713.0
2012-02-08 10:00:00	QQQ	ETF	62.28	62.38	62.26	62.35	2872171.0
2012-02-08 10:30:00	QQQ	ETF	62.35	62.36	62.11	62.17	2786946.0
2012-02-08 11:00:00	QQQ	ETF	62.17	62.19	61.91	61.9633	5366539.0
2012-02-08 11:30:00	QQQ	ETF	61.97	62.09	61.92	62.06	2955007.0
2012-02-08 12:00:00	QQQ	ETF	62.06	62.14	62.05	62.1316	2120164.0
2012-02-08 12:30:00	QQQ	ETF	62.14	62.25	62.095	62.2325	1517365.0
2012-02-08 13:00:00	QQQ	ETF	62.24	62.31	62.2	62.3085	1233357.0
2012-02-08 13:30:00	QQQ	ETF	62.31	62.32	62.25	62.2501	930093.0
2012-02-08 14:00:00	QQQ	ETF	62.25	62.37	62.24	62.338	2517524.0

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

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