PREVIEW / etf_5min / 2014-09-05

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-09-05.parquet
  size:    988 KB
  rows:    40,726

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-05 04:00:00	SPY	ETF	200.03	200.06	200.03	200.06	1967.0
2014-09-05 04:05:00	SPY	ETF	200.06	200.06	199.95	199.95	8666.0
2014-09-05 04:20:00	SPY	ETF	199.96	200.0	199.95	200.0	767.0
2014-09-05 04:25:00	SPY	ETF	200.0	200.0	200.0	200.0	229.0
2014-09-05 04:30:00	SPY	ETF	199.97	200.07	199.97	199.98	6466.0
2014-09-05 04:35:00	SPY	ETF	199.97	199.97	199.95	199.97	8832.0
2014-09-05 04:40:00	SPY	ETF	199.95	199.95	199.93	199.93	350.0
2014-09-05 04:45:00	SPY	ETF	199.95	199.95	199.95	199.95	434.0
2014-09-05 04:50:00	SPY	ETF	199.95	199.95	199.95	199.95	500.0
2014-09-05 04:55:00	SPY	ETF	199.92	199.95	199.92	199.95	700.0
2014-09-05 05:05:00	SPY	ETF	199.88	199.88	199.86	199.86	10178.0
2014-09-05 05:10:00	SPY	ETF	199.9	199.9	199.85	199.87	1830.0
2014-09-05 05:20:00	SPY	ETF	199.9	199.9	199.9	199.9	174.0
2014-09-05 05:25:00	SPY	ETF	199.89	199.89	199.89	199.89	300.0
2014-09-05 05:30:00	SPY	ETF	199.94	199.97	199.94	199.97	1200.0
2014-09-05 05:35:00	SPY	ETF	199.97	199.97	199.89	199.89	941.0
2014-09-05 05:40:00	SPY	ETF	199.87	199.87	199.84	199.84	5949.0
2014-09-05 05:45:00	SPY	ETF	199.84	199.86	199.84	199.86	700.0
2014-09-05 05:50:00	SPY	ETF	199.84	199.84	199.79	199.79	346.0
2014-09-05 05:55:00	SPY	ETF	199.74	199.74	199.69	199.69	842.0
2014-09-05 06:00:00	SPY	ETF	199.67	199.67	199.48	199.52	14341.0
2014-09-05 06:05:00	SPY	ETF	199.54	199.64	199.5	199.64	12696.0
2014-09-05 06:10:00	SPY	ETF	199.64	199.64	199.52	199.54	2509.0
2014-09-05 06:15:00	SPY	ETF	199.64	199.64	199.63	199.63	5100.0
2014-09-05 06:20:00	SPY	ETF	199.63	199.69	199.62	199.67	9075.0
2014-09-05 06:25:00	SPY	ETF	199.71	199.71	199.66	199.69	28048.0
2014-09-05 06:30:00	SPY	ETF	199.64	199.64	199.59	199.61	26973.0
2014-09-05 06:35:00	SPY	ETF	199.6	199.62	199.54	199.54	23390.0
2014-09-05 06:40:00	SPY	ETF	199.53	199.59	199.53	199.56	26570.0
2014-09-05 06:45:00	SPY	ETF	199.62	199.62	199.61	199.62	950.0
2014-09-05 06:50:00	SPY	ETF	199.64	199.69	199.64	199.64	13650.0
2014-09-05 06:55:00	SPY	ETF	199.63	199.7	199.63	199.7	104800.0
2014-09-05 07:00:00	SPY	ETF	199.7	199.8	199.7	199.72	232086.0
2014-09-05 07:05:00	SPY	ETF	199.78	199.8	199.73	199.76	10834.0
2014-09-05 07:10:00	SPY	ETF	199.75	199.76	199.71	199.75	11321.0
2014-09-05 07:15:00	SPY	ETF	199.73	199.73	199.69	199.71	9301.0
2014-09-05 07:20:00	SPY	ETF	199.71	199.73	199.64	199.64	4901.0
2014-09-05 07:25:00	SPY	ETF	199.66	199.73	199.66	199.68	6753.0
2014-09-05 07:30:00	SPY	ETF	199.67	199.68	199.67	199.68	6500.0
2014-09-05 07:35:00	SPY	ETF	199.67	199.69	199.56	199.6	20751.0
2014-09-05 07:40:00	SPY	ETF	199.6	199.64	199.6	199.62	8574.0
2014-09-05 07:45:00	SPY	ETF	199.65	199.72	199.65	199.7	18250.0
2014-09-05 07:50:00	SPY	ETF	199.72	199.74	199.67	199.74	10062.0
2014-09-05 07:55:00	SPY	ETF	199.72	199.76	199.71	199.75	14880.0
2014-09-05 08:00:00	SPY	ETF	199.62	199.8	199.6	199.75	67796.0
2014-09-05 08:05:00	SPY	ETF	199.745	199.75	199.69	199.71	155750.0
2014-09-05 08:10:00	SPY	ETF	199.72	199.72	199.52	199.58	74573.0
2014-09-05 08:15:00	SPY	ETF	199.6	199.64	199.5	199.56	173029.0
2014-09-05 08:20:00	SPY	ETF	199.56	199.62	199.55	199.62	63311.0
2014-09-05 08:25:00	SPY	ETF	199.64	199.75	199.59	199.64	61884.0

> showing 50 of 40,726 rows — these rows as CSV

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