PREVIEW / etf_5min / 2013-08-19

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-08-19.parquet
  size:    997 KB
  rows:    41,387

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
2013-08-19 04:00:00	SPY	ETF	165.7	165.7	165.7	165.7	100.0
2013-08-19 04:05:00	SPY	ETF	165.64	165.66	165.6	165.64	1300.0
2013-08-19 04:10:00	SPY	ETF	165.62	165.62	165.62	165.62	200.0
2013-08-19 04:15:00	SPY	ETF	165.6	165.65	165.56	165.64	3500.0
2013-08-19 04:20:00	SPY	ETF	165.66	165.7	165.66	165.66	1000.0
2013-08-19 04:25:00	SPY	ETF	165.64	165.66	165.64	165.64	600.0
2013-08-19 04:30:00	SPY	ETF	165.66	165.66	165.62	165.62	800.0
2013-08-19 04:35:00	SPY	ETF	165.64	165.65	165.64	165.65	800.0
2013-08-19 04:40:00	SPY	ETF	165.64	165.64	165.6	165.62	600.0
2013-08-19 04:45:00	SPY	ETF	165.6	165.6	165.6	165.6	904.0
2013-08-19 04:50:00	SPY	ETF	165.56	165.56	165.56	165.56	200.0
2013-08-19 04:55:00	SPY	ETF	165.55	165.62	165.55	165.62	3100.0
2013-08-19 05:00:00	SPY	ETF	165.62	165.65	165.62	165.65	800.0
2013-08-19 05:05:00	SPY	ETF	165.65	165.7	165.65	165.7	5100.0
2013-08-19 05:10:00	SPY	ETF	165.69	165.7	165.65	165.67	5300.0
2013-08-19 05:15:00	SPY	ETF	165.68	165.7	165.65	165.66	2900.0
2013-08-19 05:20:00	SPY	ETF	165.67	165.67	165.67	165.67	2000.0
2013-08-19 05:25:00	SPY	ETF	165.68	165.76	165.68	165.75	1800.0
2013-08-19 05:30:00	SPY	ETF	165.78	165.84	165.78	165.8	2205.0
2013-08-19 05:35:00	SPY	ETF	165.8	165.82	165.8	165.8	4600.0
2013-08-19 05:40:00	SPY	ETF	165.82	165.82	165.82	165.82	200.0
2013-08-19 05:45:00	SPY	ETF	165.8	165.8	165.74	165.74	800.0
2013-08-19 05:50:00	SPY	ETF	165.72	165.72	165.72	165.72	200.0
2013-08-19 05:55:00	SPY	ETF	165.71	165.71	165.71	165.71	4156.0
2013-08-19 06:00:00	SPY	ETF	165.71	165.71	165.71	165.71	5000.0
2013-08-19 06:05:00	SPY	ETF	165.74	165.8	165.74	165.8	600.0
2013-08-19 06:10:00	SPY	ETF	165.82	165.82	165.76	165.76	600.0
2013-08-19 06:15:00	SPY	ETF	165.74	165.74	165.66	165.66	800.0
2013-08-19 06:20:00	SPY	ETF	165.68	165.68	165.68	165.68	400.0
2013-08-19 06:25:00	SPY	ETF	165.7	165.72	165.7	165.72	400.0
2013-08-19 06:30:00	SPY	ETF	165.68	165.68	165.66	165.66	400.0
2013-08-19 06:35:00	SPY	ETF	165.66	165.66	165.64	165.64	20200.0
2013-08-19 06:40:00	SPY	ETF	165.66	165.68	165.66	165.68	400.0
2013-08-19 06:45:00	SPY	ETF	165.67	165.67	165.6	165.62	1800.0
2013-08-19 06:50:00	SPY	ETF	165.61	165.64	165.61	165.64	700.0
2013-08-19 06:55:00	SPY	ETF	165.64	165.64	165.61	165.63	2800.0
2013-08-19 07:00:00	SPY	ETF	165.64	165.66	165.54	165.6	13711.0
2013-08-19 07:05:00	SPY	ETF	165.62	165.66	165.62	165.62	6300.0
2013-08-19 07:10:00	SPY	ETF	165.6	165.6	165.56	165.56	700.0
2013-08-19 07:15:00	SPY	ETF	165.56	165.57	165.5	165.52	5384.0
2013-08-19 07:20:00	SPY	ETF	165.53	165.54	165.5	165.5	20984.0
2013-08-19 07:25:00	SPY	ETF	165.56	165.59	165.5	165.5	35700.0
2013-08-19 07:30:00	SPY	ETF	165.53	165.55	165.53	165.53	25250.0
2013-08-19 07:35:00	SPY	ETF	165.51	165.51	165.46	165.5	63400.0
2013-08-19 07:40:00	SPY	ETF	165.5	165.51	165.49	165.5	9080.0
2013-08-19 07:45:00	SPY	ETF	165.5	165.5	165.43	165.46	32740.0
2013-08-19 07:50:00	SPY	ETF	165.46	165.46	165.4	165.4	31537.0
2013-08-19 07:55:00	SPY	ETF	165.42	165.48	165.41	165.46	1400.0
2013-08-19 08:00:00	SPY	ETF	165.44	165.56	165.4	165.42	45912.0
2013-08-19 08:05:00	SPY	ETF	165.44	165.44	165.38	165.42	17660.0

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

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