PREVIEW / etf_5min / 2014-04-07

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-04-07.parquet
  size:    1.1 MB
  rows:    44,985

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-04-07 04:00:00	SPY	ETF	185.99	185.99	185.66	185.75	35456.0
2014-04-07 04:05:00	SPY	ETF	185.83	185.83	185.8	185.8	1035.0
2014-04-07 04:10:00	SPY	ETF	185.78	185.8	185.78	185.8	1393.0
2014-04-07 04:15:00	SPY	ETF	185.8	185.8	185.79	185.79	787.0
2014-04-07 04:20:00	SPY	ETF	185.83	185.83	185.82	185.82	3750.0
2014-04-07 04:25:00	SPY	ETF	185.84	185.86	185.84	185.86	500.0
2014-04-07 04:30:00	SPY	ETF	185.86	185.86	185.86	185.86	500.0
2014-04-07 04:35:00	SPY	ETF	185.82	185.82	185.78	185.78	700.0
2014-04-07 04:40:00	SPY	ETF	185.77	185.78	185.77	185.78	4821.0
2014-04-07 04:45:00	SPY	ETF	185.77	185.81	185.75	185.8	4100.0
2014-04-07 04:50:00	SPY	ETF	185.77	185.77	185.72	185.72	2840.0
2014-04-07 04:55:00	SPY	ETF	185.72	185.72	185.71	185.71	340.0
2014-04-07 05:00:00	SPY	ETF	185.75	185.91	185.74	185.91	6215.0
2014-04-07 05:05:00	SPY	ETF	185.92	185.92	185.89	185.91	2950.0
2014-04-07 05:10:00	SPY	ETF	185.92	185.97	185.92	185.97	1500.0
2014-04-07 05:15:00	SPY	ETF	186.02	186.04	185.99	186.03	1500.0
2014-04-07 05:20:00	SPY	ETF	185.97	186.03	185.97	186.03	601.0
2014-04-07 05:25:00	SPY	ETF	186.03	186.03	186.03	186.03	600.0
2014-04-07 05:30:00	SPY	ETF	185.98	185.98	185.98	185.98	141.0
2014-04-07 05:40:00	SPY	ETF	186.01	186.01	185.95	185.95	1080.0
2014-04-07 05:45:00	SPY	ETF	185.97	185.97	185.95	185.95	20411.0
2014-04-07 05:50:00	SPY	ETF	185.93	185.93	185.87	185.87	18055.0
2014-04-07 05:55:00	SPY	ETF	185.83	185.83	185.83	185.83	697.0
2014-04-07 06:00:00	SPY	ETF	185.83	185.89	185.83	185.89	49879.0
2014-04-07 06:05:00	SPY	ETF	185.92	185.96	185.92	185.96	609.0
2014-04-07 06:10:00	SPY	ETF	185.96	185.96	185.84	185.85	18788.0
2014-04-07 06:15:00	SPY	ETF	185.84	185.85	185.76	185.76	7318.0
2014-04-07 06:20:00	SPY	ETF	185.75	185.75	185.75	185.75	100.0
2014-04-07 06:25:00	SPY	ETF	185.75	185.76	185.75	185.76	5260.0
2014-04-07 06:30:00	SPY	ETF	185.77	185.81	185.77	185.81	6424.0
2014-04-07 06:35:00	SPY	ETF	185.79	185.79	185.74	185.76	1997.0
2014-04-07 06:40:00	SPY	ETF	185.76	185.76	185.74	185.74	1061.0
2014-04-07 06:45:00	SPY	ETF	185.82	185.82	185.8	185.8	1600.0
2014-04-07 06:50:00	SPY	ETF	185.83	185.86	185.83	185.86	325.0
2014-04-07 06:55:00	SPY	ETF	185.86	185.86	185.84	185.84	11570.0
2014-04-07 07:00:00	SPY	ETF	185.86	185.91	185.85	185.86	17315.0
2014-04-07 07:05:00	SPY	ETF	185.82	185.86	185.8	185.8	10398.0
2014-04-07 07:10:00	SPY	ETF	185.79	185.79	185.73	185.73	8350.0
2014-04-07 07:15:00	SPY	ETF	185.76	185.76	185.57	185.6	17464.0
2014-04-07 07:20:00	SPY	ETF	185.6	185.64	185.55	185.55	99486.0
2014-04-07 07:25:00	SPY	ETF	185.59	185.68	185.55	185.65	60224.0
2014-04-07 07:30:00	SPY	ETF	185.69	185.69	185.67	185.68	18692.0
2014-04-07 07:35:00	SPY	ETF	185.69	185.81	185.69	185.81	14426.0
2014-04-07 07:40:00	SPY	ETF	185.82	185.82	185.72	185.74	12473.0
2014-04-07 07:45:00	SPY	ETF	185.73	185.73	185.6	185.64	84980.0
2014-04-07 07:50:00	SPY	ETF	185.63	185.69	185.63	185.68	37067.0
2014-04-07 07:55:00	SPY	ETF	185.67	185.76	185.67	185.76	34663.0
2014-04-07 08:00:00	SPY	ETF	185.75	185.86	185.57	185.83	130826.0
2014-04-07 08:05:00	SPY	ETF	185.83	185.88	185.79	185.79	102428.0
2014-04-07 08:10:00	SPY	ETF	185.81	185.81	185.72	185.76	52630.0

> showing 50 of 44,985 rows — these rows as CSV

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