PREVIEW / etf_5min / 2014-05-23

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-05-23.parquet
  size:    890 KB
  rows:    38,902

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-23 04:00:00	SPY	ETF	189.75	189.75	189.75	189.75	700.0
2014-05-23 04:10:00	SPY	ETF	189.75	189.75	189.69	189.69	13400.0
2014-05-23 04:15:00	SPY	ETF	189.69	189.72	189.69	189.7	12750.0
2014-05-23 04:35:00	SPY	ETF	189.7	189.74	189.7	189.74	5200.0
2014-05-23 04:40:00	SPY	ETF	189.77	189.77	189.77	189.77	200.0
2014-05-23 04:55:00	SPY	ETF	189.77	189.77	189.77	189.77	221.0
2014-05-23 05:35:00	SPY	ETF	189.64	189.74	189.64	189.72	3700.0
2014-05-23 05:40:00	SPY	ETF	189.75	189.77	189.75	189.75	1904.0
2014-05-23 05:50:00	SPY	ETF	189.75	189.75	189.75	189.75	3895.0
2014-05-23 05:55:00	SPY	ETF	189.8	189.83	189.8	189.83	640.0
2014-05-23 06:00:00	SPY	ETF	189.84	189.88	189.84	189.88	1200.0
2014-05-23 06:05:00	SPY	ETF	189.87	189.87	189.8	189.84	595.0
2014-05-23 06:20:00	SPY	ETF	189.8	189.8	189.8	189.8	500.0
2014-05-23 06:25:00	SPY	ETF	189.76	189.76	189.76	189.76	500.0
2014-05-23 06:35:00	SPY	ETF	189.72	189.72	189.72	189.72	541.0
2014-05-23 06:55:00	SPY	ETF	189.75	189.76	189.75	189.76	700.0
2014-05-23 07:00:00	SPY	ETF	189.77	189.8	189.77	189.8	1302.0
2014-05-23 07:05:00	SPY	ETF	189.83	189.83	189.8	189.82	8480.0
2014-05-23 07:10:00	SPY	ETF	189.76	189.76	189.75	189.75	10600.0
2014-05-23 07:20:00	SPY	ETF	189.79	189.82	189.79	189.8	23955.0
2014-05-23 07:25:00	SPY	ETF	189.8	189.8	189.78	189.78	1495.0
2014-05-23 07:30:00	SPY	ETF	189.8	189.81	189.8	189.81	1680.0
2014-05-23 07:35:00	SPY	ETF	189.77	189.8	189.76	189.8	3064.0
2014-05-23 07:40:00	SPY	ETF	189.8	189.8	189.72	189.79	20385.0
2014-05-23 07:45:00	SPY	ETF	189.76	189.81	189.76	189.8	4200.0
2014-05-23 07:50:00	SPY	ETF	189.76	189.79	189.76	189.76	19749.0
2014-05-23 07:55:00	SPY	ETF	189.76	189.76	189.75	189.76	31100.0
2014-05-23 08:00:00	SPY	ETF	189.75	189.76	189.71	189.74	83455.0
2014-05-23 08:05:00	SPY	ETF	189.74	189.74	189.72	189.72	6300.0
2014-05-23 08:10:00	SPY	ETF	189.71	189.74	189.71	189.73	4564.0
2014-05-23 08:15:00	SPY	ETF	189.71	189.74	189.7	189.73	18036.0
2014-05-23 08:20:00	SPY	ETF	189.75	189.76	189.72	189.72	8466.0
2014-05-23 08:25:00	SPY	ETF	189.72	189.73	189.72	189.73	2133.0
2014-05-23 08:30:00	SPY	ETF	189.74	189.74	189.71	189.71	14764.0
2014-05-23 08:35:00	SPY	ETF	189.73	189.74	189.72	189.72	12232.0
2014-05-23 08:40:00	SPY	ETF	189.73	189.73	189.71	189.72	30318.0
2014-05-23 08:45:00	SPY	ETF	189.71	189.72	189.71	189.72	20564.0
2014-05-23 08:50:00	SPY	ETF	189.71	189.75	189.71	189.73	13522.0
2014-05-23 08:55:00	SPY	ETF	189.72	189.73	189.7	189.7	16870.0
2014-05-23 09:00:00	SPY	ETF	189.69	189.69	189.58	189.6	52621.0
2014-05-23 09:05:00	SPY	ETF	189.6	189.67	189.59	189.64	17030.0
2014-05-23 09:10:00	SPY	ETF	189.66	189.68	189.66	189.67	9396.0
2014-05-23 09:15:00	SPY	ETF	189.67	189.71	189.67	189.7	26615.0
2014-05-23 09:20:00	SPY	ETF	189.69	189.73	189.69	189.73	11423.0
2014-05-23 09:25:00	SPY	ETF	189.72	189.77	189.72	189.75	174485.0
2014-05-23 09:30:00	SPY	ETF	189.75	189.9	189.68	189.8568	1698164.0
2014-05-23 09:35:00	SPY	ETF	189.86	189.92	189.72	189.745	1088922.0
2014-05-23 09:40:00	SPY	ETF	189.74	189.9	189.7	189.8	1121519.0
2014-05-23 09:45:00	SPY	ETF	189.81	189.88	189.71	189.71	1016896.0
2014-05-23 09:50:00	SPY	ETF	189.72	189.86	189.69	189.83	1158060.0

> showing 50 of 38,902 rows — these rows as CSV

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