PREVIEW / etf_5min / 2017-11-07

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-11-07.parquet
  size:    1.3 MB
  rows:    56,690

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
2017-11-07 04:00:00	SPY	ETF	258.93	259.0	258.92	258.97	4265.0
2017-11-07 04:05:00	SPY	ETF	258.97	259.02	258.96	258.99	2120.0
2017-11-07 04:10:00	SPY	ETF	258.97	259.02	258.97	259.02	2100.0
2017-11-07 04:15:00	SPY	ETF	259.02	259.04	259.02	259.02	1800.0
2017-11-07 04:20:00	SPY	ETF	259.04	259.04	259.04	259.04	1000.0
2017-11-07 04:25:00	SPY	ETF	259.04	259.04	259.04	259.04	1400.0
2017-11-07 04:30:00	SPY	ETF	259.0	259.0	259.0	259.0	900.0
2017-11-07 04:35:00	SPY	ETF	258.99	259.02	258.99	259.02	500.0
2017-11-07 04:40:00	SPY	ETF	258.99	258.99	258.9	258.9	4608.0
2017-11-07 04:45:00	SPY	ETF	258.83	258.9	258.83	258.9	2439.0
2017-11-07 04:50:00	SPY	ETF	258.92	258.92	258.9	258.9	3200.0
2017-11-07 04:55:00	SPY	ETF	258.95	258.95	258.95	258.95	1100.0
2017-11-07 05:00:00	SPY	ETF	258.92	258.92	258.92	258.92	300.0
2017-11-07 05:10:00	SPY	ETF	258.87	258.87	258.87	258.87	400.0
2017-11-07 05:20:00	SPY	ETF	258.83	258.83	258.83	258.83	100.0
2017-11-07 05:50:00	SPY	ETF	258.8	258.8	258.8	258.8	100.0
2017-11-07 06:10:00	SPY	ETF	258.9	258.9	258.85	258.85	5400.0
2017-11-07 06:15:00	SPY	ETF	258.86	258.86	258.86	258.86	100.0
2017-11-07 06:25:00	SPY	ETF	258.8	258.8	258.78	258.78	910.0
2017-11-07 06:30:00	SPY	ETF	258.8	258.8	258.8	258.8	300.0
2017-11-07 06:35:00	SPY	ETF	258.84	258.84	258.8	258.8	600.0
2017-11-07 06:40:00	SPY	ETF	258.81	258.83	258.81	258.83	200.0
2017-11-07 06:45:00	SPY	ETF	258.83	258.83	258.83	258.83	100.0
2017-11-07 06:50:00	SPY	ETF	258.86	258.9	258.86	258.9	5100.0
2017-11-07 06:55:00	SPY	ETF	258.79	258.79	258.79	258.79	110.0
2017-11-07 07:00:00	SPY	ETF	258.82	258.85	258.81	258.85	2246.0
2017-11-07 07:05:00	SPY	ETF	258.85	258.85	258.83	258.83	4410.0
2017-11-07 07:15:00	SPY	ETF	258.82	258.82	258.81	258.81	25000.0
2017-11-07 07:20:00	SPY	ETF	258.83	258.83	258.83	258.83	1800.0
2017-11-07 07:25:00	SPY	ETF	258.83	258.83	258.83	258.83	200.0
2017-11-07 07:30:00	SPY	ETF	258.8	258.8	258.78	258.8	5492.0
2017-11-07 07:35:00	SPY	ETF	258.8	258.8	258.76	258.79	11300.0
2017-11-07 07:40:00	SPY	ETF	258.77	258.79	258.74	258.75	12600.0
2017-11-07 07:45:00	SPY	ETF	258.74	258.75	258.7	258.7	4531.0
2017-11-07 07:50:00	SPY	ETF	258.71	258.72	258.69	258.69	4200.0
2017-11-07 07:55:00	SPY	ETF	258.69	258.72	258.66	258.71	8802.0
2017-11-07 08:00:00	SPY	ETF	258.69	258.85	258.69	258.76	6631.0
2017-11-07 08:05:00	SPY	ETF	258.78	258.8	258.76	258.8	10506.0
2017-11-07 08:10:00	SPY	ETF	258.81	258.82	258.79	258.82	15885.0
2017-11-07 08:15:00	SPY	ETF	258.81	258.82	258.81	258.82	11860.0
2017-11-07 08:20:00	SPY	ETF	258.81	258.82	258.78	258.82	32496.0
2017-11-07 08:25:00	SPY	ETF	258.8	258.82	258.79	258.82	48600.0
2017-11-07 08:30:00	SPY	ETF	258.81	258.85	258.81	258.85	5073.0
2017-11-07 08:35:00	SPY	ETF	258.81	258.81	258.8	258.8	1301.0
2017-11-07 08:40:00	SPY	ETF	258.83	258.83	258.83	258.83	2323.0
2017-11-07 08:45:00	SPY	ETF	258.82	258.84	258.82	258.84	2702.0
2017-11-07 08:50:00	SPY	ETF	258.84	258.94	258.84	258.9	40720.0
2017-11-07 08:55:00	SPY	ETF	258.91	258.93	258.91	258.92	46391.0
2017-11-07 09:00:00	SPY	ETF	258.9	258.9	258.83	258.83	5566.0
2017-11-07 09:05:00	SPY	ETF	258.84	258.86	258.81	258.82	26540.0

> showing 50 of 56,690 rows — these rows as CSV

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