PREVIEW / etf_5min / 2014-06-02

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-06-02.parquet
  size:    959 KB
  rows:    42,408

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-06-02 04:00:00	SPY	ETF	192.85	192.85	192.85	192.85	150.0
2014-06-02 04:15:00	SPY	ETF	192.85	192.85	192.85	192.85	100.0
2014-06-02 04:20:00	SPY	ETF	192.8	192.8	192.8	192.8	100.0
2014-06-02 04:25:00	SPY	ETF	192.78	192.78	192.78	192.78	200.0
2014-06-02 04:55:00	SPY	ETF	192.83	192.83	192.83	192.83	100.0
2014-06-02 05:00:00	SPY	ETF	192.83	192.83	192.83	192.83	100.0
2014-06-02 05:05:00	SPY	ETF	192.85	192.85	192.85	192.85	251.0
2014-06-02 05:30:00	SPY	ETF	192.86	192.86	192.86	192.86	4000.0
2014-06-02 06:10:00	SPY	ETF	192.97	192.97	192.97	192.97	100.0
2014-06-02 06:15:00	SPY	ETF	192.97	192.98	192.97	192.98	17629.0
2014-06-02 06:40:00	SPY	ETF	192.9	192.9	192.9	192.9	402.0
2014-06-02 06:45:00	SPY	ETF	192.9	192.9	192.9	192.9	400.0
2014-06-02 06:50:00	SPY	ETF	192.9	192.9	192.88	192.88	3198.0
2014-06-02 06:55:00	SPY	ETF	192.95	192.96	192.95	192.96	20026.0
2014-06-02 07:00:00	SPY	ETF	192.9	192.9	192.9	192.9	600.0
2014-06-02 07:05:00	SPY	ETF	192.88	192.9	192.88	192.9	205.0
2014-06-02 07:10:00	SPY	ETF	192.88	192.88	192.87	192.87	900.0
2014-06-02 07:15:00	SPY	ETF	192.87	192.92	192.82	192.89	107663.0
2014-06-02 07:25:00	SPY	ETF	192.85	192.85	192.85	192.85	1000.0
2014-06-02 07:30:00	SPY	ETF	192.85	192.85	192.83	192.83	28316.0
2014-06-02 07:35:00	SPY	ETF	192.83	192.83	192.8	192.8	3800.0
2014-06-02 07:40:00	SPY	ETF	192.81	192.81	192.8	192.81	968.0
2014-06-02 07:45:00	SPY	ETF	192.85	192.87	192.85	192.87	10073.0
2014-06-02 07:50:00	SPY	ETF	192.84	192.84	192.82	192.82	15500.0
2014-06-02 07:55:00	SPY	ETF	192.82	192.82	192.81	192.82	68886.0
2014-06-02 08:00:00	SPY	ETF	192.83	192.87	192.82	192.84	56513.0
2014-06-02 08:05:00	SPY	ETF	192.84	192.84	192.83	192.84	17000.0
2014-06-02 08:10:00	SPY	ETF	192.84	192.86	192.82	192.82	19306.0
2014-06-02 08:15:00	SPY	ETF	192.82	192.87	192.81	192.85	38861.0
2014-06-02 08:20:00	SPY	ETF	192.86	192.9	192.86	192.9	9314.0
2014-06-02 08:25:00	SPY	ETF	192.89	192.89	192.84	192.85	16460.0
2014-06-02 08:30:00	SPY	ETF	192.82	192.85	192.82	192.84	52040.0
2014-06-02 08:35:00	SPY	ETF	192.82	192.86	192.82	192.86	1250.0
2014-06-02 08:40:00	SPY	ETF	192.86	192.88	192.85	192.86	54939.0
2014-06-02 08:45:00	SPY	ETF	192.87	192.9	192.855	192.88	16758.0
2014-06-02 08:50:00	SPY	ETF	192.87	192.87	192.83	192.86	11953.0
2014-06-02 08:55:00	SPY	ETF	192.86	192.86	192.83	192.84	15630.0
2014-06-02 09:00:00	SPY	ETF	192.86	192.87	192.86	192.86	19080.0
2014-06-02 09:05:00	SPY	ETF	192.87	192.87	192.85	192.86	31787.0
2014-06-02 09:10:00	SPY	ETF	192.87	192.88	192.85	192.87	12346.0
2014-06-02 09:15:00	SPY	ETF	192.88	192.93	192.88	192.93	42959.0
2014-06-02 09:20:00	SPY	ETF	192.93	192.97	192.91	192.93	120224.0
2014-06-02 09:25:00	SPY	ETF	192.92	192.96	192.91	192.95	315691.0
2014-06-02 09:30:00	SPY	ETF	192.95	192.98	192.76	192.79	3037689.0
2014-06-02 09:35:00	SPY	ETF	192.79	192.885	192.72	192.78	1982372.0
2014-06-02 09:40:00	SPY	ETF	192.79	192.85	192.66	192.69	1398443.0
2014-06-02 09:45:00	SPY	ETF	192.685	192.98	192.48	192.503	1040633.0
2014-06-02 09:50:00	SPY	ETF	192.5	192.7539	192.5	192.6501	1079439.0
2014-06-02 09:55:00	SPY	ETF	192.65	192.69	192.5	192.52	758099.0
2014-06-02 10:00:00	SPY	ETF	192.5	192.55	192.21	192.23	2674187.0

> showing 50 of 42,408 rows — these rows as CSV

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