PREVIEW / etf_5min / 2014-03-12

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-03-12.parquet
  size:    989 KB
  rows:    41,814

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-03-12 04:00:00	SPY	ETF	186.95	186.97	186.89	186.97	1539.0
2014-03-12 04:05:00	SPY	ETF	186.99	187.09	186.99	187.09	2750.0
2014-03-12 04:10:00	SPY	ETF	187.12	187.12	187.09	187.09	500.0
2014-03-12 04:20:00	SPY	ETF	187.03	187.03	186.99	186.99	300.0
2014-03-12 04:25:00	SPY	ETF	187.02	187.04	187.02	187.04	400.0
2014-03-12 04:30:00	SPY	ETF	187.05	187.05	186.97	186.97	1650.0
2014-03-12 04:35:00	SPY	ETF	186.99	187.03	186.99	187.03	700.0
2014-03-12 04:45:00	SPY	ETF	187.03	187.04	187.0	187.0	1700.0
2014-03-12 04:50:00	SPY	ETF	187.06	187.08	187.06	187.08	900.0
2014-03-12 04:55:00	SPY	ETF	187.02	187.02	186.98	186.98	1000.0
2014-03-12 05:00:00	SPY	ETF	186.97	186.97	186.87	186.9	3307.0
2014-03-12 05:05:00	SPY	ETF	186.89	186.89	186.88	186.88	907.0
2014-03-12 05:10:00	SPY	ETF	186.84	186.84	186.75	186.75	2593.0
2014-03-12 05:15:00	SPY	ETF	186.74	186.75	186.7	186.72	2575.0
2014-03-12 05:20:00	SPY	ETF	186.7	186.7	186.67	186.67	1100.0
2014-03-12 05:25:00	SPY	ETF	186.73	186.75	186.72	186.72	1241.0
2014-03-12 05:30:00	SPY	ETF	186.75	186.78	186.75	186.78	1869.0
2014-03-12 05:35:00	SPY	ETF	186.77	186.82	186.77	186.82	1743.0
2014-03-12 05:40:00	SPY	ETF	186.86	186.86	186.86	186.86	842.0
2014-03-12 05:45:00	SPY	ETF	186.78	186.78	186.78	186.78	1000.0
2014-03-12 05:50:00	SPY	ETF	186.82	186.82	186.82	186.82	1300.0
2014-03-12 05:55:00	SPY	ETF	186.78	186.78	186.78	186.78	1005.0
2014-03-12 06:00:00	SPY	ETF	186.74	186.77	186.7	186.7	909.0
2014-03-12 06:05:00	SPY	ETF	186.67	186.67	186.55	186.62	11992.0
2014-03-12 06:10:00	SPY	ETF	186.61	186.7	186.61	186.7	725.0
2014-03-12 06:15:00	SPY	ETF	186.66	186.67	186.62	186.62	1485.0
2014-03-12 06:20:00	SPY	ETF	186.61	186.62	186.58	186.61	2488.0
2014-03-12 06:25:00	SPY	ETF	186.62	186.63	186.54	186.58	36243.0
2014-03-12 06:30:00	SPY	ETF	186.62	186.71	186.62	186.68	29198.0
2014-03-12 06:35:00	SPY	ETF	186.66	186.66	186.54	186.54	15910.0
2014-03-12 06:40:00	SPY	ETF	186.52	186.53	186.4	186.43	44593.0
2014-03-12 06:45:00	SPY	ETF	186.43	186.47	186.43	186.47	12087.0
2014-03-12 06:50:00	SPY	ETF	186.5	186.55	186.5	186.52	13483.0
2014-03-12 06:55:00	SPY	ETF	186.5	186.51	186.43	186.43	2100.0
2014-03-12 07:00:00	SPY	ETF	186.43	186.5	186.43	186.5	53849.0
2014-03-12 07:05:00	SPY	ETF	186.48	186.48	186.43	186.43	46149.0
2014-03-12 07:10:00	SPY	ETF	186.43	186.54	186.42	186.54	8498.0
2014-03-12 07:15:00	SPY	ETF	186.54	186.57	186.45	186.47	65985.0
2014-03-12 07:20:00	SPY	ETF	186.46	186.46	186.44	186.45	77650.0
2014-03-12 07:25:00	SPY	ETF	186.5	186.53	186.5	186.5	3068.0
2014-03-12 07:30:00	SPY	ETF	186.52	186.53	186.47	186.53	60625.0
2014-03-12 07:35:00	SPY	ETF	186.51	186.65	186.51	186.65	13457.0
2014-03-12 07:40:00	SPY	ETF	186.65	186.66	186.62	186.65	4390.0
2014-03-12 07:45:00	SPY	ETF	186.64	186.69	186.64	186.69	2565.0
2014-03-12 07:50:00	SPY	ETF	186.7	186.7	186.63	186.65	11200.0
2014-03-12 07:55:00	SPY	ETF	186.62	186.69	186.58	186.69	12002.0
2014-03-12 08:00:00	SPY	ETF	186.68	186.73	186.46	186.68	56297.0
2014-03-12 08:05:00	SPY	ETF	186.68	186.68	186.55	186.6	46617.0
2014-03-12 08:10:00	SPY	ETF	186.61	186.655	186.59	186.6	40596.0
2014-03-12 08:15:00	SPY	ETF	186.62	186.64	186.53	186.53	43113.0

> showing 50 of 41,814 rows — these rows as CSV

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