PREVIEW / etf_5min / 2017-05-05

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-05-05.parquet
  size:    1.2 MB
  rows:    53,276

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-05-05 04:05:00	SPY	ETF	238.6	238.61	238.57	238.61	915.0
2017-05-05 04:15:00	SPY	ETF	238.69	238.69	238.69	238.69	300.0
2017-05-05 04:25:00	SPY	ETF	238.76	238.76	238.76	238.76	602.0
2017-05-05 04:30:00	SPY	ETF	238.79	238.79	238.79	238.79	600.0
2017-05-05 04:35:00	SPY	ETF	238.79	238.81	238.79	238.81	1700.0
2017-05-05 04:40:00	SPY	ETF	238.76	238.79	238.76	238.79	401.0
2017-05-05 04:45:00	SPY	ETF	238.79	238.79	238.79	238.79	400.0
2017-05-05 04:55:00	SPY	ETF	238.76	238.79	238.76	238.79	1802.0
2017-05-05 05:00:00	SPY	ETF	238.81	238.81	238.81	238.81	500.0
2017-05-05 05:05:00	SPY	ETF	238.84	238.84	238.79	238.79	502.0
2017-05-05 05:10:00	SPY	ETF	238.79	238.79	238.79	238.79	300.0
2017-05-05 05:15:00	SPY	ETF	238.76	238.76	238.76	238.76	502.0
2017-05-05 05:25:00	SPY	ETF	238.79	238.79	238.76	238.76	1203.0
2017-05-05 05:30:00	SPY	ETF	238.76	238.76	238.76	238.76	301.0
2017-05-05 05:35:00	SPY	ETF	238.76	238.76	238.76	238.76	400.0
2017-05-05 05:45:00	SPY	ETF	238.79	238.79	238.79	238.79	403.0
2017-05-05 05:50:00	SPY	ETF	238.84	238.84	238.79	238.79	1104.0
2017-05-05 05:55:00	SPY	ETF	238.79	238.79	238.79	238.79	503.0
2017-05-05 06:05:00	SPY	ETF	238.79	238.81	238.79	238.81	690.0
2017-05-05 06:10:00	SPY	ETF	238.81	238.81	238.81	238.81	400.0
2017-05-05 06:30:00	SPY	ETF	238.76	238.81	238.76	238.79	4401.0
2017-05-05 06:35:00	SPY	ETF	238.75	238.77	238.75	238.77	1219.0
2017-05-05 06:40:00	SPY	ETF	238.77	238.77	238.77	238.77	783.0
2017-05-05 06:45:00	SPY	ETF	238.84	238.84	238.84	238.84	4014.0
2017-05-05 06:55:00	SPY	ETF	238.86	238.86	238.86	238.86	1100.0
2017-05-05 07:00:00	SPY	ETF	238.83	238.83	238.82	238.83	5200.0
2017-05-05 07:05:00	SPY	ETF	238.82	238.85	238.82	238.85	4306.0
2017-05-05 07:10:00	SPY	ETF	238.85	238.89	238.85	238.86	35300.0
2017-05-05 07:15:00	SPY	ETF	238.86	238.86	238.84	238.84	1302.0
2017-05-05 07:20:00	SPY	ETF	238.85	238.85	238.84	238.84	11500.0
2017-05-05 07:25:00	SPY	ETF	238.84	238.86	238.82	238.86	2100.0
2017-05-05 07:30:00	SPY	ETF	238.82	238.85	238.82	238.84	8969.0
2017-05-05 07:35:00	SPY	ETF	238.86	238.86	238.82	238.85	2309.0
2017-05-05 07:40:00	SPY	ETF	238.84	238.84	238.82	238.82	1526.0
2017-05-05 07:45:00	SPY	ETF	238.82	238.82	238.8	238.8	869.0
2017-05-05 07:50:00	SPY	ETF	238.79	238.83	238.79	238.83	31004.0
2017-05-05 07:55:00	SPY	ETF	238.83	238.83	238.8	238.8	2369.0
2017-05-05 08:00:00	SPY	ETF	238.84	238.84	238.78	238.78	6526.0
2017-05-05 08:05:00	SPY	ETF	238.77	238.8	238.77	238.8	5441.0
2017-05-05 08:10:00	SPY	ETF	238.8	238.8	238.77	238.78	10382.0
2017-05-05 08:15:00	SPY	ETF	238.78	238.78	238.69	238.7	20341.0
2017-05-05 08:20:00	SPY	ETF	238.72	238.84	238.71	238.83	32651.0
2017-05-05 08:25:00	SPY	ETF	238.83	238.85	238.76	238.81	57667.0
2017-05-05 08:30:00	SPY	ETF	238.86	239.11	238.75	239.05	252995.0
2017-05-05 08:35:00	SPY	ETF	239.07	239.07	238.88	239.0	84405.0
2017-05-05 08:40:00	SPY	ETF	239.0	239.19	238.91	239.17	116491.0
2017-05-05 08:45:00	SPY	ETF	239.2	239.23	239.13	239.13	86845.0
2017-05-05 08:50:00	SPY	ETF	239.14	239.16	239.1	239.1	221297.0
2017-05-05 08:55:00	SPY	ETF	239.11	239.13	239.05	239.05	30347.0
2017-05-05 09:00:00	SPY	ETF	239.05	239.16	239.05	239.16	178441.0

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

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