PREVIEW / etf_30min / 2014-02-07

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-02-07.parquet
  size:    352 KB
  rows:    11,632

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-02-07 04:00:00	SPY	ETF	177.47	177.72	177.46	177.6	44300.0
2014-02-07 04:30:00	SPY	ETF	177.64	177.78	177.64	177.76	17272.0
2014-02-07 05:00:00	SPY	ETF	177.74	177.76	177.7	177.76	1500.0
2014-02-07 05:30:00	SPY	ETF	177.69	177.7	177.63	177.69	54570.0
2014-02-07 06:00:00	SPY	ETF	177.66	177.69	177.61	177.64	13566.0
2014-02-07 06:30:00	SPY	ETF	177.71	177.76	177.54	177.76	87954.0
2014-02-07 07:00:00	SPY	ETF	177.65	177.86	177.65	177.86	118225.0
2014-02-07 07:30:00	SPY	ETF	177.86	177.91	177.76	177.89	158467.0
2014-02-07 08:00:00	SPY	ETF	177.89	178.03	177.72	177.86	1077122.0
2014-02-07 08:30:00	SPY	ETF	177.92	178.62	176.35	178.43	13560867.0
2014-02-07 09:00:00	SPY	ETF	178.43	178.45	178.04	178.31	2808284.0
2014-02-07 09:30:00	SPY	ETF	178.31	178.87	178.06	178.48	23663424.0
2014-02-07 10:00:00	SPY	ETF	178.48	178.7	177.73	177.826	17542645.0
2014-02-07 10:30:00	SPY	ETF	177.84	178.38	177.79	178.291	9589221.0
2014-02-07 11:00:00	SPY	ETF	178.2999	178.47	178.15	178.43	6091739.0
2014-02-07 11:30:00	SPY	ETF	178.439	178.93	178.43	178.93	8735821.0
2014-02-07 12:00:00	SPY	ETF	178.93	178.939	178.7	178.84	5080948.0
2014-02-07 12:30:00	SPY	ETF	178.84	178.925	178.68	178.88	3279335.0
2014-02-07 13:00:00	SPY	ETF	178.87	179.07	178.86	179.0	4866993.0
2014-02-07 13:30:00	SPY	ETF	179.01	179.44	178.98	179.37	9907016.0
2014-02-07 14:00:00	SPY	ETF	179.37	179.48	179.2801	179.39	6876125.0
2014-02-07 14:30:00	SPY	ETF	179.39	179.52	179.27	179.41	6181364.0
2014-02-07 15:00:00	SPY	ETF	179.42	179.62	179.42	179.56	8274006.0
2014-02-07 15:30:00	SPY	ETF	179.55	179.87	179.53	179.69	22727443.0
2014-02-07 16:00:00	SPY	ETF	179.69	179.88	177.3921	179.84	9466675.0
2014-02-07 16:30:00	SPY	ETF	179.84	179.86	177.3921	179.7499	7248228.0
2014-02-07 17:00:00	SPY	ETF	179.81	179.86	179.77	179.84	1676527.0
2014-02-07 17:30:00	SPY	ETF	179.83	179.88	179.81	179.85	18606.0
2014-02-07 18:00:00	SPY	ETF	179.85	179.89	179.8	179.88	18766.0
2014-02-07 18:30:00	SPY	ETF	179.85	179.85	179.75	179.8	27693.0
2014-02-07 19:00:00	SPY	ETF	179.8	179.85	179.8	179.85	10873.0
2014-02-07 19:30:00	SPY	ETF	179.84	179.89	179.81	179.89	24590.0
2014-02-07 04:00:00	QQQ	ETF	85.91	85.97	85.91	85.97	433.0
2014-02-07 04:30:00	QQQ	ETF	86.02	86.02	86.02	86.02	200.0
2014-02-07 05:30:00	QQQ	ETF	86.0	86.0	85.99	85.99	200.0
2014-02-07 06:00:00	QQQ	ETF	86.01	86.04	86.01	86.03	1200.0
2014-02-07 06:30:00	QQQ	ETF	86.05	86.06	85.95	86.02	2600.0
2014-02-07 07:00:00	QQQ	ETF	86.05	86.05	86.01	86.01	2210.0
2014-02-07 07:30:00	QQQ	ETF	86.06	86.06	86.02	86.05	23200.0
2014-02-07 08:00:00	QQQ	ETF	86.08	86.13	86.0	86.02	80316.0
2014-02-07 08:30:00	QQQ	ETF	85.97	86.31	85.4	86.25	665834.0
2014-02-07 09:00:00	QQQ	ETF	86.24	86.32	86.12	86.27	492578.0
2014-02-07 09:30:00	QQQ	ETF	86.27	86.56	86.19	86.36	5924836.0
2014-02-07 10:00:00	QQQ	ETF	86.37	86.47	86.0	86.07	3589993.0
2014-02-07 10:30:00	QQQ	ETF	86.07	86.409	86.05	86.391	2330748.0
2014-02-07 11:00:00	QQQ	ETF	86.4	86.549	86.335	86.53	1560574.0
2014-02-07 11:30:00	QQQ	ETF	86.539	86.83	86.53	86.82	1988221.0
2014-02-07 12:00:00	QQQ	ETF	86.83	86.8799	86.77	86.86	1353875.0
2014-02-07 12:30:00	QQQ	ETF	86.86	86.89	86.79	86.86	1205879.0
2014-02-07 13:00:00	QQQ	ETF	86.86	87.0	86.86	86.9501	1484522.0

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

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