PREVIEW / etf_5min / 2018-07-19

all etf 5-min files

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

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-07-19 04:00:00	SPY	ETF	280.59	280.59	280.29	280.4	17604.0
2018-07-19 04:10:00	SPY	ETF	280.53	280.53	280.53	280.53	937.0
2018-07-19 04:15:00	SPY	ETF	280.56	280.56	280.56	280.56	400.0
2018-07-19 04:20:00	SPY	ETF	280.48	280.48	280.48	280.48	400.0
2018-07-19 04:25:00	SPY	ETF	280.48	280.52	280.46	280.52	1000.0
2018-07-19 04:30:00	SPY	ETF	280.49	280.49	280.43	280.47	2326.0
2018-07-19 04:35:00	SPY	ETF	280.42	280.52	280.42	280.52	3050.0
2018-07-19 04:40:00	SPY	ETF	280.56	280.57	280.51	280.53	800.0
2018-07-19 04:45:00	SPY	ETF	280.61	280.67	280.61	280.63	8700.0
2018-07-19 04:50:00	SPY	ETF	280.64	280.68	280.64	280.68	1200.0
2018-07-19 04:55:00	SPY	ETF	280.61	280.61	280.59	280.59	6100.0
2018-07-19 05:05:00	SPY	ETF	280.64	280.64	280.59	280.59	2818.0
2018-07-19 05:10:00	SPY	ETF	280.59	280.59	280.55	280.56	1900.0
2018-07-19 05:15:00	SPY	ETF	280.54	280.56	280.48	280.54	4503.0
2018-07-19 05:20:00	SPY	ETF	280.48	280.56	280.48	280.56	3300.0
2018-07-19 05:25:00	SPY	ETF	280.56	280.59	280.56	280.59	1300.0
2018-07-19 05:30:00	SPY	ETF	280.61	280.61	280.53	280.54	12350.0
2018-07-19 05:35:00	SPY	ETF	280.51	280.54	280.5	280.5	1620.0
2018-07-19 05:40:00	SPY	ETF	280.5	280.51	280.48	280.51	500.0
2018-07-19 05:45:00	SPY	ETF	280.47	280.47	280.43	280.46	3000.0
2018-07-19 05:50:00	SPY	ETF	280.43	280.43	280.38	280.38	500.0
2018-07-19 05:55:00	SPY	ETF	280.38	280.41	280.35	280.35	4430.0
2018-07-19 06:00:00	SPY	ETF	280.38	280.41	280.33	280.4	2250.0
2018-07-19 06:05:00	SPY	ETF	280.38	280.38	280.33	280.33	3100.0
2018-07-19 06:10:00	SPY	ETF	280.31	280.35	280.28	280.28	2300.0
2018-07-19 06:15:00	SPY	ETF	280.28	280.28	280.23	280.23	1720.0
2018-07-19 06:20:00	SPY	ETF	280.23	280.23	280.1	280.1	6034.0
2018-07-19 06:25:00	SPY	ETF	280.09	280.11	280.09	280.11	1900.0
2018-07-19 06:30:00	SPY	ETF	280.21	280.21	280.14	280.2	5200.0
2018-07-19 06:35:00	SPY	ETF	280.21	280.24	280.18	280.24	2050.0
2018-07-19 06:40:00	SPY	ETF	280.18	280.18	280.18	280.18	600.0
2018-07-19 06:45:00	SPY	ETF	280.15	280.19	280.14	280.15	7700.0
2018-07-19 06:50:00	SPY	ETF	280.15	280.18	280.12	280.16	17925.0
2018-07-19 06:55:00	SPY	ETF	280.2	280.33	280.17	280.32	14802.0
2018-07-19 07:00:00	SPY	ETF	280.36	280.38	280.33	280.35	8834.0
2018-07-19 07:05:00	SPY	ETF	280.33	280.38	280.29	280.36	20285.0
2018-07-19 07:10:00	SPY	ETF	280.38	280.38	280.32	280.32	14836.0
2018-07-19 07:15:00	SPY	ETF	280.27	280.3	280.19	280.19	24871.0
2018-07-19 07:20:00	SPY	ETF	280.28	280.3	280.25	280.25	7500.0
2018-07-19 07:25:00	SPY	ETF	280.23	280.23	280.16	280.2	3129.0
2018-07-19 07:30:00	SPY	ETF	280.19	280.3	280.18	280.3	15173.0
2018-07-19 07:35:00	SPY	ETF	280.3	280.33	280.28	280.28	12165.0
2018-07-19 07:40:00	SPY	ETF	280.29	280.29	280.21	280.21	19747.0
2018-07-19 07:45:00	SPY	ETF	280.23	280.23	280.18	280.18	11328.0
2018-07-19 07:50:00	SPY	ETF	280.18	280.21	280.17	280.18	23243.0
2018-07-19 07:55:00	SPY	ETF	280.17	280.2	280.15	280.16	47059.0
2018-07-19 08:00:00	SPY	ETF	280.15	280.88	280.07	280.07	83681.0
2018-07-19 08:05:00	SPY	ETF	280.0601	280.12	280.0601	280.11	47521.0
2018-07-19 08:10:00	SPY	ETF	280.07	280.16	280.07	280.14	39011.0
2018-07-19 08:15:00	SPY	ETF	280.17	280.2	280.15	280.15	8923.0

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

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