PREVIEW / etf_5min / 2013-05-02

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-05-02.parquet
  size:    959 KB
  rows:    40,777

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-05-02 04:00:00	SPY	ETF	158.73	158.73	158.7	158.7	500.0
2013-05-02 04:10:00	SPY	ETF	158.72	158.72	158.7	158.7	700.0
2013-05-02 04:15:00	SPY	ETF	158.69	158.69	158.68	158.68	1275.0
2013-05-02 04:20:00	SPY	ETF	158.66	158.66	158.65	158.65	1300.0
2013-05-02 04:25:00	SPY	ETF	158.6	158.6	158.6	158.6	200.0
2013-05-02 04:30:00	SPY	ETF	158.62	158.62	158.62	158.62	100.0
2013-05-02 04:40:00	SPY	ETF	158.62	158.62	158.61	158.61	799.0
2013-05-02 04:45:00	SPY	ETF	158.6	158.6	158.6	158.6	300.0
2013-05-02 04:50:00	SPY	ETF	158.58	158.58	158.56	158.56	1500.0
2013-05-02 04:55:00	SPY	ETF	158.55	158.55	158.55	158.55	500.0
2013-05-02 05:00:00	SPY	ETF	158.56	158.56	158.54	158.54	300.0
2013-05-02 05:05:00	SPY	ETF	158.54	158.54	158.54	158.54	100.0
2013-05-02 05:10:00	SPY	ETF	158.53	158.53	158.47	158.5	3600.0
2013-05-02 05:15:00	SPY	ETF	158.47	158.47	158.43	158.43	500.0
2013-05-02 05:30:00	SPY	ETF	158.44	158.44	158.44	158.44	100.0
2013-05-02 05:35:00	SPY	ETF	158.45	158.45	158.44	158.44	800.0
2013-05-02 05:40:00	SPY	ETF	158.44	158.44	158.44	158.44	300.0
2013-05-02 05:45:00	SPY	ETF	158.48	158.48	158.48	158.48	250.0
2013-05-02 05:50:00	SPY	ETF	158.49	158.5	158.49	158.5	500.0
2013-05-02 06:05:00	SPY	ETF	158.49	158.54	158.49	158.54	700.0
2013-05-02 06:10:00	SPY	ETF	158.54	158.54	158.54	158.54	4000.0
2013-05-02 06:15:00	SPY	ETF	158.54	158.54	158.54	158.54	200.0
2013-05-02 06:20:00	SPY	ETF	158.54	158.6	158.54	158.6	500.0
2013-05-02 06:25:00	SPY	ETF	158.61	158.65	158.61	158.61	30398.0
2013-05-02 06:30:00	SPY	ETF	158.59	158.59	158.59	158.59	600.0
2013-05-02 06:35:00	SPY	ETF	158.62	158.62	158.59	158.59	13000.0
2013-05-02 06:40:00	SPY	ETF	158.64	158.64	158.56	158.61	1100.0
2013-05-02 06:45:00	SPY	ETF	158.64	158.64	158.61	158.61	1000.0
2013-05-02 06:50:00	SPY	ETF	158.65	158.66	158.65	158.66	800.0
2013-05-02 06:55:00	SPY	ETF	158.67	158.67	158.66	158.67	2300.0
2013-05-02 07:00:00	SPY	ETF	158.68	158.74	158.66	158.7	14999.0
2013-05-02 07:05:00	SPY	ETF	158.7	158.74	158.69	158.72	32398.0
2013-05-02 07:10:00	SPY	ETF	158.72	158.73	158.69	158.71	11700.0
2013-05-02 07:15:00	SPY	ETF	158.72	158.74	158.69	158.69	55900.0
2013-05-02 07:20:00	SPY	ETF	158.69	158.69	158.59	158.59	15793.0
2013-05-02 07:25:00	SPY	ETF	158.61	158.61	158.56	158.59	5300.0
2013-05-02 07:30:00	SPY	ETF	158.6	158.64	158.58	158.64	22650.0
2013-05-02 07:35:00	SPY	ETF	158.64	158.67	158.59	158.64	101460.0
2013-05-02 07:40:00	SPY	ETF	158.66	158.75	158.66	158.67	89640.0
2013-05-02 07:45:00	SPY	ETF	158.74	158.87	158.71	158.83	179478.0
2013-05-02 07:50:00	SPY	ETF	158.83	159.0	158.83	158.85	204204.0
2013-05-02 07:55:00	SPY	ETF	158.85	158.92	158.82	158.86	56525.0
2013-05-02 08:00:00	SPY	ETF	158.86	158.91	158.61	158.88	68850.0
2013-05-02 08:05:00	SPY	ETF	158.88	158.9	158.83	158.9	108750.0
2013-05-02 08:10:00	SPY	ETF	158.9	158.94	158.85	158.91	150250.0
2013-05-02 08:15:00	SPY	ETF	158.89	158.92	158.71	158.71	76292.0
2013-05-02 08:20:00	SPY	ETF	158.76	158.81	158.74	158.76	30040.0
2013-05-02 08:25:00	SPY	ETF	158.77	158.81	158.77	158.77	34925.0
2013-05-02 08:30:00	SPY	ETF	158.77	159.21	158.77	159.16	706062.0
2013-05-02 08:35:00	SPY	ETF	159.16	159.35	159.13	159.27	555789.0

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

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