PREVIEW / etf_5min / 2019-08-09

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-08-09.parquet
  size:    1.4 MB
  rows:    61,797

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-08-09 04:00:00	SPY	ETF	292.38	292.38	292.28	292.28	1012.0
2019-08-09 04:05:00	SPY	ETF	292.24	292.24	292.17	292.2	1656.0
2019-08-09 04:10:00	SPY	ETF	292.34	292.34	292.2	292.2	1441.0
2019-08-09 04:15:00	SPY	ETF	292.1	292.1	292.1	292.1	405.0
2019-08-09 04:20:00	SPY	ETF	292.01	292.05	292.01	292.05	483.0
2019-08-09 04:25:00	SPY	ETF	292.13	292.2	292.13	292.2	620.0
2019-08-09 04:30:00	SPY	ETF	292.3	292.3	292.3	292.3	400.0
2019-08-09 04:35:00	SPY	ETF	292.15	292.15	292.15	292.15	200.0
2019-08-09 04:45:00	SPY	ETF	292.05	292.15	292.05	292.15	1270.0
2019-08-09 04:55:00	SPY	ETF	292.29	292.29	292.29	292.29	100.0
2019-08-09 05:15:00	SPY	ETF	292.43	292.65	292.43	292.65	2309.0
2019-08-09 05:20:00	SPY	ETF	292.68	292.68	292.68	292.68	1350.0
2019-08-09 05:30:00	SPY	ETF	292.35	292.35	292.25	292.25	26204.0
2019-08-09 05:35:00	SPY	ETF	292.14	292.14	292.14	292.14	950.0
2019-08-09 05:40:00	SPY	ETF	292.14	292.29	292.14	292.23	1415.0
2019-08-09 05:45:00	SPY	ETF	292.17	292.17	292.06	292.08	3310.0
2019-08-09 05:50:00	SPY	ETF	292.16	292.16	292.0	292.04	1288.0
2019-08-09 05:55:00	SPY	ETF	292.04	292.06	292.04	292.06	510.0
2019-08-09 06:00:00	SPY	ETF	292.09	292.09	292.09	292.09	101.0
2019-08-09 06:05:00	SPY	ETF	292.16	292.23	292.16	292.23	300.0
2019-08-09 06:10:00	SPY	ETF	292.2	292.24	292.2	292.24	3350.0
2019-08-09 06:15:00	SPY	ETF	292.24	292.24	292.22	292.22	2115.0
2019-08-09 06:20:00	SPY	ETF	292.11	292.11	292.08	292.08	250.0
2019-08-09 06:25:00	SPY	ETF	292.01	292.01	291.86	291.86	2703.0
2019-08-09 06:30:00	SPY	ETF	291.81	291.9	291.81	291.9	25176.0
2019-08-09 06:35:00	SPY	ETF	291.95	291.95	291.9	291.9	2600.0
2019-08-09 06:40:00	SPY	ETF	291.87	291.87	291.78	291.85	3150.0
2019-08-09 06:45:00	SPY	ETF	291.99	292.05	291.99	292.05	5167.0
2019-08-09 06:50:00	SPY	ETF	292.08	292.13	292.05	292.1	19965.0
2019-08-09 06:55:00	SPY	ETF	292.08	292.1	292.02	292.08	14100.0
2019-08-09 07:00:00	SPY	ETF	292.11	292.11	291.92	291.98	9940.0
2019-08-09 07:05:00	SPY	ETF	291.98	292.01	291.84	291.9	34018.0
2019-08-09 07:10:00	SPY	ETF	291.84	291.84	291.64	291.7	20376.0
2019-08-09 07:15:00	SPY	ETF	291.7	291.7	291.65	291.68	4525.0
2019-08-09 07:20:00	SPY	ETF	291.65	291.65	291.55	291.6	34232.0
2019-08-09 07:25:00	SPY	ETF	291.65	291.75	291.6	291.6	11300.0
2019-08-09 07:30:00	SPY	ETF	291.67	291.68	291.52	291.54	11225.0
2019-08-09 07:35:00	SPY	ETF	291.59	291.71	291.54	291.71	11482.0
2019-08-09 07:40:00	SPY	ETF	291.7	292.09	291.7	292.03	73305.0
2019-08-09 07:45:00	SPY	ETF	291.98	292.11	291.95	292.0	24763.0
2019-08-09 07:50:00	SPY	ETF	291.93	292.03	291.9	291.98	3091.0
2019-08-09 07:55:00	SPY	ETF	291.86	291.88	291.8	291.85	8960.0
2019-08-09 08:00:00	SPY	ETF	291.83	292.68	291.61	291.95	66014.0
2019-08-09 08:05:00	SPY	ETF	292.0	292.44	291.99	292.38	61732.0
2019-08-09 08:10:00	SPY	ETF	292.35	292.44	292.33	292.36	13822.0
2019-08-09 08:15:00	SPY	ETF	292.35	292.39	292.34	292.36	17479.0
2019-08-09 08:20:00	SPY	ETF	292.39	292.4	292.33	292.33	15137.0
2019-08-09 08:25:00	SPY	ETF	292.25	292.25	292.16	292.23	20032.0
2019-08-09 08:30:00	SPY	ETF	292.18	292.22	291.93	291.93	25730.0
2019-08-09 08:35:00	SPY	ETF	292.01	292.09	291.9	291.94	33872.0

> showing 50 of 61,797 rows — these rows as CSV

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