PREVIEW / etf_5min / 2018-08-17

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-08-17.parquet
  size:    1.3 MB
  rows:    56,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
2018-08-17 04:00:00	SPY	ETF	284.3	284.41	284.25	284.39	5332.0
2018-08-17 04:05:00	SPY	ETF	284.41	284.57	284.41	284.57	1400.0
2018-08-17 04:15:00	SPY	ETF	284.52	284.53	284.52	284.53	600.0
2018-08-17 04:30:00	SPY	ETF	284.47	284.54	284.47	284.54	2800.0
2018-08-17 04:40:00	SPY	ETF	284.52	284.52	284.52	284.52	4000.0
2018-08-17 04:45:00	SPY	ETF	284.5	284.5	284.45	284.45	1100.0
2018-08-17 04:50:00	SPY	ETF	284.39	284.39	284.39	284.39	600.0
2018-08-17 04:55:00	SPY	ETF	284.4	284.4	284.4	284.4	300.0
2018-08-17 05:00:00	SPY	ETF	284.35	284.35	284.35	284.35	200.0
2018-08-17 05:05:00	SPY	ETF	284.29	284.29	284.27	284.27	600.0
2018-08-17 05:15:00	SPY	ETF	284.25	284.25	284.1	284.1	3052.0
2018-08-17 05:20:00	SPY	ETF	284.09	284.13	284.05	284.07	2082.0
2018-08-17 05:25:00	SPY	ETF	284.02	284.04	284.01	284.04	1900.0
2018-08-17 05:35:00	SPY	ETF	283.99	283.99	283.84	283.9	2842.0
2018-08-17 05:40:00	SPY	ETF	284.08	284.08	284.08	284.08	100.0
2018-08-17 05:45:00	SPY	ETF	283.9	283.9	283.8	283.8	2650.0
2018-08-17 05:50:00	SPY	ETF	283.9	283.9	283.84	283.84	5100.0
2018-08-17 05:55:00	SPY	ETF	283.9	283.9	283.79	283.79	5750.0
2018-08-17 06:00:00	SPY	ETF	283.77	283.8	283.7	283.7	8404.0
2018-08-17 06:05:00	SPY	ETF	283.7	283.75	283.7	283.75	415.0
2018-08-17 06:10:00	SPY	ETF	283.8	283.82	283.8	283.8	1700.0
2018-08-17 06:15:00	SPY	ETF	283.93	283.93	283.85	283.85	900.0
2018-08-17 06:20:00	SPY	ETF	283.85	283.88	283.85	283.87	7300.0
2018-08-17 06:25:00	SPY	ETF	283.97	284.02	283.97	283.99	1195.0
2018-08-17 06:30:00	SPY	ETF	283.97	283.97	283.97	283.97	200.0
2018-08-17 06:35:00	SPY	ETF	283.91	283.96	283.91	283.96	1750.0
2018-08-17 06:45:00	SPY	ETF	283.97	283.97	283.97	283.97	900.0
2018-08-17 06:55:00	SPY	ETF	284.06	284.06	284.06	284.06	100.0
2018-08-17 07:00:00	SPY	ETF	284.08	284.1	284.05	284.1	5405.0
2018-08-17 07:05:00	SPY	ETF	284.15	284.17	284.14	284.15	26429.0
2018-08-17 07:10:00	SPY	ETF	284.17	284.19	284.09	284.1	20153.0
2018-08-17 07:15:00	SPY	ETF	284.08	284.08	283.96	283.96	4843.0
2018-08-17 07:20:00	SPY	ETF	283.95	284.07	283.93	284.07	2151.0
2018-08-17 07:30:00	SPY	ETF	284.05	284.05	283.94	283.97	15610.0
2018-08-17 07:35:00	SPY	ETF	283.93	284.0	283.92	284.0	13750.0
2018-08-17 07:40:00	SPY	ETF	283.94	283.94	283.89	283.93	2022.0
2018-08-17 07:45:00	SPY	ETF	283.94	283.97	283.94	283.94	6000.0
2018-08-17 07:50:00	SPY	ETF	283.97	283.99	283.93	283.93	2720.0
2018-08-17 07:55:00	SPY	ETF	283.94	283.95	283.88	283.88	13230.0
2018-08-17 08:00:00	SPY	ETF	283.96	283.96	283.75	283.79	32582.0
2018-08-17 08:05:00	SPY	ETF	283.81	283.82	283.4	283.55	101461.0
2018-08-17 08:10:00	SPY	ETF	283.54	283.64	283.54	283.64	27990.0
2018-08-17 08:15:00	SPY	ETF	283.64	283.74	283.64	283.69	33009.0
2018-08-17 08:20:00	SPY	ETF	283.64	283.74	283.63	283.7	12421.0
2018-08-17 08:25:00	SPY	ETF	283.71	283.71	283.61	283.64	18615.0
2018-08-17 08:30:00	SPY	ETF	283.69	283.74	283.63	283.71	26161.0
2018-08-17 08:35:00	SPY	ETF	283.71	283.75	283.66	283.68	100089.0
2018-08-17 08:40:00	SPY	ETF	283.69	283.79	283.69	283.69	29404.0
2018-08-17 08:45:00	SPY	ETF	283.73	283.86	283.71	283.86	32466.0
2018-08-17 08:50:00	SPY	ETF	283.87	284.04	283.87	284.04	171900.0

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

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