PREVIEW / etf_5min / 2019-07-17

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-07-17.parquet
  size:    1.4 MB
  rows:    60,623

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
2019-07-17 04:00:00	SPY	ETF	300.03	300.23	300.03	300.23	12546.0
2019-07-17 04:05:00	SPY	ETF	300.24	300.24	300.18	300.23	2800.0
2019-07-17 04:10:00	SPY	ETF	300.23	300.33	300.23	300.33	3998.0
2019-07-17 04:15:00	SPY	ETF	300.24	300.24	300.24	300.24	600.0
2019-07-17 04:20:00	SPY	ETF	300.21	300.21	300.21	300.21	700.0
2019-07-17 04:25:00	SPY	ETF	300.18	300.18	300.18	300.18	600.0
2019-07-17 04:30:00	SPY	ETF	300.16	300.16	300.16	300.16	300.0
2019-07-17 04:35:00	SPY	ETF	300.18	300.18	300.18	300.18	500.0
2019-07-17 04:40:00	SPY	ETF	300.16	300.16	300.16	300.16	200.0
2019-07-17 04:50:00	SPY	ETF	300.16	300.16	300.16	300.16	500.0
2019-07-17 04:55:00	SPY	ETF	300.13	300.13	300.06	300.06	2579.0
2019-07-17 05:00:00	SPY	ETF	300.06	300.08	300.06	300.08	1200.0
2019-07-17 05:10:00	SPY	ETF	300.18	300.18	300.18	300.18	310.0
2019-07-17 05:15:00	SPY	ETF	300.18	300.25	300.18	300.18	8300.0
2019-07-17 05:20:00	SPY	ETF	300.18	300.18	300.18	300.18	300.0
2019-07-17 05:35:00	SPY	ETF	300.25	300.25	300.18	300.18	1340.0
2019-07-17 05:40:00	SPY	ETF	300.2	300.2	300.2	300.2	600.0
2019-07-17 05:50:00	SPY	ETF	300.2	300.2	300.2	300.2	300.0
2019-07-17 06:00:00	SPY	ETF	300.26	300.26	300.26	300.26	100.0
2019-07-17 06:10:00	SPY	ETF	300.23	300.23	300.23	300.23	560.0
2019-07-17 06:15:00	SPY	ETF	300.21	300.21	300.1	300.1	200.0
2019-07-17 06:20:00	SPY	ETF	300.07	300.11	300.03	300.11	1700.0
2019-07-17 06:30:00	SPY	ETF	300.03	300.03	300.03	300.03	100.0
2019-07-17 06:35:00	SPY	ETF	299.98	299.98	299.98	299.98	509.0
2019-07-17 06:40:00	SPY	ETF	299.95	299.95	299.9	299.91	1269.0
2019-07-17 06:45:00	SPY	ETF	299.89	299.93	299.89	299.93	5169.0
2019-07-17 06:50:00	SPY	ETF	299.9	299.9	299.9	299.9	500.0
2019-07-17 06:55:00	SPY	ETF	299.93	299.93	299.89	299.89	269.0
2019-07-17 07:00:00	SPY	ETF	299.93	299.93	299.86	299.88	7486.0
2019-07-17 07:05:00	SPY	ETF	299.83	299.86	299.77	299.86	9723.0
2019-07-17 07:15:00	SPY	ETF	299.81	299.83	299.8	299.81	4557.0
2019-07-17 07:20:00	SPY	ETF	299.81	299.81	299.81	299.81	400.0
2019-07-17 07:25:00	SPY	ETF	299.87	299.87	299.8	299.8	6400.0
2019-07-17 07:30:00	SPY	ETF	299.78	299.78	299.74	299.74	1669.0
2019-07-17 07:35:00	SPY	ETF	299.73	299.75	299.63	299.63	4083.0
2019-07-17 07:40:00	SPY	ETF	299.63	299.7	299.63	299.7	5700.0
2019-07-17 07:45:00	SPY	ETF	299.7	299.79	299.7	299.79	2041.0
2019-07-17 07:50:00	SPY	ETF	299.75	299.75	299.75	299.75	1000.0
2019-07-17 07:55:00	SPY	ETF	299.87	299.92	299.87	299.92	33424.0
2019-07-17 08:00:00	SPY	ETF	299.8585	299.95	299.6301	299.9	13939.0
2019-07-17 08:05:00	SPY	ETF	299.9	299.92	299.89	299.89	23787.0
2019-07-17 08:10:00	SPY	ETF	299.91	299.91	299.87	299.87	4130.0
2019-07-17 08:15:00	SPY	ETF	299.87	299.88	299.87	299.88	400.0
2019-07-17 08:20:00	SPY	ETF	299.89	299.91	299.87	299.87	52176.0
2019-07-17 08:25:00	SPY	ETF	299.88	299.94	299.88	299.89	8806.0
2019-07-17 08:30:00	SPY	ETF	299.91	299.91	299.6	299.66	23491.0
2019-07-17 08:35:00	SPY	ETF	299.66	299.82	299.64	299.78	53560.0
2019-07-17 08:40:00	SPY	ETF	299.75	299.8	299.74	299.8	80409.0
2019-07-17 08:45:00	SPY	ETF	299.79	299.81	299.76	299.77	12248.0
2019-07-17 08:50:00	SPY	ETF	299.8	299.81	299.72	299.72	4525.0

> showing 50 of 60,623 rows — these rows as CSV

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