PREVIEW / etf_5min / 2018-01-10

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-01-10.parquet
  size:    1.4 MB
  rows:    62,608

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-01-10 04:00:00	SPY	ETF	273.99	273.99	273.84	273.84	3292.0
2018-01-10 04:05:00	SPY	ETF	273.86	273.86	273.86	273.86	900.0
2018-01-10 04:15:00	SPY	ETF	274.06	274.06	274.06	274.06	910.0
2018-01-10 04:20:00	SPY	ETF	274.03	274.03	274.03	274.03	500.0
2018-01-10 04:25:00	SPY	ETF	274.06	274.13	274.01	274.13	3300.0
2018-01-10 04:30:00	SPY	ETF	273.97	274.02	273.97	274.02	1100.0
2018-01-10 04:35:00	SPY	ETF	274.02	274.03	274.0	274.0	17900.0
2018-01-10 04:40:00	SPY	ETF	274.03	274.05	273.93	273.93	11300.0
2018-01-10 04:45:00	SPY	ETF	273.9	273.98	273.88	273.98	8750.0
2018-01-10 04:50:00	SPY	ETF	273.98	273.98	273.98	273.98	400.0
2018-01-10 04:55:00	SPY	ETF	273.98	273.98	273.95	273.98	1900.0
2018-01-10 05:00:00	SPY	ETF	273.95	274.02	273.95	274.01	1697.0
2018-01-10 05:05:00	SPY	ETF	274.01	274.01	273.96	273.96	3102.0
2018-01-10 05:15:00	SPY	ETF	273.96	273.96	273.96	273.96	2001.0
2018-01-10 05:20:00	SPY	ETF	274.03	274.03	273.97	273.97	6604.0
2018-01-10 05:25:00	SPY	ETF	273.98	273.98	273.73	273.73	19433.0
2018-01-10 05:30:00	SPY	ETF	273.73	273.76	273.49	273.54	22206.0
2018-01-10 05:35:00	SPY	ETF	273.56	273.57	273.36	273.36	29477.0
2018-01-10 05:40:00	SPY	ETF	273.33	273.37	273.3	273.37	12909.0
2018-01-10 05:45:00	SPY	ETF	273.37	273.37	273.12	273.12	11264.0
2018-01-10 05:50:00	SPY	ETF	273.12	273.34	273.02	273.29	16947.0
2018-01-10 05:55:00	SPY	ETF	273.32	273.32	273.04	273.07	10839.0
2018-01-10 06:00:00	SPY	ETF	273.09	273.32	273.09	273.32	26360.0
2018-01-10 06:05:00	SPY	ETF	273.37	273.42	273.31	273.34	7463.0
2018-01-10 06:10:00	SPY	ETF	273.34	273.5	273.32	273.47	15366.0
2018-01-10 06:15:00	SPY	ETF	273.49	273.54	273.49	273.54	3672.0
2018-01-10 06:20:00	SPY	ETF	273.54	273.54	273.33	273.49	10834.0
2018-01-10 06:25:00	SPY	ETF	273.49	273.49	273.47	273.47	1100.0
2018-01-10 06:30:00	SPY	ETF	273.47	273.48	273.43	273.48	1703.0
2018-01-10 06:35:00	SPY	ETF	273.47	273.49	273.32	273.4	46027.0
2018-01-10 06:40:00	SPY	ETF	273.4	273.45	273.4	273.45	38551.0
2018-01-10 06:45:00	SPY	ETF	273.48	273.48	273.45	273.48	1400.0
2018-01-10 06:50:00	SPY	ETF	273.45	273.45	273.34	273.34	3246.0
2018-01-10 06:55:00	SPY	ETF	273.4	273.4	273.3	273.3	52804.0
2018-01-10 07:00:00	SPY	ETF	273.3	273.33	273.2	273.21	102189.0
2018-01-10 07:05:00	SPY	ETF	273.21	273.24	273.14	273.14	94782.0
2018-01-10 07:10:00	SPY	ETF	273.14	273.28	273.14	273.28	84898.0
2018-01-10 07:15:00	SPY	ETF	273.32	273.52	273.32	273.51	113310.0
2018-01-10 07:20:00	SPY	ETF	273.52	273.54	273.49	273.52	127849.0
2018-01-10 07:25:00	SPY	ETF	273.5	273.61	273.5	273.61	25681.0
2018-01-10 07:30:00	SPY	ETF	273.6	273.64	273.59	273.6	20972.0
2018-01-10 07:35:00	SPY	ETF	273.54	273.6	273.54	273.55	4971.0
2018-01-10 07:40:00	SPY	ETF	273.57	273.59	273.52	273.56	81832.0
2018-01-10 07:45:00	SPY	ETF	273.56	273.57	273.46	273.5	125305.0
2018-01-10 07:50:00	SPY	ETF	273.5	273.53	273.4	273.4	47575.0
2018-01-10 07:55:00	SPY	ETF	273.4	273.45	273.36	273.36	25829.0
2018-01-10 08:00:00	SPY	ETF	273.31	273.63	273.23	273.36	35510.0
2018-01-10 08:05:00	SPY	ETF	273.35	273.36	273.3	273.35	20792.0
2018-01-10 08:10:00	SPY	ETF	273.34	273.49	273.34	273.49	35543.0
2018-01-10 08:15:00	SPY	ETF	273.49	273.57	273.47	273.54	43616.0

> showing 50 of 62,608 rows — these rows as CSV

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