PREVIEW / etf_30min / 2014-06-25

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-06-25.parquet
  size:    334 KB
  rows:    11,422

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-06-25 04:00:00	SPY	ETF	194.8	194.83	194.65	194.81	4240.0
2014-06-25 04:30:00	SPY	ETF	194.9	194.91	194.9	194.91	716.0
2014-06-25 05:00:00	SPY	ETF	194.89	195.04	194.89	195.0	1643.0
2014-06-25 05:30:00	SPY	ETF	194.95	194.99	194.86	194.86	4462.0
2014-06-25 06:00:00	SPY	ETF	194.85	194.91	194.83	194.91	13425.0
2014-06-25 06:30:00	SPY	ETF	194.94	195.04	194.94	195.04	31393.0
2014-06-25 07:00:00	SPY	ETF	195.01	195.06	194.9	194.97	30200.0
2014-06-25 07:30:00	SPY	ETF	194.94	194.94	194.82	194.85	158185.0
2014-06-25 08:00:00	SPY	ETF	194.85	194.9	194.78	194.83	90194.0
2014-06-25 08:30:00	SPY	ETF	194.76	194.85	194.25	194.52	1965494.0
2014-06-25 09:00:00	SPY	ETF	194.52	194.53	194.24	194.25	883546.0
2014-06-25 09:30:00	SPY	ETF	194.25	195.1	194.25	194.91	11749336.0
2014-06-25 10:00:00	SPY	ETF	194.92	195.09	194.67	194.85	8127264.0
2014-06-25 10:30:00	SPY	ETF	194.85	195.35	194.72	195.32	6064964.0
2014-06-25 11:00:00	SPY	ETF	195.31	195.38	195.1	195.225	6401369.0
2014-06-25 11:30:00	SPY	ETF	195.23	195.27	194.96	195.1	5995769.0
2014-06-25 12:00:00	SPY	ETF	195.1001	195.21	195.04	195.15	4064304.0
2014-06-25 12:30:00	SPY	ETF	195.1559	195.2	195.08	195.115	2202805.0
2014-06-25 13:00:00	SPY	ETF	195.11	195.38	195.11	195.225	2738919.0
2014-06-25 13:30:00	SPY	ETF	195.23	195.51	195.2	195.46	2468206.0
2014-06-25 14:00:00	SPY	ETF	195.47	195.58	195.35	195.53	3576182.0
2014-06-25 14:30:00	SPY	ETF	195.53	195.58	195.36	195.39	4575246.0
2014-06-25 15:00:00	SPY	ETF	195.38	195.5778	195.32	195.52	4241224.0
2014-06-25 15:30:00	SPY	ETF	195.53	195.781	195.5	195.56	10803457.0
2014-06-25 16:00:00	SPY	ETF	195.56	195.6	194.6727	195.42	4744606.0
2014-06-25 16:30:00	SPY	ETF	195.43	195.43	195.35	195.39	78406.0
2014-06-25 17:00:00	SPY	ETF	195.38	195.39	195.36	195.36	91386.0
2014-06-25 17:30:00	SPY	ETF	195.36	195.58	195.32	195.35	432395.0
2014-06-25 18:00:00	SPY	ETF	195.34	195.38	195.31	195.35	32432.0
2014-06-25 18:30:00	SPY	ETF	195.38	195.45	195.38	195.43	17116.0
2014-06-25 19:00:00	SPY	ETF	195.43	195.43	195.42	195.42	8502.0
2014-06-25 19:30:00	SPY	ETF	195.42	195.44	195.4	195.42	27690.0
2014-06-25 08:00:00	QQQ	ETF	92.71	92.74	92.66	92.66	10589.0
2014-06-25 08:30:00	QQQ	ETF	92.66	92.66	92.47	92.6	343910.0
2014-06-25 09:00:00	QQQ	ETF	92.61	92.63	92.48	92.48	239000.0
2014-06-25 09:30:00	QQQ	ETF	92.48	92.92	92.48	92.73	4377178.0
2014-06-25 10:00:00	QQQ	ETF	92.74	92.92	92.615	92.701	2968494.0
2014-06-25 10:30:00	QQQ	ETF	92.71	92.94	92.6	92.92	1910553.0
2014-06-25 11:00:00	QQQ	ETF	92.92	93.08	92.87	93.03	1943369.0
2014-06-25 11:30:00	QQQ	ETF	93.025	93.05	92.84	92.92	1479307.0
2014-06-25 12:00:00	QQQ	ETF	92.915	92.99	92.89	92.99	858714.0
2014-06-25 12:30:00	QQQ	ETF	92.98	93.01	92.94	92.98	577440.0
2014-06-25 13:00:00	QQQ	ETF	92.98	93.13	92.975	93.04	1086444.0
2014-06-25 13:30:00	QQQ	ETF	93.05	93.25	93.03	93.22	1212404.0
2014-06-25 14:00:00	QQQ	ETF	93.22	93.28	93.15	93.23	936762.0
2014-06-25 14:30:00	QQQ	ETF	93.23	93.29	93.18	93.21	1313340.0
2014-06-25 15:00:00	QQQ	ETF	93.21	93.35	93.18	93.33	1674785.0
2014-06-25 15:30:00	QQQ	ETF	93.33	93.45	92.79	92.79	2934706.0
2014-06-25 16:00:00	QQQ	ETF	93.29	93.3696	92.8966	93.25	2094744.0
2014-06-25 16:30:00	QQQ	ETF	93.25	93.3298	93.2	93.23	536912.0

> showing 50 of 11,422 rows — these rows as CSV

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