PREVIEW / etf_30min / 2014-12-08

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-12-08.parquet
  size:    378 KB
  rows:    12,581

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
2014-12-08 04:00:00	SPY	ETF	207.81	207.81	207.45	207.45	2561.0
2014-12-08 04:30:00	SPY	ETF	207.58	207.58	207.51	207.54	11196.0
2014-12-08 05:00:00	SPY	ETF	207.51	207.51	207.36	207.36	8390.0
2014-12-08 05:30:00	SPY	ETF	207.38	207.6	207.38	207.5	31674.0
2014-12-08 06:00:00	SPY	ETF	207.55	207.6	207.48	207.48	106803.0
2014-12-08 06:30:00	SPY	ETF	207.53	207.63	207.48	207.49	16800.0
2014-12-08 07:00:00	SPY	ETF	207.5	207.53	207.41	207.48	41840.0
2014-12-08 07:30:00	SPY	ETF	207.48	207.58	207.46	207.56	17459.0
2014-12-08 08:00:00	SPY	ETF	207.56	208.07	207.42	207.47	257754.0
2014-12-08 08:30:00	SPY	ETF	207.47	207.54	207.42	207.48	181808.0
2014-12-08 09:00:00	SPY	ETF	207.49	207.62	207.44	207.53	331882.0
2014-12-08 09:30:00	SPY	ETF	207.52	207.95	207.33	207.89	8702517.0
2014-12-08 10:00:00	SPY	ETF	207.89	208.12	207.765	208.1	5254072.0
2014-12-08 10:30:00	SPY	ETF	208.1	208.11	207.94	207.965	3994860.0
2014-12-08 11:00:00	SPY	ETF	207.965	208.04	207.83	207.85	3979887.0
2014-12-08 11:30:00	SPY	ETF	207.86	207.93	207.79	207.865	2764667.0
2014-12-08 12:00:00	SPY	ETF	207.8602	207.9499	207.02	207.11	9414067.0
2014-12-08 12:30:00	SPY	ETF	207.11	207.62	206.97	207.1	5694508.0
2014-12-08 13:00:00	SPY	ETF	207.1	207.305	206.7	206.78	4738160.0
2014-12-08 13:30:00	SPY	ETF	206.79	207.6	206.15	206.23	8870570.0
2014-12-08 14:00:00	SPY	ETF	206.23	207.49	205.93	206.42	7822092.0
2014-12-08 14:30:00	SPY	ETF	206.411	207.48	206.37	206.63	6505557.0
2014-12-08 15:00:00	SPY	ETF	206.63	206.79	206.33	206.65	5863054.0
2014-12-08 15:30:00	SPY	ETF	206.66	207.52	206.34	206.62	12432846.0
2014-12-08 16:00:00	SPY	ETF	206.62	207.1868	206.48	206.53	5653144.0
2014-12-08 16:30:00	SPY	ETF	206.54	208.0574	206.54	206.6	2761889.0
2014-12-08 17:00:00	SPY	ETF	206.58	206.63	206.56	206.56	103629.0
2014-12-08 17:30:00	SPY	ETF	206.6	206.61	206.57	206.57	14356.0
2014-12-08 18:00:00	SPY	ETF	206.57	206.72	206.57	206.66	65522.0
2014-12-08 18:30:00	SPY	ETF	206.69	206.69	206.67	206.67	8050.0
2014-12-08 19:00:00	SPY	ETF	206.69	206.74	206.62	206.66	22652.0
2014-12-08 19:30:00	SPY	ETF	206.66	206.69	206.65	206.67	22475.0
2014-12-08 04:00:00	QQQ	ETF	105.11	105.11	105.11	105.11	100.0
2014-12-08 04:30:00	QQQ	ETF	105.08	105.08	105.01	105.01	200.0
2014-12-08 05:00:00	QQQ	ETF	105.0	105.0	105.0	105.0	100.0
2014-12-08 05:30:00	QQQ	ETF	104.99	105.03	104.99	105.03	7000.0
2014-12-08 06:00:00	QQQ	ETF	105.07	105.1	105.07	105.08	6500.0
2014-12-08 06:30:00	QQQ	ETF	105.1	105.1	105.08	105.08	2750.0
2014-12-08 07:00:00	QQQ	ETF	105.06	105.06	105.06	105.06	700.0
2014-12-08 07:30:00	QQQ	ETF	105.08	105.09	105.08	105.09	13300.0
2014-12-08 08:00:00	QQQ	ETF	105.07	105.12	105.0	105.07	30454.0
2014-12-08 08:30:00	QQQ	ETF	105.06	105.1	105.01	105.05	52816.0
2014-12-08 09:00:00	QQQ	ETF	105.03	105.15	105.02	105.11	142464.0
2014-12-08 09:30:00	QQQ	ETF	105.11	105.57	104.97	105.5	4940040.0
2014-12-08 10:00:00	QQQ	ETF	105.51	105.55	105.28	105.4799	2009708.0
2014-12-08 10:30:00	QQQ	ETF	105.48	105.57	105.45	105.47	1471849.0
2014-12-08 11:00:00	QQQ	ETF	105.47	105.48	105.31	105.34	1544296.0
2014-12-08 11:30:00	QQQ	ETF	105.34	105.43	105.3	105.37	923455.0
2014-12-08 12:00:00	QQQ	ETF	105.36	105.39	104.62	104.67	2885382.0
2014-12-08 12:30:00	QQQ	ETF	104.66	104.86	104.575	104.66	1781107.0

> showing 50 of 12,581 rows — these rows as CSV

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