PREVIEW / etf_30min / 2014-07-08

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-07-08.parquet
  size:    351 KB
  rows:    12,180

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-07-08 04:30:00	SPY	ETF	197.35	197.35	197.28	197.31	733.0
2014-07-08 05:30:00	SPY	ETF	197.36	197.36	197.24	197.25	2000.0
2014-07-08 06:00:00	SPY	ETF	197.21	197.24	197.2	197.22	9800.0
2014-07-08 06:30:00	SPY	ETF	197.25	197.32	197.25	197.3	11458.0
2014-07-08 07:00:00	SPY	ETF	197.37	197.4	197.25	197.36	40737.0
2014-07-08 07:30:00	SPY	ETF	197.33	197.5	197.25	197.3	54834.0
2014-07-08 08:00:00	SPY	ETF	197.36	197.36	197.28	197.28	110295.0
2014-07-08 08:30:00	SPY	ETF	197.27	197.29	197.16	197.22	108139.0
2014-07-08 09:00:00	SPY	ETF	197.22	197.22	197.07	197.15	366058.0
2014-07-08 09:30:00	SPY	ETF	197.15	197.22	196.47	196.72	12572708.0
2014-07-08 10:00:00	SPY	ETF	196.73	196.73	196.26	196.37	9888920.0
2014-07-08 10:30:00	SPY	ETF	196.37	196.47	196.07	196.38	10763024.0
2014-07-08 11:00:00	SPY	ETF	196.38	196.395	195.88	195.89	6209199.0
2014-07-08 11:30:00	SPY	ETF	195.89	196.24	195.84	196.04	6094195.0
2014-07-08 12:00:00	SPY	ETF	196.04	196.1	195.76	195.99	5768242.0
2014-07-08 12:30:00	SPY	ETF	196.0	196.2	195.86	196.16	4606574.0
2014-07-08 13:00:00	SPY	ETF	196.15	196.42	196.02	196.37	3987694.0
2014-07-08 13:30:00	SPY	ETF	196.37	196.61	196.34	196.5	4730662.0
2014-07-08 14:00:00	SPY	ETF	196.5	196.52	196.34	196.4	4909762.0
2014-07-08 14:30:00	SPY	ETF	196.41	196.48	196.26	196.28	2917258.0
2014-07-08 15:00:00	SPY	ETF	196.28	196.35	196.08	196.221	5611665.0
2014-07-08 15:30:00	SPY	ETF	196.225	196.33	196.16	196.27	11149090.0
2014-07-08 16:00:00	SPY	ETF	196.27	196.54	196.1105	196.5	6528681.0
2014-07-08 16:30:00	SPY	ETF	196.5	196.56	196.44	196.49	1336280.0
2014-07-08 17:00:00	SPY	ETF	196.5	196.51	196.2026	196.48	367942.0
2014-07-08 17:30:00	SPY	ETF	196.49	196.51	196.47	196.51	6160.0
2014-07-08 18:00:00	SPY	ETF	196.5	196.52	196.49	196.51	10550.0
2014-07-08 18:30:00	SPY	ETF	196.52	196.56	196.49	196.49	53523.0
2014-07-08 19:00:00	SPY	ETF	196.5	196.56	196.5	196.54	10153.0
2014-07-08 19:30:00	SPY	ETF	196.54	196.54	196.49	196.51	12900.0
2014-07-08 04:30:00	QQQ	ETF	95.3	95.34	95.3	95.34	2200.0
2014-07-08 06:00:00	QQQ	ETF	95.3	95.3	95.3	95.3	200.0
2014-07-08 08:00:00	QQQ	ETF	95.37	95.37	95.33	95.33	6599.0
2014-07-08 08:30:00	QQQ	ETF	95.31	95.32	95.27	95.3	40240.0
2014-07-08 09:00:00	QQQ	ETF	95.28	95.29	95.22	95.25	264558.0
2014-07-08 09:30:00	QQQ	ETF	95.25	95.3	94.7	94.799	4596073.0
2014-07-08 10:00:00	QQQ	ETF	94.795	94.8	94.34	94.39	3737436.0
2014-07-08 10:30:00	QQQ	ETF	94.38	94.41	94.201	94.4	4439595.0
2014-07-08 11:00:00	QQQ	ETF	94.4	94.4	94.08	94.09	2425538.0
2014-07-08 11:30:00	QQQ	ETF	94.0899	94.21	93.87	94.03	3044128.0
2014-07-08 12:00:00	QQQ	ETF	94.02	94.11	93.9	94.08	2629597.0
2014-07-08 12:30:00	QQQ	ETF	94.09	94.23	94.01	94.2	1863430.0
2014-07-08 13:00:00	QQQ	ETF	94.2	94.36	94.08	94.33	1496658.0
2014-07-08 13:30:00	QQQ	ETF	94.33	94.47	94.26	94.418	1930025.0
2014-07-08 14:00:00	QQQ	ETF	94.4	94.41	94.285	94.31	1368842.0
2014-07-08 14:30:00	QQQ	ETF	94.31	94.39	94.22	94.23	966258.0
2014-07-08 15:00:00	QQQ	ETF	94.24	94.33	94.11	94.25	1197266.0
2014-07-08 15:30:00	QQQ	ETF	94.24	94.36	94.2	94.28	4155897.0
2014-07-08 16:00:00	QQQ	ETF	94.28	94.6621	94.26	94.4	1223183.0
2014-07-08 16:30:00	QQQ	ETF	94.2583	94.43	94.2583	94.39	508146.0

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

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