PREVIEW / etf_5min / 2018-06-25

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-06-25.parquet
  size:    1.4 MB
  rows:    61,011

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-06-25 04:00:00	SPY	ETF	273.5	273.79	273.5	273.69	15844.0
2018-06-25 04:05:00	SPY	ETF	273.62	273.66	273.62	273.66	3100.0
2018-06-25 04:10:00	SPY	ETF	273.52	273.61	273.52	273.61	3400.0
2018-06-25 04:15:00	SPY	ETF	273.5	273.54	273.42	273.42	3165.0
2018-06-25 04:20:00	SPY	ETF	273.49	273.49	273.42	273.47	2635.0
2018-06-25 04:25:00	SPY	ETF	273.5	273.5	273.39	273.39	4600.0
2018-06-25 04:30:00	SPY	ETF	273.38	273.38	273.38	273.38	140.0
2018-06-25 04:35:00	SPY	ETF	273.37	273.56	273.37	273.56	3215.0
2018-06-25 04:40:00	SPY	ETF	273.42	273.42	273.42	273.42	400.0
2018-06-25 04:45:00	SPY	ETF	273.35	273.36	273.31	273.36	1360.0
2018-06-25 04:50:00	SPY	ETF	273.3	273.3	273.25	273.25	1992.0
2018-06-25 04:55:00	SPY	ETF	273.24	273.26	273.19	273.19	1750.0
2018-06-25 05:00:00	SPY	ETF	273.25	273.27	273.21	273.21	2300.0
2018-06-25 05:05:00	SPY	ETF	273.23	273.28	273.2	273.2	3750.0
2018-06-25 05:10:00	SPY	ETF	273.21	273.28	273.2	273.28	2150.0
2018-06-25 05:15:00	SPY	ETF	273.22	273.22	273.17	273.17	4600.0
2018-06-25 05:20:00	SPY	ETF	273.16	273.21	273.1	273.17	4860.0
2018-06-25 05:25:00	SPY	ETF	273.2	273.32	273.2	273.32	600.0
2018-06-25 05:30:00	SPY	ETF	273.3	273.3	273.3	273.3	1000.0
2018-06-25 05:35:00	SPY	ETF	273.25	273.39	273.25	273.39	2700.0
2018-06-25 05:40:00	SPY	ETF	273.39	273.41	273.39	273.4	800.0
2018-06-25 05:45:00	SPY	ETF	273.35	273.38	273.35	273.35	3900.0
2018-06-25 05:50:00	SPY	ETF	273.32	273.36	273.3	273.36	2200.0
2018-06-25 05:55:00	SPY	ETF	273.36	273.4	273.36	273.36	3500.0
2018-06-25 06:00:00	SPY	ETF	273.42	273.5	273.42	273.5	3533.0
2018-06-25 06:05:00	SPY	ETF	273.43	273.43	273.36	273.36	21575.0
2018-06-25 06:10:00	SPY	ETF	273.27	273.28	272.95	273.12	43008.0
2018-06-25 06:15:00	SPY	ETF	273.14	273.14	273.08	273.08	4030.0
2018-06-25 06:20:00	SPY	ETF	273.15	273.15	273.07	273.12	2820.0
2018-06-25 06:25:00	SPY	ETF	273.12	273.12	273.01	273.12	22539.0
2018-06-25 06:30:00	SPY	ETF	273.16	273.16	273.02	273.02	2075.0
2018-06-25 06:35:00	SPY	ETF	272.95	273.13	272.95	273.06	29087.0
2018-06-25 06:40:00	SPY	ETF	273.05	273.12	272.93	273.05	23670.0
2018-06-25 06:45:00	SPY	ETF	273.01	273.25	273.01	273.24	36120.0
2018-06-25 06:50:00	SPY	ETF	273.19	273.3	273.19	273.3	7850.0
2018-06-25 06:55:00	SPY	ETF	273.31	273.31	273.23	273.3	13300.0
2018-06-25 07:00:00	SPY	ETF	273.27	273.31	273.21	273.24	14864.0
2018-06-25 07:05:00	SPY	ETF	273.25	273.5	273.24	273.49	5644.0
2018-06-25 07:10:00	SPY	ETF	273.47	273.6	273.47	273.58	25109.0
2018-06-25 07:15:00	SPY	ETF	273.62	273.63	273.49	273.49	17379.0
2018-06-25 07:20:00	SPY	ETF	273.47	273.47	273.35	273.35	14301.0
2018-06-25 07:25:00	SPY	ETF	273.35	273.41	273.33	273.39	52227.0
2018-06-25 07:30:00	SPY	ETF	273.38	273.54	273.38	273.5	3380.0
2018-06-25 07:35:00	SPY	ETF	273.48	273.48	273.38	273.38	3826.0
2018-06-25 07:40:00	SPY	ETF	273.39	273.54	273.35	273.525	89441.0
2018-06-25 07:45:00	SPY	ETF	273.52	273.58	273.51	273.56	25055.0
2018-06-25 07:50:00	SPY	ETF	273.56	273.58	273.55	273.57	4219.0
2018-06-25 07:55:00	SPY	ETF	273.55	273.61	273.55	273.6	23142.0
2018-06-25 08:00:00	SPY	ETF	273.6	273.74	273.2	273.53	82726.0
2018-06-25 08:05:00	SPY	ETF	273.53	273.64	273.5	273.61	21461.0

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

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