PREVIEW / etf_30min / 2013-06-27

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-06-27.parquet
  size:    322 KB
  rows:    11,016

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
2013-06-27 04:00:00	SPY	ETF	160.11	160.27	160.11	160.15	40533.0
2013-06-27 04:30:00	SPY	ETF	160.1	160.2	160.05	160.15	2300.0
2013-06-27 05:00:00	SPY	ETF	160.1	160.2	160.05	160.2	3400.0
2013-06-27 05:30:00	SPY	ETF	160.2	160.34	160.2	160.34	1800.0
2013-06-27 06:00:00	SPY	ETF	160.32	160.37	160.29	160.32	5950.0
2013-06-27 06:30:00	SPY	ETF	160.31	160.37	160.21	160.25	83800.0
2013-06-27 07:00:00	SPY	ETF	160.22	160.36	160.17	160.34	44638.0
2013-06-27 07:30:00	SPY	ETF	160.32	160.84	160.32	160.69	657739.0
2013-06-27 08:00:00	SPY	ETF	160.24	160.8	160.21	160.69	551988.0
2013-06-27 08:30:00	SPY	ETF	160.69	161.03	160.69	160.94	979674.0
2013-06-27 09:00:00	SPY	ETF	160.93	161.14	160.91	161.1	1133898.0
2013-06-27 09:30:00	SPY	ETF	161.1	161.53	161.05	161.47	18234715.0
2013-06-27 10:00:00	SPY	ETF	161.465	161.6	161.135	161.56	13411784.0
2013-06-27 10:30:00	SPY	ETF	161.56	161.82	161.46	161.55	13956334.0
2013-06-27 11:00:00	SPY	ETF	161.56	161.8	161.23	161.28	9734320.0
2013-06-27 11:30:00	SPY	ETF	161.29	161.52	161.25	161.49	4941336.0
2013-06-27 12:00:00	SPY	ETF	161.49	161.53	160.95	161.0799	9338865.0
2013-06-27 12:30:00	SPY	ETF	161.08	161.36	161.06	161.26	3812826.0
2013-06-27 13:00:00	SPY	ETF	161.26	161.54	161.19	161.441	5512436.0
2013-06-27 13:30:00	SPY	ETF	161.441	161.66	161.24	161.27	5478199.0
2013-06-27 14:00:00	SPY	ETF	161.27	161.34	161.1	161.33	8013674.0
2013-06-27 14:30:00	SPY	ETF	161.32	161.47	161.1	161.23	5177957.0
2013-06-27 15:00:00	SPY	ETF	161.23	161.4	161.06	161.39	7487886.0
2013-06-27 15:30:00	SPY	ETF	161.38	161.42	161.09	161.13	15026453.0
2013-06-27 16:00:00	SPY	ETF	161.11	161.4	161.03	161.07	4138103.0
2013-06-27 16:30:00	SPY	ETF	161.07	161.4	161.02	161.08	282621.0
2013-06-27 17:00:00	SPY	ETF	161.05	161.12	161.02	161.05	68883.0
2013-06-27 17:30:00	SPY	ETF	161.06	161.08	161.03	161.05	8553.0
2013-06-27 18:00:00	SPY	ETF	161.04	161.19	161.0	161.14	57741.0
2013-06-27 18:30:00	SPY	ETF	161.16	161.19	161.11	161.11	25200.0
2013-06-27 19:00:00	SPY	ETF	161.11	161.13	161.06	161.13	25120.0
2013-06-27 19:30:00	SPY	ETF	161.1	161.15	161.01	161.02	17031.0
2013-06-27 04:00:00	QQQ	ETF	70.84	70.9	70.83	70.86	3200.0
2013-06-27 04:30:00	QQQ	ETF	70.84	70.92	70.84	70.88	3600.0
2013-06-27 05:00:00	QQQ	ETF	70.86	70.9	70.8	70.9	4400.0
2013-06-27 05:30:00	QQQ	ETF	70.88	70.92	70.86	70.92	3600.0
2013-06-27 06:00:00	QQQ	ETF	70.9	70.94	70.9	70.92	3300.0
2013-06-27 06:30:00	QQQ	ETF	70.93	70.93	70.88	70.88	1200.0
2013-06-27 07:00:00	QQQ	ETF	70.86	70.93	70.86	70.93	5800.0
2013-06-27 07:30:00	QQQ	ETF	70.93	71.12	70.93	71.08	18500.0
2013-06-27 08:00:00	QQQ	ETF	71.09	71.13	71.06	71.11	14663.0
2013-06-27 08:30:00	QQQ	ETF	71.1	71.21	71.1	71.14	25784.0
2013-06-27 09:00:00	QQQ	ETF	71.16	71.23	71.16	71.22	44237.0
2013-06-27 09:30:00	QQQ	ETF	71.22	71.47	71.21	71.46	3889205.0
2013-06-27 10:00:00	QQQ	ETF	71.45	71.55	71.27	71.53	3562407.0
2013-06-27 10:30:00	QQQ	ETF	71.525	71.62	71.4399	71.491	2228686.0
2013-06-27 11:00:00	QQQ	ETF	71.495	71.58	71.3	71.34	1735101.0
2013-06-27 11:30:00	QQQ	ETF	71.35	71.42	71.321	71.42	675043.0
2013-06-27 12:00:00	QQQ	ETF	71.42	71.43	71.26	71.3199	1855076.0
2013-06-27 12:30:00	QQQ	ETF	71.32	71.42	71.3	71.32	809969.0

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

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