PREVIEW / etf_5min / 2020-01-22

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-01-22.parquet
  size:    1.6 MB
  rows:    66,947

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
2020-01-22 04:00:00	SPY	ETF	332.32	332.39	332.13	332.38	133153.0
2020-01-22 04:05:00	SPY	ETF	332.44	332.44	332.4	332.41	2735.0
2020-01-22 04:10:00	SPY	ETF	332.45	332.45	332.4	332.4	2100.0
2020-01-22 04:15:00	SPY	ETF	332.2	332.2	332.15	332.15	330.0
2020-01-22 04:20:00	SPY	ETF	332.32	332.32	332.32	332.32	100.0
2020-01-22 04:30:00	SPY	ETF	332.18	332.19	332.17	332.19	2101.0
2020-01-22 04:35:00	SPY	ETF	332.25	332.25	332.23	332.23	600.0
2020-01-22 04:40:00	SPY	ETF	332.21	332.28	332.21	332.27	4132.0
2020-01-22 04:45:00	SPY	ETF	332.24	332.24	332.24	332.24	377.0
2020-01-22 04:50:00	SPY	ETF	332.36	332.37	332.34	332.37	803.0
2020-01-22 04:55:00	SPY	ETF	332.4	332.4	332.32	332.32	801.0
2020-01-22 05:00:00	SPY	ETF	332.3	332.3	332.3	332.3	360.0
2020-01-22 05:10:00	SPY	ETF	332.36	332.4	332.3	332.34	2400.0
2020-01-22 05:15:00	SPY	ETF	332.34	332.34	332.29	332.31	2667.0
2020-01-22 05:20:00	SPY	ETF	332.34	332.36	332.34	332.36	1410.0
2020-01-22 05:25:00	SPY	ETF	332.37	332.4	332.36	332.36	2400.0
2020-01-22 05:30:00	SPY	ETF	332.38	332.4	332.38	332.4	1600.0
2020-01-22 05:35:00	SPY	ETF	332.4	332.45	332.4	332.44	964.0
2020-01-22 05:40:00	SPY	ETF	332.37	332.37	332.37	332.37	495.0
2020-01-22 05:45:00	SPY	ETF	332.35	332.35	332.34	332.34	230.0
2020-01-22 05:50:00	SPY	ETF	332.37	332.37	332.37	332.37	174.0
2020-01-22 05:55:00	SPY	ETF	332.35	332.39	332.35	332.39	4100.0
2020-01-22 06:00:00	SPY	ETF	332.39	332.4	332.33	332.35	1928.0
2020-01-22 06:05:00	SPY	ETF	332.35	332.37	332.35	332.37	500.0
2020-01-22 06:10:00	SPY	ETF	332.32	332.34	332.25	332.34	3631.0
2020-01-22 06:15:00	SPY	ETF	332.37	332.39	332.35	332.39	1505.0
2020-01-22 06:20:00	SPY	ETF	332.39	332.39	332.3	332.3	850.0
2020-01-22 06:25:00	SPY	ETF	332.34	332.34	332.34	332.34	754.0
2020-01-22 06:30:00	SPY	ETF	332.25	332.33	332.25	332.33	1510.0
2020-01-22 06:35:00	SPY	ETF	332.34	332.41	332.34	332.4	6161.0
2020-01-22 06:45:00	SPY	ETF	332.42	332.42	332.39	332.39	291.0
2020-01-22 06:50:00	SPY	ETF	332.44	332.47	332.43	332.45	12450.0
2020-01-22 06:55:00	SPY	ETF	332.48	332.52	332.45	332.45	6913.0
2020-01-22 07:00:00	SPY	ETF	332.44	332.52	332.4	332.51	4598.0
2020-01-22 07:05:00	SPY	ETF	332.48	332.51	332.48	332.51	6184.0
2020-01-22 07:10:00	SPY	ETF	332.5	332.54	332.47	332.54	4400.0
2020-01-22 07:15:00	SPY	ETF	332.54	332.55	332.47	332.51	28353.0
2020-01-22 07:20:00	SPY	ETF	332.45	332.46	332.45	332.45	2830.0
2020-01-22 07:25:00	SPY	ETF	332.47	332.54	332.47	332.54	2706.0
2020-01-22 07:30:00	SPY	ETF	332.53	332.64	332.53	332.64	5944.0
2020-01-22 07:35:00	SPY	ETF	332.63	332.65	332.6	332.62	9985.0
2020-01-22 07:40:00	SPY	ETF	332.63	332.64	332.53	332.53	6374.0
2020-01-22 07:45:00	SPY	ETF	332.53	332.63	332.53	332.63	1520.0
2020-01-22 07:50:00	SPY	ETF	332.65	332.66	332.6	332.6	7109.0
2020-01-22 07:55:00	SPY	ETF	332.52	332.52	332.42	332.42	9421.0
2020-01-22 08:00:00	SPY	ETF	332.43	332.7	332.4	332.41	18361.0
2020-01-22 08:05:00	SPY	ETF	332.46	332.52	332.4201	332.52	23859.0
2020-01-22 08:10:00	SPY	ETF	332.5	332.51	332.42	332.44	8518.0
2020-01-22 08:15:00	SPY	ETF	332.43	332.49	332.43	332.48	4594.0
2020-01-22 08:20:00	SPY	ETF	332.45	332.48	332.35	332.35	22039.0

> showing 50 of 66,947 rows — these rows as CSV

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