PREVIEW / etf_5min / 2017-07-19

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-07-19.parquet
  size:    1.2 MB
  rows:    53,535

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-07-19 04:00:00	SPY	ETF	245.91	245.91	245.91	245.91	300.0
2017-07-19 04:10:00	SPY	ETF	245.8	245.8	245.8	245.8	100.0
2017-07-19 04:40:00	SPY	ETF	245.78	245.78	245.78	245.78	100.0
2017-07-19 04:50:00	SPY	ETF	245.81	245.83	245.81	245.83	901.0
2017-07-19 05:05:00	SPY	ETF	245.82	245.82	245.82	245.82	100.0
2017-07-19 05:10:00	SPY	ETF	245.82	245.82	245.82	245.82	800.0
2017-07-19 05:15:00	SPY	ETF	245.82	245.82	245.82	245.82	200.0
2017-07-19 05:20:00	SPY	ETF	245.84	245.84	245.84	245.84	4000.0
2017-07-19 05:25:00	SPY	ETF	245.82	245.85	245.82	245.85	4300.0
2017-07-19 05:35:00	SPY	ETF	245.82	245.82	245.82	245.82	300.0
2017-07-19 05:40:00	SPY	ETF	245.82	245.82	245.82	245.82	3500.0
2017-07-19 05:45:00	SPY	ETF	245.85	245.85	245.83	245.83	330.0
2017-07-19 06:05:00	SPY	ETF	245.83	245.83	245.83	245.83	1000.0
2017-07-19 06:25:00	SPY	ETF	245.79	245.79	245.79	245.79	400.0
2017-07-19 06:30:00	SPY	ETF	245.79	245.79	245.79	245.79	400.0
2017-07-19 06:35:00	SPY	ETF	245.79	245.79	245.79	245.79	3303.0
2017-07-19 06:45:00	SPY	ETF	245.78	245.78	245.78	245.78	300.0
2017-07-19 06:50:00	SPY	ETF	245.78	245.78	245.76	245.76	8101.0
2017-07-19 07:00:00	SPY	ETF	245.75	245.75	245.75	245.75	500.0
2017-07-19 07:10:00	SPY	ETF	245.75	245.78	245.72	245.78	7103.0
2017-07-19 07:15:00	SPY	ETF	245.78	245.78	245.78	245.78	500.0
2017-07-19 07:20:00	SPY	ETF	245.8	245.8	245.78	245.78	510.0
2017-07-19 07:25:00	SPY	ETF	245.8	245.8	245.8	245.8	100.0
2017-07-19 07:30:00	SPY	ETF	245.82	245.82	245.81	245.81	2419.0
2017-07-19 07:35:00	SPY	ETF	245.81	245.82	245.81	245.82	1740.0
2017-07-19 07:40:00	SPY	ETF	245.78	245.78	245.78	245.78	4000.0
2017-07-19 07:50:00	SPY	ETF	245.77	245.78	245.77	245.78	600.0
2017-07-19 07:55:00	SPY	ETF	245.78	245.78	245.76	245.76	900.0
2017-07-19 08:00:00	SPY	ETF	245.8	245.8	245.75	245.76	13914.0
2017-07-19 08:05:00	SPY	ETF	245.78	245.82	245.78	245.81	8071.0
2017-07-19 08:10:00	SPY	ETF	245.83	245.83	245.83	245.83	2000.0
2017-07-19 08:15:00	SPY	ETF	245.81	245.85	245.8	245.82	12102.0
2017-07-19 08:20:00	SPY	ETF	245.82	245.88	245.82	245.88	16903.0
2017-07-19 08:25:00	SPY	ETF	245.88	245.98	245.88	245.98	34739.0
2017-07-19 08:30:00	SPY	ETF	245.96	245.97	245.91	245.91	13786.0
2017-07-19 08:35:00	SPY	ETF	245.92	245.93	245.91	245.92	3540.0
2017-07-19 08:40:00	SPY	ETF	245.92	245.93	245.91	245.92	4881.0
2017-07-19 08:45:00	SPY	ETF	245.91	245.91	245.86	245.86	10840.0
2017-07-19 08:50:00	SPY	ETF	245.87	245.89	245.8	245.81	123086.0
2017-07-19 08:55:00	SPY	ETF	245.8	245.9	245.8	245.9	23500.0
2017-07-19 09:00:00	SPY	ETF	245.89	245.9	245.88	245.9	9427.0
2017-07-19 09:05:00	SPY	ETF	245.89	245.92	245.88	245.88	15046.0
2017-07-19 09:10:00	SPY	ETF	245.9	245.94	245.89	245.94	40581.0
2017-07-19 09:15:00	SPY	ETF	245.94	246.03	245.94	246.0	43763.0
2017-07-19 09:20:00	SPY	ETF	246.01	246.06	246.01	246.02	49078.0
2017-07-19 09:25:00	SPY	ETF	246.02	246.08	246.0	246.03	62367.0
2017-07-19 09:30:00	SPY	ETF	246.02	246.16	246.01	246.13	1146875.0
2017-07-19 09:35:00	SPY	ETF	246.13	246.329	246.12	246.25	970762.0
2017-07-19 09:40:00	SPY	ETF	246.25	246.35	246.2	246.33	632976.0
2017-07-19 09:45:00	SPY	ETF	246.33	246.36	246.24	246.271	556996.0

> showing 50 of 53,535 rows — these rows as CSV

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