PREVIEW / etf_30min / 2014-09-08

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-09-08.parquet
  size:    342 KB
  rows:    11,500

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-09-08 04:00:00	SPY	ETF	201.0	201.0	200.9	200.91	1150.0
2014-09-08 04:30:00	SPY	ETF	200.91	200.94	200.81	200.86	39365.0
2014-09-08 05:00:00	SPY	ETF	200.94	200.94	200.85	200.85	867.0
2014-09-08 05:30:00	SPY	ETF	200.89	200.9	200.8	200.86	46203.0
2014-09-08 06:00:00	SPY	ETF	200.83	200.91	200.83	200.83	87431.0
2014-09-08 06:30:00	SPY	ETF	200.85	200.92	200.8	200.86	9090.0
2014-09-08 07:00:00	SPY	ETF	200.85	200.9	200.77	200.9	76323.0
2014-09-08 07:30:00	SPY	ETF	200.93	200.94	200.83	200.9	49512.0
2014-09-08 08:00:00	SPY	ETF	200.93	200.99	200.84	200.86	226940.0
2014-09-08 08:30:00	SPY	ETF	200.85	200.96	200.77	200.8	250667.0
2014-09-08 09:00:00	SPY	ETF	200.81	200.97	200.81	200.91	238410.0
2014-09-08 09:30:00	SPY	ETF	200.92	201.18	200.86	201.04	6094099.0
2014-09-08 10:00:00	SPY	ETF	201.04	201.21	200.65	200.75	4697191.0
2014-09-08 10:30:00	SPY	ETF	200.75	200.9	200.53	200.87	4639397.0
2014-09-08 11:00:00	SPY	ETF	200.88	201.05	200.77	200.95	2964252.0
2014-09-08 11:30:00	SPY	ETF	200.96	201.02	200.63	200.685	3417826.0
2014-09-08 12:00:00	SPY	ETF	200.68	200.75	200.5899	200.73	2147719.0
2014-09-08 12:30:00	SPY	ETF	200.73	200.84	200.7	200.75	2222820.0
2014-09-08 13:00:00	SPY	ETF	200.745	200.81	200.21	200.22	4974803.0
2014-09-08 13:30:00	SPY	ETF	200.22	200.3	200.0	200.15	8328029.0
2014-09-08 14:00:00	SPY	ETF	200.14	200.37	200.11	200.29	3612419.0
2014-09-08 14:30:00	SPY	ETF	200.29	200.43	200.24	200.36	2211983.0
2014-09-08 15:00:00	SPY	ETF	200.355	201.01	200.355	200.6	3455973.0
2014-09-08 15:30:00	SPY	ETF	200.61	200.77	200.55	200.6	8963485.0
2014-09-08 16:00:00	SPY	ETF	200.61	200.6976	200.57	200.65	3544044.0
2014-09-08 16:30:00	SPY	ETF	200.64	200.72	200.64	200.71	85418.0
2014-09-08 17:00:00	SPY	ETF	200.71	200.73	200.62	200.62	30511.0
2014-09-08 17:30:00	SPY	ETF	200.68	200.68	200.62	200.62	2450.0
2014-09-08 18:00:00	SPY	ETF	200.62	200.67	200.6	200.6	9852.0
2014-09-08 18:30:00	SPY	ETF	200.59	200.59	200.55	200.57	7048.0
2014-09-08 19:00:00	SPY	ETF	200.59	200.62	200.57	200.58	2085.0
2014-09-08 19:30:00	SPY	ETF	200.59	200.62	200.55	200.6	21731.0
2014-09-08 04:00:00	QQQ	ETF	99.75	99.75	99.68	99.74	4493.0
2014-09-08 04:30:00	QQQ	ETF	99.78	99.78	99.6	99.6	23100.0
2014-09-08 06:00:00	QQQ	ETF	99.76	99.81	99.74	99.74	72900.0
2014-09-08 06:30:00	QQQ	ETF	99.76	99.79	99.75	99.77	7600.0
2014-09-08 07:00:00	QQQ	ETF	99.76	99.81	99.74	99.81	9600.0
2014-09-08 07:30:00	QQQ	ETF	99.82	99.83	99.8	99.8	8130.0
2014-09-08 08:00:00	QQQ	ETF	99.84	99.86	99.81	99.81	39192.0
2014-09-08 08:30:00	QQQ	ETF	99.79	99.84	99.77	99.77	76369.0
2014-09-08 09:00:00	QQQ	ETF	99.78	99.9	99.78	99.88	304085.0
2014-09-08 09:30:00	QQQ	ETF	99.89	100.3	99.89	100.26	3328154.0
2014-09-08 10:00:00	QQQ	ETF	100.26	100.33	100.099	100.18	2180349.0
2014-09-08 10:30:00	QQQ	ETF	100.18	100.27	100.02	100.25	1675870.0
2014-09-08 11:00:00	QQQ	ETF	100.25	100.28	100.18	100.23	1258529.0
2014-09-08 11:30:00	QQQ	ETF	100.24	100.26	99.97	99.979	872419.0
2014-09-08 12:00:00	QQQ	ETF	99.97	100.04	99.94	100.04	695146.0
2014-09-08 12:30:00	QQQ	ETF	100.04	100.13	100.0367	100.068	465719.0
2014-09-08 13:00:00	QQQ	ETF	100.06	100.12	99.81	99.82	1367081.0
2014-09-08 13:30:00	QQQ	ETF	99.82	99.85	99.62	99.7368	1769633.0

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

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