PREVIEW / etf_5min / 2013-11-01

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-11-01.parquet
  size:    981 KB
  rows:    41,788

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
2013-11-01 04:00:00	SPY	ETF	175.9	175.9	175.83	175.83	920.0
2013-11-01 04:05:00	SPY	ETF	175.83	175.83	175.81	175.81	88180.0
2013-11-01 04:10:00	SPY	ETF	175.89	175.89	175.78	175.78	8300.0
2013-11-01 04:15:00	SPY	ETF	175.78	175.84	175.74	175.84	144800.0
2013-11-01 04:20:00	SPY	ETF	175.8	175.8	175.73	175.73	97600.0
2013-11-01 04:25:00	SPY	ETF	175.75	175.78	175.75	175.78	1200.0
2013-11-01 04:30:00	SPY	ETF	175.83	175.88	175.83	175.85	1100.0
2013-11-01 04:35:00	SPY	ETF	175.8	175.8	175.8	175.8	400.0
2013-11-01 04:40:00	SPY	ETF	175.83	175.83	175.83	175.83	100.0
2013-11-01 04:50:00	SPY	ETF	175.8	175.8	175.78	175.78	5300.0
2013-11-01 04:55:00	SPY	ETF	175.79	175.79	175.75	175.78	1100.0
2013-11-01 05:00:00	SPY	ETF	175.83	175.83	175.75	175.75	800.0
2013-11-01 05:05:00	SPY	ETF	175.74	175.78	175.74	175.78	2500.0
2013-11-01 05:10:00	SPY	ETF	175.78	175.78	175.75	175.75	4600.0
2013-11-01 05:15:00	SPY	ETF	175.78	175.83	175.77	175.83	779.0
2013-11-01 05:20:00	SPY	ETF	175.8	175.8	175.8	175.8	200.0
2013-11-01 05:25:00	SPY	ETF	175.83	175.83	175.83	175.83	300.0
2013-11-01 05:35:00	SPY	ETF	175.8	175.83	175.8	175.83	800.0
2013-11-01 05:55:00	SPY	ETF	175.82	175.82	175.82	175.82	100.0
2013-11-01 06:00:00	SPY	ETF	175.8	175.83	175.8	175.83	400.0
2013-11-01 06:05:00	SPY	ETF	175.8	175.8	175.78	175.8	12000.0
2013-11-01 06:10:00	SPY	ETF	175.83	175.89	175.83	175.87	17700.0
2013-11-01 06:15:00	SPY	ETF	175.87	175.87	175.85	175.85	10400.0
2013-11-01 06:25:00	SPY	ETF	175.8	175.8	175.8	175.8	400.0
2013-11-01 06:30:00	SPY	ETF	175.75	175.75	175.72	175.74	10400.0
2013-11-01 06:35:00	SPY	ETF	175.76	175.77	175.73	175.73	1000.0
2013-11-01 06:40:00	SPY	ETF	175.72	175.72	175.68	175.72	3800.0
2013-11-01 06:45:00	SPY	ETF	175.72	175.76	175.72	175.76	1600.0
2013-11-01 06:50:00	SPY	ETF	175.75	175.75	175.75	175.75	700.0
2013-11-01 06:55:00	SPY	ETF	175.76	175.82	175.76	175.82	20800.0
2013-11-01 07:00:00	SPY	ETF	175.83	175.83	175.82	175.82	700.0
2013-11-01 07:05:00	SPY	ETF	175.84	175.87	175.82	175.82	5300.0
2013-11-01 07:10:00	SPY	ETF	175.81	175.83	175.81	175.83	4300.0
2013-11-01 07:15:00	SPY	ETF	175.82	175.82	175.82	175.82	200.0
2013-11-01 07:20:00	SPY	ETF	175.88	175.91	175.86	175.88	7554.0
2013-11-01 07:25:00	SPY	ETF	175.9	175.93	175.89	175.93	11590.0
2013-11-01 07:30:00	SPY	ETF	175.93	175.93	175.905	175.92	81168.0
2013-11-01 07:35:00	SPY	ETF	175.92	175.92	175.86	175.86	20460.0
2013-11-01 07:40:00	SPY	ETF	175.85	175.87	175.83	175.86	8381.0
2013-11-01 07:45:00	SPY	ETF	175.88	175.93	175.87	175.93	8600.0
2013-11-01 07:50:00	SPY	ETF	175.92	175.94	175.92	175.93	32900.0
2013-11-01 07:55:00	SPY	ETF	175.98	175.98	175.92	175.92	36300.0
2013-11-01 08:00:00	SPY	ETF	175.9	175.96	175.9	175.96	91350.0
2013-11-01 08:05:00	SPY	ETF	175.95	175.95	175.93	175.94	20250.0
2013-11-01 08:10:00	SPY	ETF	175.9	175.96	175.73	175.93	17341.0
2013-11-01 08:15:00	SPY	ETF	175.96	176.02	175.96	176.02	7238.0
2013-11-01 08:20:00	SPY	ETF	176.02	176.03	176.0	176.01	34575.0
2013-11-01 08:25:00	SPY	ETF	176.0	176.01	175.98	175.99	7000.0
2013-11-01 08:30:00	SPY	ETF	176.0	176.03	175.94	176.0	108975.0
2013-11-01 08:35:00	SPY	ETF	176.0	176.09	175.99	176.08	116530.0

> showing 50 of 41,788 rows — these rows as CSV

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