PREVIEW / etf_5min / 2014-06-25

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-06-25.parquet
  size:    983 KB
  rows:    42,388

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-06-25 04:00:00	SPY	ETF	194.8	194.8	194.8	194.8	100.0
2014-06-25 04:05:00	SPY	ETF	194.83	194.83	194.83	194.83	1000.0
2014-06-25 04:10:00	SPY	ETF	194.82	194.82	194.65	194.65	840.0
2014-06-25 04:20:00	SPY	ETF	194.83	194.83	194.83	194.83	110.0
2014-06-25 04:25:00	SPY	ETF	194.83	194.83	194.81	194.81	2190.0
2014-06-25 04:30:00	SPY	ETF	194.9	194.9	194.9	194.9	200.0
2014-06-25 04:40:00	SPY	ETF	194.91	194.91	194.91	194.91	516.0
2014-06-25 05:00:00	SPY	ETF	194.89	194.89	194.89	194.89	100.0
2014-06-25 05:20:00	SPY	ETF	195.04	195.04	194.94	195.0	1543.0
2014-06-25 05:30:00	SPY	ETF	194.95	194.99	194.95	194.95	3039.0
2014-06-25 05:40:00	SPY	ETF	194.9	194.9	194.9	194.9	443.0
2014-06-25 05:45:00	SPY	ETF	194.88	194.88	194.86	194.86	980.0
2014-06-25 06:05:00	SPY	ETF	194.85	194.87	194.85	194.87	750.0
2014-06-25 06:15:00	SPY	ETF	194.85	194.85	194.83	194.83	1500.0
2014-06-25 06:20:00	SPY	ETF	194.86	194.9	194.86	194.9	6775.0
2014-06-25 06:25:00	SPY	ETF	194.91	194.91	194.91	194.91	4400.0
2014-06-25 06:30:00	SPY	ETF	194.94	194.94	194.94	194.94	800.0
2014-06-25 06:35:00	SPY	ETF	194.96	195.0	194.96	194.96	1443.0
2014-06-25 06:45:00	SPY	ETF	194.97	195.0	194.97	195.0	28000.0
2014-06-25 06:50:00	SPY	ETF	195.02	195.02	195.02	195.02	1000.0
2014-06-25 06:55:00	SPY	ETF	195.04	195.04	195.04	195.04	150.0
2014-06-25 07:00:00	SPY	ETF	195.01	195.06	195.0	195.06	20300.0
2014-06-25 07:05:00	SPY	ETF	195.03	195.03	195.03	195.03	100.0
2014-06-25 07:10:00	SPY	ETF	194.94	194.95	194.92	194.95	4100.0
2014-06-25 07:15:00	SPY	ETF	194.91	194.92	194.9	194.92	2000.0
2014-06-25 07:20:00	SPY	ETF	194.9	194.95	194.9	194.94	3100.0
2014-06-25 07:25:00	SPY	ETF	194.97	194.97	194.97	194.97	600.0
2014-06-25 07:30:00	SPY	ETF	194.94	194.94	194.91	194.92	7500.0
2014-06-25 07:35:00	SPY	ETF	194.87	194.92	194.86	194.92	10100.0
2014-06-25 07:40:00	SPY	ETF	194.92	194.92	194.9	194.9	26105.0
2014-06-25 07:45:00	SPY	ETF	194.9	194.9	194.85	194.85	39400.0
2014-06-25 07:50:00	SPY	ETF	194.85	194.87	194.82	194.82	38169.0
2014-06-25 07:55:00	SPY	ETF	194.84	194.86	194.82	194.85	36911.0
2014-06-25 08:00:00	SPY	ETF	194.85	194.88	194.82	194.82	38864.0
2014-06-25 08:05:00	SPY	ETF	194.84	194.84	194.82	194.84	10276.0
2014-06-25 08:10:00	SPY	ETF	194.84	194.85	194.84	194.85	9470.0
2014-06-25 08:15:00	SPY	ETF	194.81	194.82	194.79	194.8	8065.0
2014-06-25 08:20:00	SPY	ETF	194.78	194.88	194.78	194.87	3801.0
2014-06-25 08:25:00	SPY	ETF	194.88	194.9	194.79	194.83	19718.0
2014-06-25 08:30:00	SPY	ETF	194.76	194.85	194.47	194.49	601662.0
2014-06-25 08:35:00	SPY	ETF	194.48	194.49	194.25	194.4	574849.0
2014-06-25 08:40:00	SPY	ETF	194.4	194.51	194.31	194.49	428359.0
2014-06-25 08:45:00	SPY	ETF	194.49	194.56	194.42	194.47	194386.0
2014-06-25 08:50:00	SPY	ETF	194.47	194.49	194.38	194.41	116382.0
2014-06-25 08:55:00	SPY	ETF	194.42	194.53	194.4	194.52	49856.0
2014-06-25 09:00:00	SPY	ETF	194.52	194.53	194.44	194.49	196968.0
2014-06-25 09:05:00	SPY	ETF	194.5	194.5	194.37	194.38	128203.0
2014-06-25 09:10:00	SPY	ETF	194.38	194.49	194.38	194.38	54770.0
2014-06-25 09:15:00	SPY	ETF	194.39	194.4	194.27	194.31	122243.0
2014-06-25 09:20:00	SPY	ETF	194.33	194.41	194.32	194.35	103538.0

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

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