PREVIEW / etf_30min / 2014-09-02

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-09-02.parquet
  size:    353 KB
  rows:    12,020

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-02 04:00:00	SPY	ETF	200.91	201.15	200.91	201.13	6472.0
2014-09-02 04:30:00	SPY	ETF	201.18	201.18	201.18	201.18	248.0
2014-09-02 05:00:00	SPY	ETF	201.15	201.15	201.08	201.08	827.0
2014-09-02 05:30:00	SPY	ETF	201.08	201.08	201.08	201.08	600.0
2014-09-02 06:00:00	SPY	ETF	201.08	201.15	201.07	201.15	17766.0
2014-09-02 06:30:00	SPY	ETF	201.07	201.13	201.07	201.07	25795.0
2014-09-02 07:00:00	SPY	ETF	201.07	201.11	200.88	200.9	138070.0
2014-09-02 07:30:00	SPY	ETF	200.96	200.96	200.75	200.88	83391.0
2014-09-02 08:00:00	SPY	ETF	201.07	201.07	200.7809	200.97	266234.0
2014-09-02 08:30:00	SPY	ETF	200.98	200.98	200.81	200.82	185601.0
2014-09-02 09:00:00	SPY	ETF	200.83	201.09	200.83	200.98	559328.0
2014-09-02 09:30:00	SPY	ETF	200.97	200.995	200.48	200.67	11046162.0
2014-09-02 10:00:00	SPY	ETF	200.69	200.85	200.46	200.76	5262160.0
2014-09-02 10:30:00	SPY	ETF	200.755	200.94	200.66	200.94	3351270.0
2014-09-02 11:00:00	SPY	ETF	200.93	200.98	200.5	200.54	5525842.0
2014-09-02 11:30:00	SPY	ETF	200.54	200.65	200.22	200.28	3876757.0
2014-09-02 12:00:00	SPY	ETF	200.28	200.44	200.2	200.4	2759795.0
2014-09-02 12:30:00	SPY	ETF	200.4	200.6	199.94	199.98	4365120.0
2014-09-02 13:00:00	SPY	ETF	199.96	200.12	199.86	199.95	4706218.0
2014-09-02 13:30:00	SPY	ETF	199.95	200.16	199.87	200.13	4768670.0
2014-09-02 14:00:00	SPY	ETF	200.13	200.32	200.1	200.31	2337145.0
2014-09-02 14:30:00	SPY	ETF	200.32	200.48	200.21	200.43	4110788.0
2014-09-02 15:00:00	SPY	ETF	200.43	200.49	200.36	200.44	2728576.0
2014-09-02 15:30:00	SPY	ETF	200.44	200.65	200.31	200.59	7596792.0
2014-09-02 16:00:00	SPY	ETF	200.6	200.7343	200.003	200.58	4622840.0
2014-09-02 16:30:00	SPY	ETF	200.58	200.67	200.55	200.65	1931743.0
2014-09-02 17:00:00	SPY	ETF	200.68	200.69	200.61	200.67	53121.0
2014-09-02 17:30:00	SPY	ETF	200.68	200.69	200.56	200.57	759471.0
2014-09-02 18:00:00	SPY	ETF	200.58	200.61	200.51	200.53	247092.0
2014-09-02 18:30:00	SPY	ETF	200.55	200.59	200.55	200.57	4650.0
2014-09-02 19:00:00	SPY	ETF	200.57	200.6	200.57	200.6	4150.0
2014-09-02 19:30:00	SPY	ETF	200.6	200.64	200.57	200.62	23955.0
2014-09-02 04:00:00	QQQ	ETF	99.9	99.9	99.9	99.9	100.0
2014-09-02 06:00:00	QQQ	ETF	99.99	99.99	99.99	99.99	100.0
2014-09-02 06:30:00	QQQ	ETF	100.04	100.04	100.02	100.02	8320.0
2014-09-02 07:00:00	QQQ	ETF	100.02	100.03	99.92	99.94	28150.0
2014-09-02 07:30:00	QQQ	ETF	99.92	99.93	99.87	99.91	15843.0
2014-09-02 08:00:00	QQQ	ETF	99.91	99.97	99.91	99.96	163605.0
2014-09-02 08:30:00	QQQ	ETF	99.98	99.98	99.9	99.9	25541.0
2014-09-02 09:00:00	QQQ	ETF	99.94	100.05	99.94	100.03	215043.0
2014-09-02 09:30:00	QQQ	ETF	100.04	100.1	99.8	99.87	2608938.0
2014-09-02 10:00:00	QQQ	ETF	99.88	100.015	99.81	99.98	2063112.0
2014-09-02 10:30:00	QQQ	ETF	99.985	100.08	99.94	100.08	1269920.0
2014-09-02 11:00:00	QQQ	ETF	100.08	100.1	99.9	99.94	1281810.0
2014-09-02 11:30:00	QQQ	ETF	99.95	100.0	99.81	99.83	1091423.0
2014-09-02 12:00:00	QQQ	ETF	99.82	99.95	99.81	99.94	918321.0
2014-09-02 12:30:00	QQQ	ETF	99.94	99.944	99.7	99.7	1486458.0
2014-09-02 13:00:00	QQQ	ETF	99.7	99.79	99.6601	99.71	871613.0
2014-09-02 13:30:00	QQQ	ETF	99.72	99.85	99.68	99.83	649625.0
2014-09-02 14:00:00	QQQ	ETF	99.831	99.91	99.81	99.88	603117.0

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

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