PREVIEW / etf_5min / 2014-04-22

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-04-22.parquet
  size:    985 KB
  rows:    43,054

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-22 04:10:00	SPY	ETF	186.76	186.76	186.76	186.76	500.0
2014-04-22 04:15:00	SPY	ETF	187.14	187.25	187.0	187.25	503.0
2014-04-22 05:05:00	SPY	ETF	187.07	187.07	186.92	186.97	1201.0
2014-04-22 05:20:00	SPY	ETF	186.95	186.98	186.95	186.98	291.0
2014-04-22 05:25:00	SPY	ETF	186.96	186.96	186.92	186.92	3100.0
2014-04-22 05:35:00	SPY	ETF	186.97	186.98	186.97	186.98	887.0
2014-04-22 05:40:00	SPY	ETF	186.99	186.99	186.96	186.96	5100.0
2014-04-22 05:45:00	SPY	ETF	186.99	186.99	186.99	186.99	4100.0
2014-04-22 05:55:00	SPY	ETF	187.03	187.03	186.99	186.99	626.0
2014-04-22 06:00:00	SPY	ETF	186.99	187.01	186.98	187.01	5300.0
2014-04-22 06:05:00	SPY	ETF	187.01	187.02	187.01	187.02	387.0
2014-04-22 06:10:00	SPY	ETF	187.05	187.05	187.05	187.05	520.0
2014-04-22 06:15:00	SPY	ETF	187.11	187.11	187.11	187.11	800.0
2014-04-22 06:30:00	SPY	ETF	187.11	187.11	187.11	187.11	100.0
2014-04-22 06:35:00	SPY	ETF	187.1	187.12	187.1	187.12	980.0
2014-04-22 06:40:00	SPY	ETF	187.13	187.13	187.09	187.09	1800.0
2014-04-22 06:45:00	SPY	ETF	187.07	187.07	187.04	187.04	4800.0
2014-04-22 06:55:00	SPY	ETF	187.11	187.11	187.03	187.03	7713.0
2014-04-22 07:00:00	SPY	ETF	187.02	187.11	187.02	187.09	12039.0
2014-04-22 07:05:00	SPY	ETF	187.11	187.12	187.07	187.07	3399.0
2014-04-22 07:10:00	SPY	ETF	187.07	187.07	187.0	187.0	86205.0
2014-04-22 07:15:00	SPY	ETF	187.1	187.12	187.1	187.12	3951.0
2014-04-22 07:20:00	SPY	ETF	187.11	187.11	187.11	187.11	149.0
2014-04-22 07:25:00	SPY	ETF	187.1	187.1	187.05	187.05	1897.0
2014-04-22 07:30:00	SPY	ETF	187.04	187.04	187.01	187.04	3224.0
2014-04-22 07:35:00	SPY	ETF	187.0	187.0	186.97	186.99	16346.0
2014-04-22 07:40:00	SPY	ETF	187.0	187.02	186.98	186.98	2877.0
2014-04-22 07:45:00	SPY	ETF	187.0	187.0	187.0	187.0	420.0
2014-04-22 07:50:00	SPY	ETF	186.98	186.98	186.92	186.95	20430.0
2014-04-22 07:55:00	SPY	ETF	186.95	186.99	186.94	186.99	20155.0
2014-04-22 08:00:00	SPY	ETF	187.01	187.12	186.95	187.01	78629.0
2014-04-22 08:05:00	SPY	ETF	187.02	187.04	186.99	187.0	24960.0
2014-04-22 08:10:00	SPY	ETF	186.98	186.98	186.88	186.9	95400.0
2014-04-22 08:15:00	SPY	ETF	186.89	186.98	186.88	186.98	20666.0
2014-04-22 08:20:00	SPY	ETF	186.98	187.01	186.98	186.99	8350.0
2014-04-22 08:25:00	SPY	ETF	187.01	187.06	186.98	187.05	25280.0
2014-04-22 08:30:00	SPY	ETF	187.06	187.06	187.02	187.02	2310.0
2014-04-22 08:35:00	SPY	ETF	187.03	187.05	187.03	187.05	15007.0
2014-04-22 08:40:00	SPY	ETF	187.06	187.12	187.06	187.07	22610.0
2014-04-22 08:45:00	SPY	ETF	187.1	187.12	187.1	187.1	7585.0
2014-04-22 08:50:00	SPY	ETF	187.09	187.18	187.09	187.15	48247.0
2014-04-22 08:55:00	SPY	ETF	187.14	187.18	187.14	187.16	34846.0
2014-04-22 09:00:00	SPY	ETF	187.18	187.2	187.11	187.13	74194.0
2014-04-22 09:05:00	SPY	ETF	187.13	187.21	187.12	187.2	35051.0
2014-04-22 09:10:00	SPY	ETF	187.19	187.19	187.16	187.17	63600.0
2014-04-22 09:15:00	SPY	ETF	187.18	187.19	187.15	187.18	38099.0
2014-04-22 09:20:00	SPY	ETF	187.17	187.21	187.17	187.2	83222.0
2014-04-22 09:25:00	SPY	ETF	187.2	187.27	187.17	187.23	310894.0
2014-04-22 09:30:00	SPY	ETF	187.23	187.33	187.2	187.33	2980571.0
2014-04-22 09:35:00	SPY	ETF	187.33	187.39	187.255	187.353	2240629.0

> showing 50 of 43,054 rows — these rows as CSV

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