PREVIEW / etf_5min / 2014-05-29

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-05-29.parquet
  size:    946 KB
  rows:    40,849

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-05-29 04:00:00	SPY	ETF	191.65	191.65	191.58	191.58	469.0
2014-05-29 04:05:00	SPY	ETF	191.56	191.56	191.56	191.56	400.0
2014-05-29 04:10:00	SPY	ETF	191.6	191.6	191.59	191.59	4449.0
2014-05-29 04:20:00	SPY	ETF	191.65	191.65	191.65	191.65	110.0
2014-05-29 04:55:00	SPY	ETF	191.63	191.63	191.63	191.63	229.0
2014-05-29 05:35:00	SPY	ETF	191.5	191.62	191.5	191.62	3400.0
2014-05-29 05:40:00	SPY	ETF	191.62	191.62	191.62	191.62	245.0
2014-05-29 06:05:00	SPY	ETF	191.63	191.63	191.63	191.63	700.0
2014-05-29 06:15:00	SPY	ETF	191.66	191.66	191.62	191.62	386.0
2014-05-29 06:20:00	SPY	ETF	191.6	191.6	191.6	191.6	100.0
2014-05-29 06:25:00	SPY	ETF	191.58	191.58	191.58	191.58	1200.0
2014-05-29 06:30:00	SPY	ETF	191.55	191.55	191.55	191.55	300.0
2014-05-29 06:35:00	SPY	ETF	191.54	191.58	191.54	191.58	800.0
2014-05-29 06:40:00	SPY	ETF	191.62	191.62	191.62	191.62	500.0
2014-05-29 06:45:00	SPY	ETF	191.66	191.66	191.66	191.66	728.0
2014-05-29 06:50:00	SPY	ETF	191.65	191.65	191.65	191.65	200.0
2014-05-29 06:55:00	SPY	ETF	191.68	191.68	191.68	191.68	5950.0
2014-05-29 07:00:00	SPY	ETF	191.69	191.69	191.65	191.65	2800.0
2014-05-29 07:05:00	SPY	ETF	191.65	191.65	191.62	191.62	6600.0
2014-05-29 07:10:00	SPY	ETF	191.65	191.65	191.61	191.61	25700.0
2014-05-29 07:15:00	SPY	ETF	191.64	191.64	191.62	191.62	10700.0
2014-05-29 07:20:00	SPY	ETF	191.62	191.63	191.58	191.58	11569.0
2014-05-29 07:25:00	SPY	ETF	191.56	191.65	191.56	191.61	27101.0
2014-05-29 07:30:00	SPY	ETF	191.61	191.61	191.61	191.61	4000.0
2014-05-29 07:35:00	SPY	ETF	191.6	191.66	191.6	191.66	18100.0
2014-05-29 07:40:00	SPY	ETF	191.68	191.68	191.65	191.65	10100.0
2014-05-29 07:45:00	SPY	ETF	191.68	191.69	191.65	191.65	21301.0
2014-05-29 07:50:00	SPY	ETF	191.63	191.63	191.62	191.63	5000.0
2014-05-29 07:55:00	SPY	ETF	191.66	191.66	191.57	191.57	7900.0
2014-05-29 08:00:00	SPY	ETF	191.59	191.66	191.57	191.66	47750.0
2014-05-29 08:05:00	SPY	ETF	191.69	191.77	191.68	191.7	32501.0
2014-05-29 08:10:00	SPY	ETF	191.7	191.7	191.6	191.62	8320.0
2014-05-29 08:15:00	SPY	ETF	191.62	191.66	191.62	191.65	8480.0
2014-05-29 08:20:00	SPY	ETF	191.66	191.67	191.64	191.67	62513.0
2014-05-29 08:25:00	SPY	ETF	191.65	191.66	191.63	191.65	16208.0
2014-05-29 08:30:00	SPY	ETF	191.64	192.08	191.48	191.63	191975.0
2014-05-29 08:35:00	SPY	ETF	191.61	191.7	191.61	191.69	98431.0
2014-05-29 08:40:00	SPY	ETF	191.69	191.71	191.66	191.67	45727.0
2014-05-29 08:45:00	SPY	ETF	191.66	191.72	191.65	191.69	52101.0
2014-05-29 08:50:00	SPY	ETF	191.72	191.79	191.71	191.77	61204.0
2014-05-29 08:55:00	SPY	ETF	191.77	191.79	191.72	191.78	90656.0
2014-05-29 09:00:00	SPY	ETF	191.78	191.8	191.76	191.77	77206.0
2014-05-29 09:05:00	SPY	ETF	191.77	191.78	191.73	191.73	39130.0
2014-05-29 09:10:00	SPY	ETF	191.74	191.89	191.71	191.84	143398.0
2014-05-29 09:15:00	SPY	ETF	191.84	191.87	191.79	191.81	81594.0
2014-05-29 09:20:00	SPY	ETF	191.82	191.86	191.82	191.84	71258.0
2014-05-29 09:25:00	SPY	ETF	191.83	191.87	191.8	191.83	152080.0
2014-05-29 09:30:00	SPY	ETF	191.82	191.88	191.71	191.87	1878146.0
2014-05-29 09:35:00	SPY	ETF	191.89	191.96	191.76	191.86	1481938.0
2014-05-29 09:40:00	SPY	ETF	191.86	191.94	191.8	191.88	1022848.0

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

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