PREVIEW / etf_5min / 2018-04-19

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-04-19.parquet
  size:    1.3 MB
  rows:    57,168

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-04-19 04:00:00	SPY	ETF	270.41	270.41	270.19	270.19	2180.0
2018-04-19 04:05:00	SPY	ETF	270.12	270.12	270.07	270.07	625.0
2018-04-19 04:10:00	SPY	ETF	270.13	270.13	270.13	270.13	100.0
2018-04-19 04:15:00	SPY	ETF	270.23	270.26	270.23	270.26	3400.0
2018-04-19 04:25:00	SPY	ETF	270.32	270.37	270.32	270.35	900.0
2018-04-19 04:30:00	SPY	ETF	270.3	270.3	270.3	270.3	550.0
2018-04-19 04:35:00	SPY	ETF	270.29	270.32	270.29	270.32	1100.0
2018-04-19 04:40:00	SPY	ETF	270.25	270.25	270.15	270.15	900.0
2018-04-19 04:50:00	SPY	ETF	270.24	270.24	270.24	270.24	300.0
2018-04-19 04:55:00	SPY	ETF	270.1	270.1	269.94	269.94	1410.0
2018-04-19 05:00:00	SPY	ETF	270.0	270.1	270.0	270.1	300.0
2018-04-19 05:05:00	SPY	ETF	270.25	270.25	270.25	270.25	400.0
2018-04-19 05:10:00	SPY	ETF	270.28	270.28	270.28	270.28	1000.0
2018-04-19 05:25:00	SPY	ETF	270.19	270.19	270.19	270.19	300.0
2018-04-19 05:30:00	SPY	ETF	270.23	270.23	270.23	270.23	500.0
2018-04-19 05:50:00	SPY	ETF	270.17	270.23	270.16	270.23	1200.0
2018-04-19 06:00:00	SPY	ETF	270.2	270.24	270.19	270.19	2600.0
2018-04-19 06:05:00	SPY	ETF	270.2	270.2	270.0	270.0	425.0
2018-04-19 06:10:00	SPY	ETF	270.01	270.01	269.98	269.98	750.0
2018-04-19 06:15:00	SPY	ETF	270.04	270.04	269.99	270.0	1335.0
2018-04-19 06:20:00	SPY	ETF	270.06	270.1	270.06	270.1	950.0
2018-04-19 06:25:00	SPY	ETF	270.13	270.14	270.04	270.04	2210.0
2018-04-19 06:30:00	SPY	ETF	270.08	270.08	270.0	270.01	2600.0
2018-04-19 06:35:00	SPY	ETF	270.0	270.05	269.98	270.05	500.0
2018-04-19 06:40:00	SPY	ETF	270.0	270.04	269.98	270.03	2440.0
2018-04-19 06:45:00	SPY	ETF	270.06	270.06	270.03	270.03	1260.0
2018-04-19 06:50:00	SPY	ETF	270.01	270.01	270.0	270.0	1500.0
2018-04-19 06:55:00	SPY	ETF	269.99	270.06	269.98	270.03	1150.0
2018-04-19 07:00:00	SPY	ETF	270.08	270.16	270.03	270.16	6032.0
2018-04-19 07:05:00	SPY	ETF	270.18	270.25	270.18	270.2	4730.0
2018-04-19 07:10:00	SPY	ETF	270.2	270.21	270.18	270.19	800.0
2018-04-19 07:15:00	SPY	ETF	270.22	270.31	270.22	270.28	5573.0
2018-04-19 07:20:00	SPY	ETF	270.21	270.23	270.18	270.23	13543.0
2018-04-19 07:25:00	SPY	ETF	270.24	270.24	270.23	270.23	2030.0
2018-04-19 07:30:00	SPY	ETF	270.29	270.33	270.29	270.3	3400.0
2018-04-19 07:35:00	SPY	ETF	270.3	270.3	270.3	270.3	100.0
2018-04-19 07:40:00	SPY	ETF	270.24	270.27	270.21	270.27	3413.0
2018-04-19 07:45:00	SPY	ETF	270.17	270.17	270.16	270.17	7217.0
2018-04-19 07:50:00	SPY	ETF	270.27	270.28	270.24	270.27	2525.0
2018-04-19 07:55:00	SPY	ETF	270.27	270.29	270.21	270.21	4364.0
2018-04-19 08:00:00	SPY	ETF	270.22	270.81	270.03	270.09	33779.0
2018-04-19 08:05:00	SPY	ETF	270.12	270.12	270.05	270.06	21309.0
2018-04-19 08:10:00	SPY	ETF	270.06	270.06	269.96	269.97	25243.0
2018-04-19 08:15:00	SPY	ETF	269.9601	269.97	269.88	269.92	26338.0
2018-04-19 08:20:00	SPY	ETF	269.92	269.93	269.71	269.71	39867.0
2018-04-19 08:25:00	SPY	ETF	269.71	269.82	269.69	269.74	29384.0
2018-04-19 08:30:00	SPY	ETF	269.8	269.87	269.73	269.84	55418.0
2018-04-19 08:35:00	SPY	ETF	269.85	269.9	269.78	269.78	29599.0
2018-04-19 08:40:00	SPY	ETF	269.79	269.84	269.7	269.84	16380.0
2018-04-19 08:45:00	SPY	ETF	269.85	269.85	269.68	269.82	70029.0

> showing 50 of 57,168 rows — these rows as CSV

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