PREVIEW / etf_5min / 2018-05-24

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-05-24.parquet
  size:    1.3 MB
  rows:    55,024

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-05-24 04:00:00	SPY	ETF	273.36	273.36	273.36	273.36	202.0
2018-05-24 04:10:00	SPY	ETF	273.37	273.37	273.37	273.37	200.0
2018-05-24 04:15:00	SPY	ETF	273.24	273.24	273.22	273.22	1500.0
2018-05-24 04:45:00	SPY	ETF	273.42	273.48	273.42	273.47	9200.0
2018-05-24 04:50:00	SPY	ETF	273.45	273.45	273.37	273.37	2200.0
2018-05-24 04:55:00	SPY	ETF	273.4	273.45	273.37	273.45	2930.0
2018-05-24 05:00:00	SPY	ETF	273.45	273.5	273.42	273.42	5700.0
2018-05-24 05:05:00	SPY	ETF	273.37	273.37	273.37	273.37	820.0
2018-05-24 05:15:00	SPY	ETF	273.3	273.34	273.3	273.34	4400.0
2018-05-24 05:20:00	SPY	ETF	273.3	273.3	273.3	273.3	300.0
2018-05-24 05:25:00	SPY	ETF	273.34	273.34	273.3	273.3	1000.0
2018-05-24 05:30:00	SPY	ETF	273.27	273.29	273.27	273.29	600.0
2018-05-24 05:35:00	SPY	ETF	273.27	273.29	273.27	273.29	1200.0
2018-05-24 05:40:00	SPY	ETF	273.32	273.37	273.32	273.37	2400.0
2018-05-24 05:45:00	SPY	ETF	273.33	273.33	273.29	273.29	5500.0
2018-05-24 05:50:00	SPY	ETF	273.37	273.37	273.34	273.34	800.0
2018-05-24 05:55:00	SPY	ETF	273.42	273.42	273.37	273.37	900.0
2018-05-24 06:00:00	SPY	ETF	273.37	273.37	273.34	273.34	4800.0
2018-05-24 06:10:00	SPY	ETF	273.37	273.37	273.37	273.37	1500.0
2018-05-24 06:20:00	SPY	ETF	273.38	273.38	273.32	273.32	7700.0
2018-05-24 06:25:00	SPY	ETF	273.32	273.43	273.32	273.38	10550.0
2018-05-24 06:30:00	SPY	ETF	273.37	273.4	273.33	273.4	2700.0
2018-05-24 06:35:00	SPY	ETF	273.38	273.39	273.34	273.34	38900.0
2018-05-24 06:40:00	SPY	ETF	273.39	273.39	273.21	273.21	8806.0
2018-05-24 06:45:00	SPY	ETF	273.21	273.24	273.18	273.24	5900.0
2018-05-24 06:50:00	SPY	ETF	273.23	273.33	273.23	273.33	9500.0
2018-05-24 06:55:00	SPY	ETF	273.32	273.35	273.32	273.35	5800.0
2018-05-24 07:00:00	SPY	ETF	273.36	273.36	273.2	273.21	6802.0
2018-05-24 07:05:00	SPY	ETF	273.21	273.21	273.13	273.13	16220.0
2018-05-24 07:10:00	SPY	ETF	273.17	273.17	273.12	273.15	8766.0
2018-05-24 07:15:00	SPY	ETF	273.11	273.13	273.07	273.07	25646.0
2018-05-24 07:20:00	SPY	ETF	273.07	273.11	273.05	273.11	6250.0
2018-05-24 07:25:00	SPY	ETF	273.08	273.1	273.08	273.08	5232.0
2018-05-24 07:30:00	SPY	ETF	273.01	273.04	272.97	273.04	23000.0
2018-05-24 07:35:00	SPY	ETF	273.04	273.04	272.92	272.94	26105.0
2018-05-24 07:40:00	SPY	ETF	272.94	273.03	272.93	273.0	9223.0
2018-05-24 07:45:00	SPY	ETF	272.92	272.95	272.92	272.95	10050.0
2018-05-24 07:50:00	SPY	ETF	273.0	273.05	273.0	273.02	2312.0
2018-05-24 07:55:00	SPY	ETF	273.03	273.03	272.96	272.96	6510.0
2018-05-24 08:00:00	SPY	ETF	273.1801	273.32	272.86	272.86	42104.0
2018-05-24 08:05:00	SPY	ETF	272.86	272.9	272.81	272.9	53694.0
2018-05-24 08:10:00	SPY	ETF	272.9	272.97	272.87	272.96	13532.0
2018-05-24 08:15:00	SPY	ETF	272.98	272.98	272.92	272.92	7200.0
2018-05-24 08:20:00	SPY	ETF	272.92	272.92	272.84	272.84	26175.0
2018-05-24 08:25:00	SPY	ETF	272.81	272.84	272.67	272.75	51924.0
2018-05-24 08:30:00	SPY	ETF	272.74	272.87	272.74	272.82	19305.0
2018-05-24 08:35:00	SPY	ETF	272.88	272.88	272.83	272.83	3764.0
2018-05-24 08:40:00	SPY	ETF	272.83	272.95	272.8	272.94	22569.0
2018-05-24 08:45:00	SPY	ETF	272.91	272.93	272.8	272.83	59745.0
2018-05-24 08:50:00	SPY	ETF	272.8	272.85	272.78	272.83	5235.0

> showing 50 of 55,024 rows — these rows as CSV

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