PREVIEW / etf_5min / 2013-07-05

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-07-05.parquet
  size:    984 KB
  rows:    41,782

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-07-05 04:00:00	SPY	ETF	162.85	163.0	161.99	162.97	8166.0
2013-07-05 04:05:00	SPY	ETF	162.97	162.99	162.97	162.99	18400.0
2013-07-05 04:10:00	SPY	ETF	162.94	162.96	162.91	162.94	10550.0
2013-07-05 04:15:00	SPY	ETF	162.91	162.91	162.89	162.89	800.0
2013-07-05 04:20:00	SPY	ETF	162.86	162.86	162.86	162.86	600.0
2013-07-05 04:25:00	SPY	ETF	162.85	162.85	162.82	162.84	1400.0
2013-07-05 04:30:00	SPY	ETF	162.83	162.89	162.83	162.89	1045.0
2013-07-05 04:35:00	SPY	ETF	162.9	162.9	162.84	162.84	1100.0
2013-07-05 04:40:00	SPY	ETF	162.84	162.84	162.84	162.84	400.0
2013-07-05 04:50:00	SPY	ETF	162.79	162.79	162.78	162.78	600.0
2013-07-05 04:55:00	SPY	ETF	162.81	162.84	162.81	162.84	400.0
2013-07-05 05:00:00	SPY	ETF	162.85	162.85	162.84	162.85	600.0
2013-07-05 05:05:00	SPY	ETF	162.85	162.85	162.85	162.85	100.0
2013-07-05 05:10:00	SPY	ETF	162.85	162.85	162.84	162.85	7100.0
2013-07-05 05:15:00	SPY	ETF	162.88	162.89	162.88	162.89	300.0
2013-07-05 05:20:00	SPY	ETF	162.84	162.84	162.84	162.84	200.0
2013-07-05 05:25:00	SPY	ETF	162.79	162.79	162.79	162.79	200.0
2013-07-05 05:30:00	SPY	ETF	162.84	162.84	162.81	162.81	300.0
2013-07-05 05:40:00	SPY	ETF	162.79	162.84	162.79	162.84	1400.0
2013-07-05 06:00:00	SPY	ETF	162.79	162.8	162.76	162.8	10100.0
2013-07-05 06:05:00	SPY	ETF	162.77	162.87	162.77	162.87	5800.0
2013-07-05 06:10:00	SPY	ETF	162.87	162.9	162.86	162.89	9712.0
2013-07-05 06:15:00	SPY	ETF	162.85	162.85	162.81	162.83	1600.0
2013-07-05 06:20:00	SPY	ETF	162.85	162.89	162.84	162.89	1500.0
2013-07-05 06:25:00	SPY	ETF	162.89	162.89	162.88	162.89	3600.0
2013-07-05 06:30:00	SPY	ETF	162.84	162.86	162.79	162.79	38240.0
2013-07-05 06:35:00	SPY	ETF	162.76	162.79	162.76	162.79	500.0
2013-07-05 06:40:00	SPY	ETF	162.74	162.77	162.74	162.77	300.0
2013-07-05 06:45:00	SPY	ETF	162.74	162.76	162.74	162.76	10700.0
2013-07-05 06:50:00	SPY	ETF	162.8	162.82	162.8	162.82	300.0
2013-07-05 07:00:00	SPY	ETF	162.75	162.79	162.73	162.74	17894.0
2013-07-05 07:05:00	SPY	ETF	162.74	162.74	162.66	162.66	8800.0
2013-07-05 07:10:00	SPY	ETF	162.67	162.68	162.57	162.67	44100.0
2013-07-05 07:15:00	SPY	ETF	162.62	162.63	162.56	162.63	3455.0
2013-07-05 07:20:00	SPY	ETF	162.64	162.7	162.61	162.69	11395.0
2013-07-05 07:25:00	SPY	ETF	162.65	162.65	162.56	162.62	22085.0
2013-07-05 07:30:00	SPY	ETF	162.64	162.69	162.64	162.65	32400.0
2013-07-05 07:35:00	SPY	ETF	162.68	162.69	162.55	162.57	100300.0
2013-07-05 07:40:00	SPY	ETF	162.56	162.56	162.5	162.53	37274.0
2013-07-05 07:45:00	SPY	ETF	162.53	162.61	162.53	162.61	78752.0
2013-07-05 07:50:00	SPY	ETF	162.59	162.65	162.59	162.61	31000.0
2013-07-05 07:55:00	SPY	ETF	162.63	162.67	162.61	162.62	10460.0
2013-07-05 08:00:00	SPY	ETF	162.59	162.825	162.58	162.64	215347.0
2013-07-05 08:05:00	SPY	ETF	162.62	162.65	162.58	162.65	50223.0
2013-07-05 08:10:00	SPY	ETF	162.65	162.92	162.63	162.89	128970.0
2013-07-05 08:15:00	SPY	ETF	162.87	162.87	162.75	162.79	26840.0
2013-07-05 08:20:00	SPY	ETF	162.81	162.82	162.76	162.8	43282.0
2013-07-05 08:25:00	SPY	ETF	162.79	163.3	162.79	162.85	570734.0
2013-07-05 08:30:00	SPY	ETF	162.85	163.53	162.44	163.52	1697887.0
2013-07-05 08:35:00	SPY	ETF	163.52	163.53	162.96	163.1	1409014.0

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

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