PREVIEW / etf_5min / 2016-07-19

all etf 5-min files

  file:    by_date/etf_5min/2016/2016-07-19.parquet
  size:    1.1 MB
  rows:    48,033

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
2016-07-19 04:00:00	SPY	ETF	215.81	215.81	215.61	215.61	2755.0
2016-07-19 04:05:00	SPY	ETF	215.6	215.69	215.6	215.69	6253.0
2016-07-19 04:10:00	SPY	ETF	215.75	215.75	215.74	215.74	500.0
2016-07-19 04:15:00	SPY	ETF	215.7	215.7	215.63	215.63	856.0
2016-07-19 04:20:00	SPY	ETF	215.66	215.66	215.66	215.66	400.0
2016-07-19 04:25:00	SPY	ETF	215.73	215.73	215.73	215.73	501.0
2016-07-19 04:30:00	SPY	ETF	215.75	215.84	215.75	215.84	5204.0
2016-07-19 04:40:00	SPY	ETF	215.79	215.79	215.7	215.7	570.0
2016-07-19 04:45:00	SPY	ETF	215.7	215.72	215.6	215.6	2039.0
2016-07-19 04:50:00	SPY	ETF	215.68	215.68	215.68	215.68	1000.0
2016-07-19 04:55:00	SPY	ETF	215.7	215.73	215.7	215.73	946.0
2016-07-19 05:00:00	SPY	ETF	215.71	215.84	215.71	215.8	5516.0
2016-07-19 05:10:00	SPY	ETF	215.7	215.7	215.7	215.7	106.0
2016-07-19 05:15:00	SPY	ETF	215.76	215.78	215.76	215.78	601.0
2016-07-19 05:20:00	SPY	ETF	215.78	215.81	215.78	215.81	700.0
2016-07-19 05:25:00	SPY	ETF	215.8	215.8	215.8	215.8	100.0
2016-07-19 05:30:00	SPY	ETF	215.76	215.76	215.73	215.73	1710.0
2016-07-19 05:35:00	SPY	ETF	215.71	215.75	215.7	215.75	404.0
2016-07-19 05:40:00	SPY	ETF	215.78	215.78	215.75	215.75	2453.0
2016-07-19 05:45:00	SPY	ETF	215.76	215.76	215.73	215.75	1701.0
2016-07-19 05:50:00	SPY	ETF	215.73	215.75	215.73	215.75	4000.0
2016-07-19 05:55:00	SPY	ETF	215.76	215.76	215.73	215.73	1303.0
2016-07-19 06:00:00	SPY	ETF	215.7	215.73	215.68	215.71	4603.0
2016-07-19 06:05:00	SPY	ETF	215.66	215.71	215.65	215.71	403.0
2016-07-19 06:15:00	SPY	ETF	215.66	215.66	215.65	215.65	2506.0
2016-07-19 06:20:00	SPY	ETF	215.66	215.66	215.63	215.66	20755.0
2016-07-19 06:25:00	SPY	ETF	215.63	215.66	215.63	215.66	764.0
2016-07-19 06:30:00	SPY	ETF	215.68	215.71	215.68	215.7	1102.0
2016-07-19 06:35:00	SPY	ETF	215.7	215.73	215.7	215.7	3601.0
2016-07-19 06:40:00	SPY	ETF	215.76	215.76	215.76	215.76	300.0
2016-07-19 06:45:00	SPY	ETF	215.76	215.76	215.76	215.76	450.0
2016-07-19 06:50:00	SPY	ETF	215.75	215.75	215.75	215.75	10000.0
2016-07-19 06:55:00	SPY	ETF	215.78	215.94	215.78	215.9	1362.0
2016-07-19 07:00:00	SPY	ETF	215.91	215.91	215.88	215.91	1253.0
2016-07-19 07:05:00	SPY	ETF	215.85	215.88	215.83	215.88	5301.0
2016-07-19 07:10:00	SPY	ETF	215.83	215.89	215.83	215.88	4609.0
2016-07-19 07:15:00	SPY	ETF	215.85	215.85	215.82	215.85	9540.0
2016-07-19 07:25:00	SPY	ETF	215.93	215.93	215.93	215.93	801.0
2016-07-19 07:30:00	SPY	ETF	215.93	215.96	215.9	215.96	7983.0
2016-07-19 07:35:00	SPY	ETF	215.9	216.02	215.9	216.02	4982.0
2016-07-19 07:40:00	SPY	ETF	216.0	216.03	215.95	215.96	42782.0
2016-07-19 07:45:00	SPY	ETF	215.95	216.0	215.9	216.0	12782.0
2016-07-19 07:50:00	SPY	ETF	216.0	216.0	215.99	216.0	1071.0
2016-07-19 07:55:00	SPY	ETF	215.96	216.0	215.92	215.92	76254.0
2016-07-19 08:00:00	SPY	ETF	215.93	215.98	215.9	215.96	54061.0
2016-07-19 08:05:00	SPY	ETF	215.98	215.99	215.95	215.96	24128.0
2016-07-19 08:10:00	SPY	ETF	215.99	215.99	215.92	215.93	10731.0
2016-07-19 08:15:00	SPY	ETF	215.93	215.93	215.89	215.92	10840.0
2016-07-19 08:20:00	SPY	ETF	215.93	215.94	215.85	215.89	26972.0
2016-07-19 08:25:00	SPY	ETF	215.88	215.95	215.85	215.94	17169.0

> showing 50 of 48,033 rows — these rows as CSV

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