PREVIEW / etf_5min / 2018-02-20

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-02-20.parquet
  size:    1.4 MB
  rows:    61,726

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-02-20 04:00:00	SPY	ETF	272.54	272.58	272.2	272.21	3110.0
2018-02-20 04:05:00	SPY	ETF	272.26	272.26	272.26	272.26	200.0
2018-02-20 04:10:00	SPY	ETF	272.29	272.35	272.29	272.29	3426.0
2018-02-20 04:15:00	SPY	ETF	272.02	272.19	272.0	272.19	3353.0
2018-02-20 04:20:00	SPY	ETF	272.06	272.06	272.05	272.05	2321.0
2018-02-20 04:25:00	SPY	ETF	272.03	272.03	271.92	271.97	1911.0
2018-02-20 04:30:00	SPY	ETF	271.95	271.95	271.89	271.89	1405.0
2018-02-20 04:35:00	SPY	ETF	271.88	271.91	271.7	271.7	7737.0
2018-02-20 04:40:00	SPY	ETF	271.69	271.69	271.33	271.41	15287.0
2018-02-20 04:45:00	SPY	ETF	271.44	271.55	271.41	271.54	863.0
2018-02-20 04:50:00	SPY	ETF	271.61	271.61	271.23	271.23	1608.0
2018-02-20 04:55:00	SPY	ETF	271.41	271.43	271.18	271.23	5484.0
2018-02-20 05:00:00	SPY	ETF	271.26	271.34	271.04	271.04	2161.0
2018-02-20 05:05:00	SPY	ETF	271.02	271.16	270.86	271.06	10150.0
2018-02-20 05:10:00	SPY	ETF	271.11	271.22	271.11	271.14	5137.0
2018-02-20 05:15:00	SPY	ETF	271.21	271.21	271.17	271.17	617.0
2018-02-20 05:20:00	SPY	ETF	271.2	271.34	271.2	271.34	4716.0
2018-02-20 05:30:00	SPY	ETF	271.44	271.44	271.42	271.42	859.0
2018-02-20 05:35:00	SPY	ETF	271.45	271.45	271.32	271.32	567.0
2018-02-20 05:40:00	SPY	ETF	271.32	271.42	271.32	271.42	3058.0
2018-02-20 05:45:00	SPY	ETF	271.53	271.67	271.53	271.53	1689.0
2018-02-20 05:50:00	SPY	ETF	271.63	271.68	271.63	271.65	6635.0
2018-02-20 05:55:00	SPY	ETF	271.7	271.7	271.7	271.7	500.0
2018-02-20 06:00:00	SPY	ETF	271.66	271.66	271.5	271.51	6593.0
2018-02-20 06:05:00	SPY	ETF	271.5	271.5	271.35	271.35	1601.0
2018-02-20 06:10:00	SPY	ETF	271.48	271.48	271.47	271.47	1101.0
2018-02-20 06:15:00	SPY	ETF	271.56	271.61	271.54	271.58	1681.0
2018-02-20 06:20:00	SPY	ETF	271.48	271.48	271.2	271.26	7072.0
2018-02-20 06:25:00	SPY	ETF	271.23	271.23	271.1	271.17	23114.0
2018-02-20 06:30:00	SPY	ETF	271.2	271.34	271.11	271.29	2738.0
2018-02-20 06:35:00	SPY	ETF	271.28	271.45	271.28	271.45	5968.0
2018-02-20 06:40:00	SPY	ETF	271.48	271.58	271.48	271.58	703.0
2018-02-20 06:45:00	SPY	ETF	271.6	271.6	271.51	271.51	2394.0
2018-02-20 06:50:00	SPY	ETF	271.5	271.5	271.48	271.48	1100.0
2018-02-20 06:55:00	SPY	ETF	271.49	271.51	271.4	271.51	3739.0
2018-02-20 07:00:00	SPY	ETF	271.58	271.77	271.58	271.76	16032.0
2018-02-20 07:05:00	SPY	ETF	271.75	271.84	271.69	271.69	13937.0
2018-02-20 07:10:00	SPY	ETF	271.77	271.89	271.77	271.87	5926.0
2018-02-20 07:15:00	SPY	ETF	271.81	271.81	271.67	271.74	4868.0
2018-02-20 07:20:00	SPY	ETF	271.77	271.77	271.59	271.63	39790.0
2018-02-20 07:25:00	SPY	ETF	271.6	271.68	271.51	271.6	6268.0
2018-02-20 07:30:00	SPY	ETF	271.66	271.73	271.6	271.6	18928.0
2018-02-20 07:35:00	SPY	ETF	271.71	271.74	271.68	271.7	7637.0
2018-02-20 07:40:00	SPY	ETF	271.7	271.79	271.69	271.79	14809.0
2018-02-20 07:45:00	SPY	ETF	271.8	271.91	271.8	271.88	34621.0
2018-02-20 07:50:00	SPY	ETF	271.85	271.9	271.85	271.9	43982.0
2018-02-20 07:55:00	SPY	ETF	271.9	271.92	271.86	271.86	12517.0
2018-02-20 08:00:00	SPY	ETF	271.86	272.81	271.32	271.66	138911.0
2018-02-20 08:05:00	SPY	ETF	271.66	271.73	271.64	271.7	32140.0
2018-02-20 08:10:00	SPY	ETF	271.72	271.76	271.6	271.6	52023.0

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

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