PREVIEW / etf_5min / 2019-09-17

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-09-17.parquet
  size:    1.4 MB
  rows:    59,180

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-09-17 04:00:00	SPY	ETF	300.12	300.36	300.12	300.36	960.0
2019-09-17 04:10:00	SPY	ETF	300.26	300.26	300.26	300.26	900.0
2019-09-17 04:20:00	SPY	ETF	300.33	300.33	300.33	300.33	300.0
2019-09-17 04:30:00	SPY	ETF	300.19	300.19	300.08	300.08	1300.0
2019-09-17 04:35:00	SPY	ETF	300.0	300.04	300.0	300.04	3800.0
2019-09-17 04:40:00	SPY	ETF	300.08	300.08	299.97	300.02	2200.0
2019-09-17 04:50:00	SPY	ETF	300.0	300.0	300.0	300.0	2000.0
2019-09-17 05:00:00	SPY	ETF	300.1	300.1	300.1	300.1	1000.0
2019-09-17 05:05:00	SPY	ETF	300.2	300.2	300.2	300.2	100.0
2019-09-17 05:10:00	SPY	ETF	300.18	300.18	300.13	300.13	1492.0
2019-09-17 05:15:00	SPY	ETF	300.2	300.27	300.2	300.27	2430.0
2019-09-17 05:20:00	SPY	ETF	300.22	300.22	300.22	300.22	100.0
2019-09-17 05:25:00	SPY	ETF	300.22	300.22	300.17	300.17	560.0
2019-09-17 05:45:00	SPY	ETF	299.99	299.99	299.98	299.98	2100.0
2019-09-17 05:50:00	SPY	ETF	299.95	299.95	299.95	299.95	301.0
2019-09-17 06:00:00	SPY	ETF	299.86	299.86	299.86	299.86	100.0
2019-09-17 06:05:00	SPY	ETF	299.9	299.9	299.9	299.9	400.0
2019-09-17 06:10:00	SPY	ETF	299.92	299.97	299.92	299.97	1000.0
2019-09-17 06:15:00	SPY	ETF	299.94	299.94	299.89	299.89	1200.0
2019-09-17 06:20:00	SPY	ETF	299.92	299.92	299.9	299.9	1500.0
2019-09-17 06:30:00	SPY	ETF	299.9	299.9	299.9	299.9	700.0
2019-09-17 06:35:00	SPY	ETF	299.97	299.97	299.97	299.97	200.0
2019-09-17 06:40:00	SPY	ETF	299.91	299.91	299.91	299.91	200.0
2019-09-17 06:45:00	SPY	ETF	299.9	299.95	299.9	299.95	2600.0
2019-09-17 06:55:00	SPY	ETF	299.83	299.83	299.72	299.72	9320.0
2019-09-17 07:00:00	SPY	ETF	299.77	299.78	299.73	299.76	16386.0
2019-09-17 07:05:00	SPY	ETF	299.75	299.76	299.73	299.75	8775.0
2019-09-17 07:10:00	SPY	ETF	299.75	299.78	299.73	299.74	10713.0
2019-09-17 07:15:00	SPY	ETF	299.75	299.77	299.75	299.77	16701.0
2019-09-17 07:20:00	SPY	ETF	299.8	299.86	299.8	299.86	33065.0
2019-09-17 07:25:00	SPY	ETF	299.82	299.89	299.82	299.89	102608.0
2019-09-17 07:30:00	SPY	ETF	299.89	299.92	299.88	299.92	32967.0
2019-09-17 07:35:00	SPY	ETF	299.96	300.0	299.95	299.98	20586.0
2019-09-17 07:40:00	SPY	ETF	300.07	300.3	300.07	300.3	4363.0
2019-09-17 07:45:00	SPY	ETF	300.3	300.3	300.2	300.26	3650.0
2019-09-17 07:50:00	SPY	ETF	300.19	300.2	300.17	300.17	40474.0
2019-09-17 07:55:00	SPY	ETF	300.14	300.21	300.13	300.21	2008.0
2019-09-17 08:00:00	SPY	ETF	300.1999	300.1999	299.7	300.08	15126.0
2019-09-17 08:05:00	SPY	ETF	300.07	300.07	299.76	299.78	41214.0
2019-09-17 08:10:00	SPY	ETF	299.84	299.88	299.73	299.86	31476.0
2019-09-17 08:15:00	SPY	ETF	299.83	299.88	299.83	299.83	19852.0
2019-09-17 08:20:00	SPY	ETF	299.82	299.9	299.82	299.84	6513.0
2019-09-17 08:25:00	SPY	ETF	299.82	299.86	299.71	299.8001	67310.0
2019-09-17 08:30:00	SPY	ETF	299.8	299.8	299.63	299.65	17698.0
2019-09-17 08:35:00	SPY	ETF	299.67	299.67	299.48	299.63	70214.0
2019-09-17 08:40:00	SPY	ETF	299.6	299.63	299.53	299.63	38045.0
2019-09-17 08:45:00	SPY	ETF	299.64	299.73	299.64	299.7	16545.0
2019-09-17 08:50:00	SPY	ETF	299.7	299.75	299.65	299.67	10704.0
2019-09-17 08:55:00	SPY	ETF	299.71	299.85	299.7	299.83	19066.0
2019-09-17 09:00:00	SPY	ETF	299.81	299.81	299.51	299.69	34622.0

> showing 50 of 59,180 rows — these rows as CSV

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