PREVIEW / etf_5min / 2014-02-07

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-02-07.parquet
  size:    1.1 MB
  rows:    44,298

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.47	177.47	177.47	140.0
2014-02-07 04:05:00	SPY	ETF	177.5	177.5	177.46	177.49	639.0
2014-02-07 04:10:00	SPY	ETF	177.47	177.5	177.47	177.5	2501.0
2014-02-07 04:15:00	SPY	ETF	177.5	177.51	177.5	177.51	1500.0
2014-02-07 04:20:00	SPY	ETF	177.5	177.62	177.5	177.62	16800.0
2014-02-07 04:25:00	SPY	ETF	177.62	177.72	177.6	177.6	22720.0
2014-02-07 04:30:00	SPY	ETF	177.64	177.65	177.64	177.65	251.0
2014-02-07 04:35:00	SPY	ETF	177.65	177.68	177.65	177.68	660.0
2014-02-07 04:40:00	SPY	ETF	177.76	177.78	177.7	177.7	1600.0
2014-02-07 04:50:00	SPY	ETF	177.72	177.72	177.7	177.7	4327.0
2014-02-07 04:55:00	SPY	ETF	177.75	177.78	177.75	177.76	10434.0
2014-02-07 05:00:00	SPY	ETF	177.74	177.74	177.72	177.72	300.0
2014-02-07 05:05:00	SPY	ETF	177.7	177.7	177.7	177.7	1000.0
2014-02-07 05:10:00	SPY	ETF	177.76	177.76	177.76	177.76	200.0
2014-02-07 05:35:00	SPY	ETF	177.69	177.7	177.68	177.68	1170.0
2014-02-07 05:45:00	SPY	ETF	177.67	177.67	177.66	177.66	400.0
2014-02-07 05:50:00	SPY	ETF	177.64	177.64	177.63	177.63	40200.0
2014-02-07 05:55:00	SPY	ETF	177.69	177.69	177.69	177.69	12800.0
2014-02-07 06:00:00	SPY	ETF	177.66	177.69	177.66	177.69	1724.0
2014-02-07 06:05:00	SPY	ETF	177.66	177.66	177.65	177.65	1467.0
2014-02-07 06:10:00	SPY	ETF	177.66	177.66	177.66	177.66	1504.0
2014-02-07 06:15:00	SPY	ETF	177.65	177.65	177.64	177.64	4121.0
2014-02-07 06:25:00	SPY	ETF	177.61	177.64	177.61	177.64	4750.0
2014-02-07 06:30:00	SPY	ETF	177.71	177.71	177.66	177.66	2063.0
2014-02-07 06:35:00	SPY	ETF	177.69	177.69	177.6	177.61	54727.0
2014-02-07 06:40:00	SPY	ETF	177.58	177.6	177.54	177.6	6363.0
2014-02-07 06:45:00	SPY	ETF	177.59	177.66	177.59	177.66	300.0
2014-02-07 06:50:00	SPY	ETF	177.63	177.64	177.6	177.6	4301.0
2014-02-07 06:55:00	SPY	ETF	177.73	177.76	177.73	177.76	20200.0
2014-02-07 07:00:00	SPY	ETF	177.65	177.74	177.65	177.71	52322.0
2014-02-07 07:05:00	SPY	ETF	177.74	177.78	177.74	177.76	3675.0
2014-02-07 07:10:00	SPY	ETF	177.76	177.76	177.71	177.76	6622.0
2014-02-07 07:15:00	SPY	ETF	177.76	177.76	177.75	177.75	28279.0
2014-02-07 07:20:00	SPY	ETF	177.78	177.78	177.7	177.75	3750.0
2014-02-07 07:25:00	SPY	ETF	177.8	177.86	177.8	177.86	23577.0
2014-02-07 07:30:00	SPY	ETF	177.86	177.86	177.76	177.79	12663.0
2014-02-07 07:35:00	SPY	ETF	177.78	177.88	177.78	177.86	30905.0
2014-02-07 07:40:00	SPY	ETF	177.87	177.91	177.8	177.86	31075.0
2014-02-07 07:45:00	SPY	ETF	177.81	177.84	177.78	177.84	7401.0
2014-02-07 07:50:00	SPY	ETF	177.78	177.89	177.76	177.84	44136.0
2014-02-07 07:55:00	SPY	ETF	177.87	177.91	177.84	177.89	32287.0
2014-02-07 08:00:00	SPY	ETF	177.89	177.98	177.73	177.9	365477.0
2014-02-07 08:05:00	SPY	ETF	177.93	177.96	177.88	177.92	102170.0
2014-02-07 08:10:00	SPY	ETF	177.92	178.03	177.9	177.95	102865.0
2014-02-07 08:15:00	SPY	ETF	177.97	178.0	177.85	177.85	86225.0
2014-02-07 08:20:00	SPY	ETF	177.86	177.89	177.78	177.89	232525.0
2014-02-07 08:25:00	SPY	ETF	177.86	177.88	177.72	177.86	187860.0
2014-02-07 08:30:00	SPY	ETF	177.92	178.62	176.35	176.79	4983356.0
2014-02-07 08:35:00	SPY	ETF	176.78	177.38	176.65	177.18	2006001.0
2014-02-07 08:40:00	SPY	ETF	177.17	177.18	176.74	176.99	1399542.0

> showing 50 of 44,298 rows — these rows as CSV

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