PREVIEW / etf_5min / 2019-12-31

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-12-31.parquet
  size:    1.5 MB
  rows:    65,227

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-12-31 04:05:00	SPY	ETF	321.42	321.42	321.42	321.42	100.0
2019-12-31 04:15:00	SPY	ETF	321.42	321.42	321.42	321.42	890.0
2019-12-31 04:20:00	SPY	ETF	321.41	321.43	321.4	321.43	3060.0
2019-12-31 04:35:00	SPY	ETF	321.44	321.44	321.42	321.42	600.0
2019-12-31 04:40:00	SPY	ETF	321.37	321.37	321.37	321.37	1000.0
2019-12-31 04:55:00	SPY	ETF	321.39	321.4	321.39	321.4	900.0
2019-12-31 05:00:00	SPY	ETF	321.4	321.46	321.35	321.46	1700.0
2019-12-31 05:15:00	SPY	ETF	321.51	321.51	321.51	321.51	315.0
2019-12-31 05:20:00	SPY	ETF	321.51	321.51	321.51	321.51	100.0
2019-12-31 05:30:00	SPY	ETF	321.6	321.6	321.6	321.6	500.0
2019-12-31 05:35:00	SPY	ETF	321.65	321.65	321.65	321.65	300.0
2019-12-31 05:40:00	SPY	ETF	321.65	321.65	321.63	321.63	400.0
2019-12-31 05:45:00	SPY	ETF	321.56	321.6	321.56	321.6	800.0
2019-12-31 06:05:00	SPY	ETF	321.6	321.6	321.6	321.6	300.0
2019-12-31 06:15:00	SPY	ETF	321.48	321.48	321.43	321.43	1301.0
2019-12-31 06:20:00	SPY	ETF	321.41	321.41	321.34	321.34	1000.0
2019-12-31 06:30:00	SPY	ETF	321.39	321.39	321.39	321.39	130.0
2019-12-31 06:35:00	SPY	ETF	321.39	321.39	321.39	321.39	226.0
2019-12-31 06:40:00	SPY	ETF	321.36	321.36	321.36	321.36	100.0
2019-12-31 06:45:00	SPY	ETF	321.36	321.37	321.31	321.31	2898.0
2019-12-31 06:50:00	SPY	ETF	321.35	321.35	321.29	321.29	700.0
2019-12-31 06:55:00	SPY	ETF	321.2	321.23	321.2	321.23	1100.0
2019-12-31 07:00:00	SPY	ETF	321.3	321.3	321.26	321.27	14429.0
2019-12-31 07:05:00	SPY	ETF	321.26	321.26	321.0	321.0	9236.0
2019-12-31 07:10:00	SPY	ETF	321.03	321.08	321.03	321.05	3750.0
2019-12-31 07:15:00	SPY	ETF	321.0	321.01	320.9	320.97	11621.0
2019-12-31 07:20:00	SPY	ETF	320.97	320.98	320.93	320.98	5505.0
2019-12-31 07:25:00	SPY	ETF	321.0	321.06	321.0	321.06	6900.0
2019-12-31 07:30:00	SPY	ETF	321.11	321.15	321.09	321.15	7820.0
2019-12-31 07:35:00	SPY	ETF	321.11	321.11	321.03	321.03	8610.0
2019-12-31 07:40:00	SPY	ETF	321.03	321.03	321.0	321.01	34735.0
2019-12-31 07:45:00	SPY	ETF	321.01	321.01	321.0	321.0	26990.0
2019-12-31 07:50:00	SPY	ETF	320.93	320.94	320.86	320.94	14192.0
2019-12-31 07:55:00	SPY	ETF	320.95	320.97	320.9	320.9	15441.0
2019-12-31 08:00:00	SPY	ETF	320.9	321.39	320.8	321.1	53453.0
2019-12-31 08:05:00	SPY	ETF	321.11	321.25	321.11	321.25	3441.0
2019-12-31 08:10:00	SPY	ETF	321.25	321.25	321.14	321.14	4879.0
2019-12-31 08:15:00	SPY	ETF	321.16	321.16	321.01	321.12	18100.0
2019-12-31 08:20:00	SPY	ETF	321.12	321.12	321.06	321.06	852.0
2019-12-31 08:25:00	SPY	ETF	321.08	321.16	321.08	321.1	7381.0
2019-12-31 08:30:00	SPY	ETF	321.11	321.11	321.0	321.0	13651.0
2019-12-31 08:35:00	SPY	ETF	321.04	321.04	320.94	320.99	14664.0
2019-12-31 08:40:00	SPY	ETF	320.97	320.97	320.9	320.9	25738.0
2019-12-31 08:45:00	SPY	ETF	320.87	320.9	320.62	320.72	25902.0
2019-12-31 08:50:00	SPY	ETF	320.7201	320.75	320.55	320.73	35394.0
2019-12-31 08:55:00	SPY	ETF	320.66	320.7	320.55	320.59	22015.0
2019-12-31 09:00:00	SPY	ETF	320.61	320.65	320.49	320.59	21990.0
2019-12-31 09:05:00	SPY	ETF	320.6	320.62	320.54	320.58	4812.0
2019-12-31 09:10:00	SPY	ETF	320.57	320.67	320.57	320.58	21676.0
2019-12-31 09:15:00	SPY	ETF	320.58	320.66	320.5	320.52	116481.0

> showing 50 of 65,227 rows — these rows as CSV

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