PREVIEW / etf_5min / 2014-03-18

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-03-18.parquet
  size:    1012 KB
  rows:    42,955

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-03-18 04:00:00	SPY	ETF	186.24	186.26	186.19	186.19	45600.0
2014-03-18 04:10:00	SPY	ETF	186.2	186.2	186.14	186.14	600.0
2014-03-18 04:15:00	SPY	ETF	186.12	186.12	186.07	186.07	700.0
2014-03-18 04:20:00	SPY	ETF	186.05	186.05	186.0	186.0	3850.0
2014-03-18 04:25:00	SPY	ETF	186.01	186.01	186.01	186.01	100.0
2014-03-18 04:30:00	SPY	ETF	185.91	185.91	185.89	185.9	2600.0
2014-03-18 04:40:00	SPY	ETF	185.87	185.87	185.87	185.87	400.0
2014-03-18 04:45:00	SPY	ETF	185.91	185.92	185.88	185.91	3100.0
2014-03-18 04:50:00	SPY	ETF	185.97	185.99	185.97	185.99	500.0
2014-03-18 04:55:00	SPY	ETF	185.97	186.07	185.97	186.05	3800.0
2014-03-18 05:00:00	SPY	ETF	185.99	185.99	185.99	185.99	500.0
2014-03-18 05:05:00	SPY	ETF	186.02	186.02	185.95	185.95	2950.0
2014-03-18 05:10:00	SPY	ETF	185.95	186.0	185.95	186.0	3700.0
2014-03-18 05:15:00	SPY	ETF	186.0	186.05	185.99	185.99	2015.0
2014-03-18 05:20:00	SPY	ETF	185.99	185.99	185.97	185.97	1900.0
2014-03-18 05:25:00	SPY	ETF	185.95	185.95	185.91	185.95	5954.0
2014-03-18 05:30:00	SPY	ETF	185.92	185.95	185.92	185.95	1600.0
2014-03-18 05:35:00	SPY	ETF	185.93	185.93	185.93	185.93	1000.0
2014-03-18 05:40:00	SPY	ETF	185.99	186.0	185.99	186.0	500.0
2014-03-18 05:45:00	SPY	ETF	186.0	186.0	186.0	186.0	1000.0
2014-03-18 05:50:00	SPY	ETF	185.99	185.99	185.95	185.95	1700.0
2014-03-18 05:55:00	SPY	ETF	185.95	185.96	185.93	185.95	3030.0
2014-03-18 06:00:00	SPY	ETF	185.93	185.95	185.91	185.95	11066.0
2014-03-18 06:05:00	SPY	ETF	185.99	186.06	185.99	186.03	4283.0
2014-03-18 06:10:00	SPY	ETF	186.07	186.08	186.03	186.03	2007.0
2014-03-18 06:15:00	SPY	ETF	186.0	186.0	185.99	185.99	1400.0
2014-03-18 06:20:00	SPY	ETF	186.0	186.11	186.0	186.11	1406.0
2014-03-18 06:25:00	SPY	ETF	186.13	186.15	186.11	186.11	8300.0
2014-03-18 06:30:00	SPY	ETF	186.07	186.11	186.05	186.1	1674.0
2014-03-18 06:35:00	SPY	ETF	186.11	186.19	186.11	186.19	3400.0
2014-03-18 06:40:00	SPY	ETF	186.21	186.29	186.21	186.23	3900.0
2014-03-18 06:45:00	SPY	ETF	186.24	186.28	186.19	186.22	6300.0
2014-03-18 06:50:00	SPY	ETF	186.15	186.15	186.08	186.08	2900.0
2014-03-18 06:55:00	SPY	ETF	186.07	186.07	185.89	185.9	16700.0
2014-03-18 07:00:00	SPY	ETF	185.93	186.0	185.88	186.0	31311.0
2014-03-18 07:05:00	SPY	ETF	185.95	185.98	185.91	185.93	9365.0
2014-03-18 07:10:00	SPY	ETF	185.93	185.94	185.83	185.86	65106.0
2014-03-18 07:15:00	SPY	ETF	185.87	185.9	185.78	185.87	40835.0
2014-03-18 07:20:00	SPY	ETF	185.87	185.99	185.87	185.99	20332.0
2014-03-18 07:25:00	SPY	ETF	185.98	186.15	185.98	186.15	26625.0
2014-03-18 07:30:00	SPY	ETF	186.17	186.39	186.17	186.27	148926.0
2014-03-18 07:35:00	SPY	ETF	186.24	186.61	186.22	186.59	275888.0
2014-03-18 07:40:00	SPY	ETF	186.6	187.13	186.6	187.02	315011.0
2014-03-18 07:45:00	SPY	ETF	187.03	187.11	186.89	186.99	225556.0
2014-03-18 07:50:00	SPY	ETF	186.99	186.99	186.79	186.85	246694.0
2014-03-18 07:55:00	SPY	ETF	186.86	187.02	186.85	186.96	59429.0
2014-03-18 08:00:00	SPY	ETF	187.06	187.07	185.9	186.97	224023.0
2014-03-18 08:05:00	SPY	ETF	186.84	187.02	186.84	186.89	111800.0
2014-03-18 08:10:00	SPY	ETF	186.87	186.94	186.86	186.86	49931.0
2014-03-18 08:15:00	SPY	ETF	186.86	186.89	186.84	186.88	29175.0

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

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