PREVIEW / etf_5min / 2014-05-16

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-05-16.parquet
  size:    952 KB
  rows:    40,729

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-05-16 04:40:00	SPY	ETF	187.17	187.17	187.17	187.17	301.0
2014-05-16 04:45:00	SPY	ETF	187.23	187.25	187.23	187.25	1650.0
2014-05-16 04:50:00	SPY	ETF	187.25	187.33	187.25	187.33	3316.0
2014-05-16 05:00:00	SPY	ETF	187.33	187.34	187.33	187.34	335.0
2014-05-16 05:10:00	SPY	ETF	187.31	187.31	187.31	187.31	350.0
2014-05-16 05:15:00	SPY	ETF	187.24	187.24	187.2	187.21	1200.0
2014-05-16 05:20:00	SPY	ETF	187.21	187.21	187.21	187.21	100.0
2014-05-16 05:30:00	SPY	ETF	187.22	187.23	187.22	187.23	400.0
2014-05-16 05:35:00	SPY	ETF	187.27	187.38	187.2	187.2	3000.0
2014-05-16 05:40:00	SPY	ETF	187.2	187.2	187.2	187.2	2700.0
2014-05-16 05:45:00	SPY	ETF	187.2	187.21	187.2	187.21	310.0
2014-05-16 05:50:00	SPY	ETF	187.23	187.23	187.15	187.17	4820.0
2014-05-16 05:55:00	SPY	ETF	187.14	187.14	187.06	187.06	1660.0
2014-05-16 06:00:00	SPY	ETF	187.06	187.06	187.02	187.06	6261.0
2014-05-16 06:15:00	SPY	ETF	187.02	187.02	186.9	186.9	2200.0
2014-05-16 06:20:00	SPY	ETF	186.9	186.9	186.82	186.82	3861.0
2014-05-16 06:25:00	SPY	ETF	186.82	186.9	186.82	186.9	5200.0
2014-05-16 06:30:00	SPY	ETF	186.91	186.94	186.9	186.9	3800.0
2014-05-16 06:35:00	SPY	ETF	186.87	186.87	186.8	186.81	4731.0
2014-05-16 06:40:00	SPY	ETF	186.86	186.87	186.82	186.87	3800.0
2014-05-16 06:45:00	SPY	ETF	186.9	186.91	186.9	186.91	2600.0
2014-05-16 06:50:00	SPY	ETF	186.91	186.91	186.87	186.87	500.0
2014-05-16 06:55:00	SPY	ETF	186.94	186.99	186.94	186.99	3850.0
2014-05-16 07:00:00	SPY	ETF	186.96	187.0	186.94	187.0	52397.0
2014-05-16 07:05:00	SPY	ETF	187.0	187.02	186.97	186.97	45900.0
2014-05-16 07:10:00	SPY	ETF	187.0	187.0	186.9	186.9	52700.0
2014-05-16 07:15:00	SPY	ETF	186.94	187.01	186.94	187.01	9357.0
2014-05-16 07:20:00	SPY	ETF	187.02	187.05	187.02	187.05	2768.0
2014-05-16 07:25:00	SPY	ETF	187.06	187.17	187.05	187.17	78461.0
2014-05-16 07:30:00	SPY	ETF	187.18	187.28	187.18	187.25	40540.0
2014-05-16 07:35:00	SPY	ETF	187.27	187.27	187.16	187.19	24678.0
2014-05-16 07:40:00	SPY	ETF	187.16	187.16	187.1	187.12	20300.0
2014-05-16 07:45:00	SPY	ETF	187.13	187.14	187.1	187.1	10800.0
2014-05-16 07:50:00	SPY	ETF	187.06	187.06	186.96	187.02	41533.0
2014-05-16 07:55:00	SPY	ETF	187.01	187.06	186.97	187.05	28910.0
2014-05-16 08:00:00	SPY	ETF	187.03	187.11	187.03	187.06	36282.0
2014-05-16 08:05:00	SPY	ETF	187.08	187.1	186.98	186.98	27865.0
2014-05-16 08:10:00	SPY	ETF	187.01	187.03	187.0	187.02	81884.0
2014-05-16 08:15:00	SPY	ETF	187.02	187.02	186.99	186.99	29113.0
2014-05-16 08:20:00	SPY	ETF	186.98	186.98	186.91	186.93	52421.0
2014-05-16 08:25:00	SPY	ETF	186.93	186.95	186.91	186.94	17706.0
2014-05-16 08:30:00	SPY	ETF	186.91	187.17	186.9	187.16	268378.0
2014-05-16 08:35:00	SPY	ETF	187.18	187.29	187.16	187.28	176531.0
2014-05-16 08:40:00	SPY	ETF	187.28	187.3	187.16	187.17	98315.0
2014-05-16 08:45:00	SPY	ETF	187.17	187.3	187.17	187.3	58441.0
2014-05-16 08:50:00	SPY	ETF	187.3	187.38	187.18	187.2	193753.0
2014-05-16 08:55:00	SPY	ETF	187.19	187.29	187.19	187.22	73500.0
2014-05-16 09:00:00	SPY	ETF	187.2	187.27	187.18	187.27	35106.0
2014-05-16 09:05:00	SPY	ETF	187.28	187.49	187.27	187.49	268827.0
2014-05-16 09:10:00	SPY	ETF	187.48	187.61	187.44	187.61	165290.0

> showing 50 of 40,729 rows — these rows as CSV

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