PREVIEW / etf_5min / 2018-10-16

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-10-16.parquet
  size:    1.5 MB
  rows:    62,360

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-10-16 04:00:00	SPY	ETF	275.01	275.18	274.95	275.18	7400.0
2018-10-16 04:05:00	SPY	ETF	275.19	275.28	275.19	275.25	4600.0
2018-10-16 04:10:00	SPY	ETF	275.31	275.32	275.29	275.29	3600.0
2018-10-16 04:15:00	SPY	ETF	275.26	275.38	275.24	275.38	6065.0
2018-10-16 04:20:00	SPY	ETF	275.4	275.4	275.27	275.35	3250.0
2018-10-16 04:25:00	SPY	ETF	275.26	275.45	275.26	275.45	2300.0
2018-10-16 04:30:00	SPY	ETF	275.26	275.26	275.14	275.17	4660.0
2018-10-16 04:35:00	SPY	ETF	275.14	275.14	275.11	275.11	4745.0
2018-10-16 04:40:00	SPY	ETF	275.11	275.11	275.11	275.11	300.0
2018-10-16 04:45:00	SPY	ETF	275.02	275.06	275.02	275.06	1000.0
2018-10-16 04:50:00	SPY	ETF	275.18	275.26	275.1	275.1	800.0
2018-10-16 04:55:00	SPY	ETF	275.13	275.13	275.0	275.02	3200.0
2018-10-16 05:00:00	SPY	ETF	274.98	274.98	274.96	274.96	500.0
2018-10-16 05:05:00	SPY	ETF	275.01	275.01	275.01	275.01	500.0
2018-10-16 05:10:00	SPY	ETF	274.93	274.93	274.88	274.88	600.0
2018-10-16 05:15:00	SPY	ETF	274.88	275.01	274.88	274.98	2650.0
2018-10-16 05:20:00	SPY	ETF	274.98	274.98	274.86	274.86	2340.0
2018-10-16 05:25:00	SPY	ETF	274.88	274.91	274.84	274.84	3686.0
2018-10-16 05:35:00	SPY	ETF	274.78	274.78	274.78	274.78	1000.0
2018-10-16 05:40:00	SPY	ETF	274.91	275.01	274.91	275.01	2600.0
2018-10-16 05:45:00	SPY	ETF	275.05	275.06	275.03	275.06	1100.0
2018-10-16 05:50:00	SPY	ETF	275.1	275.1	275.1	275.1	1300.0
2018-10-16 05:55:00	SPY	ETF	275.13	275.13	275.13	275.13	100.0
2018-10-16 06:00:00	SPY	ETF	275.17	275.2	275.12	275.12	3600.0
2018-10-16 06:05:00	SPY	ETF	275.05	275.05	275.04	275.04	200.0
2018-10-16 06:10:00	SPY	ETF	275.04	275.04	275.03	275.03	1500.0
2018-10-16 06:15:00	SPY	ETF	274.99	275.12	274.99	275.12	3345.0
2018-10-16 06:20:00	SPY	ETF	275.16	275.38	275.16	275.37	4175.0
2018-10-16 06:25:00	SPY	ETF	275.39	275.42	275.37	275.4	1750.0
2018-10-16 06:30:00	SPY	ETF	275.38	275.46	275.35	275.44	7400.0
2018-10-16 06:35:00	SPY	ETF	275.38	275.38	275.38	275.38	100.0
2018-10-16 06:40:00	SPY	ETF	275.4	275.5	275.4	275.43	5676.0
2018-10-16 06:45:00	SPY	ETF	275.32	275.36	275.29	275.32	14700.0
2018-10-16 06:50:00	SPY	ETF	275.4	275.4	275.4	275.4	2050.0
2018-10-16 06:55:00	SPY	ETF	275.42	275.42	275.26	275.26	9620.0
2018-10-16 07:00:00	SPY	ETF	275.28	275.29	275.2	275.2	26856.0
2018-10-16 07:05:00	SPY	ETF	275.19	275.3	275.18	275.27	48680.0
2018-10-16 07:10:00	SPY	ETF	275.27	275.35	275.27	275.33	26802.0
2018-10-16 07:15:00	SPY	ETF	275.33	275.58	275.33	275.52	42160.0
2018-10-16 07:20:00	SPY	ETF	275.55	275.55	275.51	275.53	10400.0
2018-10-16 07:25:00	SPY	ETF	275.52	275.54	275.48	275.48	38811.0
2018-10-16 07:30:00	SPY	ETF	275.48	275.57	275.48	275.52	18400.0
2018-10-16 07:35:00	SPY	ETF	275.53	275.6	275.43	275.43	40157.0
2018-10-16 07:40:00	SPY	ETF	275.46	275.59	275.46	275.59	23047.0
2018-10-16 07:45:00	SPY	ETF	275.59	275.59	275.48	275.53	27049.0
2018-10-16 07:50:00	SPY	ETF	275.53	275.53	275.46	275.5	20208.0
2018-10-16 07:55:00	SPY	ETF	275.58	275.67	275.58	275.64	16050.0
2018-10-16 08:00:00	SPY	ETF	275.6	275.66	274.71	275.58	38694.0
2018-10-16 08:05:00	SPY	ETF	275.6	275.79	275.6	275.74	44716.0
2018-10-16 08:10:00	SPY	ETF	275.74	276.02	275.73	276.01	119841.0

> showing 50 of 62,360 rows — these rows as CSV

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