PREVIEW / etf_30min / 2012-01-27

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-01-27.parquet
  size:    285 KB
  rows:    9,537

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-01-27 04:00:00	SPY	ETF	132.04	132.04	131.97	131.97	300.0
2012-01-27 04:30:00	SPY	ETF	132.02	132.11	132.02	132.11	1200.0
2012-01-27 05:00:00	SPY	ETF	132.19	132.22	132.12	132.12	1950.0
2012-01-27 05:30:00	SPY	ETF	132.22	132.33	132.14	132.32	60200.0
2012-01-27 06:00:00	SPY	ETF	132.22	132.22	132.16	132.16	15350.0
2012-01-27 06:30:00	SPY	ETF	132.19	132.19	132.06	132.06	13687.0
2012-01-27 07:00:00	SPY	ETF	132.1	132.11	131.97	132.04	103620.0
2012-01-27 07:30:00	SPY	ETF	132.03	132.19	131.95	132.17	172610.0
2012-01-27 08:00:00	SPY	ETF	132.14	132.19	131.97	132.1	586599.0
2012-01-27 08:30:00	SPY	ETF	132.12	132.12	131.14	131.23	3166991.0
2012-01-27 09:00:00	SPY	ETF	131.23	131.42	131.21	131.24	1455969.0
2012-01-27 09:30:00	SPY	ETF	131.24	131.86	131.15	131.75	16635731.0
2012-01-27 10:00:00	SPY	ETF	131.75	131.79	131.34	131.66	13456581.0
2012-01-27 10:30:00	SPY	ETF	131.66	131.8	131.28	131.53	9138581.0
2012-01-27 11:00:00	SPY	ETF	131.52	131.72	131.48	131.63	7943576.0
2012-01-27 11:30:00	SPY	ETF	131.64	131.64	131.23	131.45	8431611.0
2012-01-27 12:00:00	SPY	ETF	131.46	131.6	131.16	131.38	10763843.0
2012-01-27 12:30:00	SPY	ETF	131.38	131.49	131.18	131.24	6566392.0
2012-01-27 13:00:00	SPY	ETF	131.24	131.55	131.18	131.46	7254474.0
2012-01-27 13:30:00	SPY	ETF	131.46	131.6738	131.42	131.63	5085331.0
2012-01-27 14:00:00	SPY	ETF	131.62	131.73	131.45	131.5299	5093804.0
2012-01-27 14:30:00	SPY	ETF	131.53	131.79	131.49	131.72	6305189.0
2012-01-27 15:00:00	SPY	ETF	131.72	132.05	131.685	131.99	9366653.0
2012-01-27 15:30:00	SPY	ETF	131.985	132.0	131.68	131.71	14524871.0
2012-01-27 16:00:00	SPY	ETF	131.71	132.14	131.5847	131.74	6966363.0
2012-01-27 16:30:00	SPY	ETF	131.73	131.8186	131.71	131.8	318407.0
2012-01-27 17:00:00	SPY	ETF	131.8	131.81	131.77	131.8	695112.0
2012-01-27 17:30:00	SPY	ETF	131.79	131.82	131.78	131.81	67497.0
2012-01-27 18:00:00	SPY	ETF	131.81	131.83	131.8	131.8	23178.0
2012-01-27 18:30:00	SPY	ETF	131.81	131.81	131.78	131.8	11100.0
2012-01-27 19:00:00	SPY	ETF	131.8	131.85	131.75	131.85	30981.0
2012-01-27 19:30:00	SPY	ETF	131.84	131.84	131.82	131.84	8615.0
2012-01-27 05:00:00	QQQ	ETF	60.35	60.35	60.35	60.35	100.0
2012-01-27 05:30:00	QQQ	ETF	60.43	60.45	60.4	60.45	1600.0
2012-01-27 06:00:00	QQQ	ETF	60.45	60.45	60.44	60.44	1300.0
2012-01-27 06:30:00	QQQ	ETF	60.36	60.36	60.36	60.36	13300.0
2012-01-27 07:00:00	QQQ	ETF	60.36	60.39	60.34	60.39	33110.0
2012-01-27 07:30:00	QQQ	ETF	60.38	60.46	60.35	60.43	48361.0
2012-01-27 08:00:00	QQQ	ETF	60.41	60.42	60.35	60.42	216151.0
2012-01-27 08:30:00	QQQ	ETF	60.34	60.34	60.02	60.04	582710.0
2012-01-27 09:00:00	QQQ	ETF	60.06	60.15	60.04	60.08	214145.0
2012-01-27 09:30:00	QQQ	ETF	60.09	60.38	60.06	60.33	6541490.0
2012-01-27 10:00:00	QQQ	ETF	60.34	60.36	60.12	60.31	4613569.0
2012-01-27 10:30:00	QQQ	ETF	60.32	60.38	60.16	60.25	2971019.0
2012-01-27 11:00:00	QQQ	ETF	60.26	60.3605	60.23	60.3217	2397945.0
2012-01-27 11:30:00	QQQ	ETF	60.32	60.32	60.16	60.23	1886850.0
2012-01-27 12:00:00	QQQ	ETF	60.24	60.31	60.14	60.233	2153108.0
2012-01-27 12:30:00	QQQ	ETF	60.2325	60.28	60.14	60.1701	1217436.0
2012-01-27 13:00:00	QQQ	ETF	60.18	60.29	60.149	60.2652	1323116.0
2012-01-27 13:30:00	QQQ	ETF	60.27	60.35	60.25	60.319	1683730.0

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

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