PREVIEW / etf_5min / 2014-08-18

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-08-18.parquet
  size:    970 KB
  rows:    42,096

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-08-18 04:00:00	SPY	ETF	196.25	196.8	196.25	196.75	3009.0
2014-08-18 04:05:00	SPY	ETF	196.77	196.79	196.71	196.76	1049.0
2014-08-18 04:30:00	SPY	ETF	196.73	196.73	196.73	196.73	100.0
2014-08-18 04:35:00	SPY	ETF	196.73	196.73	196.73	196.73	153.0
2014-08-18 04:40:00	SPY	ETF	196.72	196.73	196.72	196.73	10800.0
2014-08-18 04:50:00	SPY	ETF	196.68	196.68	196.63	196.63	22036.0
2014-08-18 04:55:00	SPY	ETF	196.66	196.66	196.66	196.66	212.0
2014-08-18 05:00:00	SPY	ETF	196.68	196.68	196.68	196.68	1000.0
2014-08-18 05:15:00	SPY	ETF	196.68	196.7	196.68	196.68	3200.0
2014-08-18 05:20:00	SPY	ETF	196.68	196.68	196.63	196.63	12204.0
2014-08-18 05:25:00	SPY	ETF	196.65	196.65	196.63	196.63	3015.0
2014-08-18 05:30:00	SPY	ETF	196.68	196.68	196.65	196.65	18726.0
2014-08-18 05:35:00	SPY	ETF	196.65	196.68	196.65	196.68	31050.0
2014-08-18 05:40:00	SPY	ETF	196.7	196.7	196.68	196.69	16729.0
2014-08-18 05:45:00	SPY	ETF	196.6	196.6	196.55	196.55	530.0
2014-08-18 05:50:00	SPY	ETF	196.59	196.6	196.59	196.6	300.0
2014-08-18 05:55:00	SPY	ETF	196.59	196.59	196.59	196.59	185.0
2014-08-18 06:00:00	SPY	ETF	196.57	196.63	196.57	196.62	3146.0
2014-08-18 06:05:00	SPY	ETF	196.62	196.68	196.59	196.68	1920.0
2014-08-18 06:10:00	SPY	ETF	196.64	196.7	196.64	196.7	4450.0
2014-08-18 06:15:00	SPY	ETF	196.71	196.71	196.69	196.69	923.0
2014-08-18 06:20:00	SPY	ETF	196.7	196.72	196.69	196.72	27880.0
2014-08-18 06:30:00	SPY	ETF	196.73	196.75	196.73	196.75	604.0
2014-08-18 06:40:00	SPY	ETF	196.7	196.75	196.7	196.74	195800.0
2014-08-18 06:45:00	SPY	ETF	196.78	196.81	196.75	196.78	12630.0
2014-08-18 06:50:00	SPY	ETF	196.78	196.79	196.75	196.75	15200.0
2014-08-18 06:55:00	SPY	ETF	196.76	196.76	196.74	196.74	7650.0
2014-08-18 07:00:00	SPY	ETF	196.74	196.76	196.67	196.76	14685.0
2014-08-18 07:05:00	SPY	ETF	196.72	196.79	196.72	196.79	27175.0
2014-08-18 07:10:00	SPY	ETF	196.8	196.83	196.77	196.8	31600.0
2014-08-18 07:15:00	SPY	ETF	196.8	196.87	196.8	196.85	39130.0
2014-08-18 07:20:00	SPY	ETF	196.85	196.96	196.85	196.95	28050.0
2014-08-18 07:25:00	SPY	ETF	196.95	196.96	196.88	196.9	27927.0
2014-08-18 07:30:00	SPY	ETF	196.88	196.91	196.88	196.89	16651.0
2014-08-18 07:35:00	SPY	ETF	196.9	196.91	196.88	196.88	40603.0
2014-08-18 07:40:00	SPY	ETF	196.87	196.87	196.84	196.85	41102.0
2014-08-18 07:45:00	SPY	ETF	196.86	196.91	196.85	196.86	26301.0
2014-08-18 07:50:00	SPY	ETF	196.88	196.91	196.87	196.87	57802.0
2014-08-18 07:55:00	SPY	ETF	196.9	196.97	196.9	196.95	52002.0
2014-08-18 08:00:00	SPY	ETF	196.94	196.98	196.71	196.9	128520.0
2014-08-18 08:05:00	SPY	ETF	196.9	196.9	196.85	196.87	19869.0
2014-08-18 08:10:00	SPY	ETF	196.87	196.88	196.83	196.86	23651.0
2014-08-18 08:15:00	SPY	ETF	196.86	196.87	196.79	196.82	38279.0
2014-08-18 08:20:00	SPY	ETF	196.83	196.85	196.8	196.81	43322.0
2014-08-18 08:25:00	SPY	ETF	196.8	196.82	196.76	196.81	35733.0
2014-08-18 08:30:00	SPY	ETF	196.8	196.82	196.79	196.8	50401.0
2014-08-18 08:35:00	SPY	ETF	196.8	196.82	196.79	196.79	15297.0
2014-08-18 08:40:00	SPY	ETF	196.77	196.86	196.77	196.86	45146.0
2014-08-18 08:45:00	SPY	ETF	196.86	196.89	196.8	196.8	37475.0
2014-08-18 08:50:00	SPY	ETF	196.81	196.81	196.77	196.8	24441.0

> showing 50 of 42,096 rows — these rows as CSV

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