PREVIEW / etf_30min / 2012-08-06

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-08-06.parquet
  size:    272 KB
  rows:    9,429

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-08-06 04:00:00	SPY	ETF	139.42	139.42	139.38	139.38	1240.0
2012-08-06 04:30:00	SPY	ETF	139.63	139.65	139.63	139.65	300.0
2012-08-06 05:00:00	SPY	ETF	139.75	139.77	139.75	139.75	2100.0
2012-08-06 06:00:00	SPY	ETF	139.8	139.8	139.7	139.7	5700.0
2012-08-06 06:30:00	SPY	ETF	139.75	139.75	139.75	139.75	500.0
2012-08-06 07:00:00	SPY	ETF	139.75	139.83	139.73	139.8	24075.0
2012-08-06 07:30:00	SPY	ETF	139.8	139.89	139.8	139.87	152235.0
2012-08-06 08:00:00	SPY	ETF	139.87	139.89	139.75	139.78	567931.0
2012-08-06 08:30:00	SPY	ETF	139.78	139.82	139.72	139.78	375491.0
2012-08-06 09:00:00	SPY	ETF	139.77	139.81	139.71	139.72	620843.0
2012-08-06 09:30:00	SPY	ETF	139.72	140.13	139.58	139.97	13283476.0
2012-08-06 10:00:00	SPY	ETF	139.98	140.13	139.89	140.05	8264496.0
2012-08-06 10:30:00	SPY	ETF	140.05	140.17	139.98	139.991	6662333.0
2012-08-06 11:00:00	SPY	ETF	140.002	140.1	139.87	139.8764	5095457.0
2012-08-06 11:30:00	SPY	ETF	139.88	140.04	139.83	139.99	3917388.0
2012-08-06 12:00:00	SPY	ETF	139.99	140.0	139.87	139.945	2457154.0
2012-08-06 12:30:00	SPY	ETF	139.94	140.15	139.934	140.11	3543402.0
2012-08-06 13:00:00	SPY	ETF	140.12	140.17	140.07	140.12	2369628.0
2012-08-06 13:30:00	SPY	ETF	140.12	140.15	139.94	139.999	3779558.0
2012-08-06 14:00:00	SPY	ETF	139.99	140.07	139.97	140.06	2487869.0
2012-08-06 14:30:00	SPY	ETF	140.06	140.13	140.01	140.06	2598793.0
2012-08-06 15:00:00	SPY	ETF	140.06	140.12	139.98	140.05	4536881.0
2012-08-06 15:30:00	SPY	ETF	140.04	140.1667	139.56	139.63	14708846.0
2012-08-06 16:00:00	SPY	ETF	139.64	140.0	139.57	139.61	4191579.0
2012-08-06 16:30:00	SPY	ETF	139.61	139.9618	139.47	139.48	244924.0
2012-08-06 17:00:00	SPY	ETF	139.5	139.53	139.48	139.48	57636.0
2012-08-06 17:30:00	SPY	ETF	139.5	139.56	139.4	139.5	98181.0
2012-08-06 18:00:00	SPY	ETF	139.5	139.56	139.5	139.55	45480.0
2012-08-06 18:30:00	SPY	ETF	139.55	139.56	139.54	139.56	11350.0
2012-08-06 19:00:00	SPY	ETF	139.56	139.57	139.54	139.57	10260.0
2012-08-06 19:30:00	SPY	ETF	139.56	139.57	139.49	139.49	14640.0
2012-08-06 20:00:00	SPY	ETF	139.49	139.49	139.49	139.49	1000.0
2012-08-06 05:30:00	QQQ	ETF	65.9	65.9	65.9	65.9	100.0
2012-08-06 06:00:00	QQQ	ETF	65.94	65.94	65.94	65.94	100.0
2012-08-06 06:30:00	QQQ	ETF	65.92	65.92	65.92	65.92	500.0
2012-08-06 07:00:00	QQQ	ETF	65.94	65.95	65.9	65.94	23925.0
2012-08-06 07:30:00	QQQ	ETF	65.95	65.96	65.94	65.96	10639.0
2012-08-06 08:00:00	QQQ	ETF	65.94	65.95	65.88	65.88	120805.0
2012-08-06 08:30:00	QQQ	ETF	65.89	65.93	65.87	65.92	51680.0
2012-08-06 09:00:00	QQQ	ETF	65.91	65.96	65.89	65.94	105263.0
2012-08-06 09:30:00	QQQ	ETF	65.94	66.12	65.8	66.0	3730083.0
2012-08-06 10:00:00	QQQ	ETF	66.008	66.18	66.0	66.102	3131930.0
2012-08-06 10:30:00	QQQ	ETF	66.11	66.17	66.08	66.12	1311035.0
2012-08-06 11:00:00	QQQ	ETF	66.12	66.23	66.07	66.16	1505283.0
2012-08-06 11:30:00	QQQ	ETF	66.15	66.27	66.13	66.26	981545.0
2012-08-06 12:00:00	QQQ	ETF	66.26	66.28	66.2	66.2305	758405.0
2012-08-06 12:30:00	QQQ	ETF	66.24	66.39	66.23	66.37	1951398.0
2012-08-06 13:00:00	QQQ	ETF	66.365	66.39	66.32	66.34	1207688.0
2012-08-06 13:30:00	QQQ	ETF	66.34	66.35	66.24	66.29	1296012.0
2012-08-06 14:00:00	QQQ	ETF	66.28	66.35	66.26	66.332	803773.0

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

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