PREVIEW / etf_5min / 2019-02-27

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-02-27.parquet
  size:    1.4 MB
  rows:    61,729

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
2019-02-27 04:00:00	SPY	ETF	278.1	278.22	278.01	278.22	4949.0
2019-02-27 04:10:00	SPY	ETF	278.14	278.14	278.14	278.14	905.0
2019-02-27 04:15:00	SPY	ETF	278.17	278.17	278.17	278.17	1000.0
2019-02-27 04:20:00	SPY	ETF	278.21	278.21	278.21	278.21	1000.0
2019-02-27 04:30:00	SPY	ETF	278.28	278.28	278.17	278.17	655.0
2019-02-27 04:35:00	SPY	ETF	278.27	278.27	278.2	278.2	420.0
2019-02-27 04:45:00	SPY	ETF	278.15	278.15	278.15	278.15	100.0
2019-02-27 04:55:00	SPY	ETF	278.27	278.27	278.27	278.27	100.0
2019-02-27 05:00:00	SPY	ETF	278.22	278.22	278.17	278.17	820.0
2019-02-27 05:10:00	SPY	ETF	278.31	278.31	278.31	278.31	1500.0
2019-02-27 05:20:00	SPY	ETF	278.24	278.24	278.24	278.24	250.0
2019-02-27 05:35:00	SPY	ETF	278.35	278.38	278.35	278.38	200.0
2019-02-27 05:40:00	SPY	ETF	278.45	278.49	278.45	278.47	957.0
2019-02-27 05:45:00	SPY	ETF	278.47	278.49	278.47	278.49	1450.0
2019-02-27 05:50:00	SPY	ETF	278.52	278.52	278.5	278.5	800.0
2019-02-27 05:55:00	SPY	ETF	278.5	278.5	278.45	278.45	2850.0
2019-02-27 06:00:00	SPY	ETF	278.49	278.52	278.48	278.48	701.0
2019-02-27 06:05:00	SPY	ETF	278.49	278.49	278.49	278.49	100.0
2019-02-27 06:10:00	SPY	ETF	278.45	278.45	278.41	278.41	2325.0
2019-02-27 06:15:00	SPY	ETF	278.5	278.52	278.5	278.52	1669.0
2019-02-27 06:20:00	SPY	ETF	278.55	278.55	278.52	278.55	4838.0
2019-02-27 06:25:00	SPY	ETF	278.5	278.5	278.43	278.43	988.0
2019-02-27 06:30:00	SPY	ETF	278.52	278.52	278.52	278.52	200.0
2019-02-27 06:40:00	SPY	ETF	278.57	278.57	278.52	278.52	2201.0
2019-02-27 06:45:00	SPY	ETF	278.45	278.5	278.45	278.5	11600.0
2019-02-27 06:50:00	SPY	ETF	278.48	278.51	278.48	278.51	10565.0
2019-02-27 06:55:00	SPY	ETF	278.48	278.48	278.48	278.48	400.0
2019-02-27 07:00:00	SPY	ETF	278.48	278.64	278.44	278.63	53085.0
2019-02-27 07:05:00	SPY	ETF	278.58	278.62	278.58	278.61	14701.0
2019-02-27 07:10:00	SPY	ETF	278.56	278.57	278.54	278.57	944.0
2019-02-27 07:15:00	SPY	ETF	278.6	278.6	278.54	278.57	2451.0
2019-02-27 07:20:00	SPY	ETF	278.55	278.6	278.52	278.6	3919.0
2019-02-27 07:25:00	SPY	ETF	278.6	278.62	278.58	278.6	12642.0
2019-02-27 07:30:00	SPY	ETF	278.58	278.67	278.58	278.67	1524.0
2019-02-27 07:35:00	SPY	ETF	278.67	278.71	278.66	278.66	36406.0
2019-02-27 07:40:00	SPY	ETF	278.64	278.66	278.64	278.66	1402.0
2019-02-27 07:45:00	SPY	ETF	278.66	278.7	278.65	278.65	1689.0
2019-02-27 07:50:00	SPY	ETF	278.64	278.65	278.6	278.6	1105.0
2019-02-27 07:55:00	SPY	ETF	278.6	278.61	278.6	278.6	2676.0
2019-02-27 08:00:00	SPY	ETF	278.6	279.22	278.23	278.47	43181.0
2019-02-27 08:05:00	SPY	ETF	278.5	278.52	278.49	278.5	9108.0
2019-02-27 08:10:00	SPY	ETF	278.5	278.58	278.47	278.55	18251.0
2019-02-27 08:15:00	SPY	ETF	278.54	278.63	278.54	278.6	10635.0
2019-02-27 08:20:00	SPY	ETF	278.5999	278.62	278.47	278.47	13764.0
2019-02-27 08:25:00	SPY	ETF	278.49	278.54	278.44	278.54	4642.0
2019-02-27 08:30:00	SPY	ETF	278.54	278.56	278.52	278.55	17647.0
2019-02-27 08:35:00	SPY	ETF	278.59	278.72	278.59	278.72	13875.0
2019-02-27 08:40:00	SPY	ETF	278.7	278.7	278.59	278.61	17769.0
2019-02-27 08:45:00	SPY	ETF	278.65	278.68	278.63	278.64	13999.0
2019-02-27 08:50:00	SPY	ETF	278.62	278.6299	278.51	278.52	21004.0

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

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