PREVIEW / etf_5min / 2019-07-22

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-07-22.parquet
  size:    1.4 MB
  rows:    60,245

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-07-22 04:00:00	SPY	ETF	297.12	297.36	297.06	297.32	8593.0
2019-07-22 04:05:00	SPY	ETF	297.34	297.37	297.34	297.37	400.0
2019-07-22 04:10:00	SPY	ETF	297.37	297.45	297.37	297.45	2567.0
2019-07-22 04:15:00	SPY	ETF	297.39	297.65	297.39	297.65	5865.0
2019-07-22 04:20:00	SPY	ETF	297.66	297.69	297.65	297.69	1090.0
2019-07-22 04:25:00	SPY	ETF	297.59	297.59	297.59	297.59	400.0
2019-07-22 04:30:00	SPY	ETF	297.64	297.64	297.64	297.64	900.0
2019-07-22 04:40:00	SPY	ETF	297.66	297.74	297.66	297.74	4015.0
2019-07-22 04:45:00	SPY	ETF	297.71	297.73	297.69	297.71	2500.0
2019-07-22 04:50:00	SPY	ETF	297.73	297.78	297.68	297.68	7000.0
2019-07-22 04:55:00	SPY	ETF	297.6	297.71	297.58	297.71	4805.0
2019-07-22 05:00:00	SPY	ETF	297.69	297.73	297.69	297.73	3500.0
2019-07-22 05:05:00	SPY	ETF	297.56	297.56	297.51	297.51	1107.0
2019-07-22 05:10:00	SPY	ETF	297.56	297.56	297.52	297.52	268.0
2019-07-22 05:20:00	SPY	ETF	297.56	297.63	297.51	297.63	2540.0
2019-07-22 05:30:00	SPY	ETF	297.54	297.64	297.54	297.64	1988.0
2019-07-22 05:35:00	SPY	ETF	297.65	297.68	297.65	297.68	1333.0
2019-07-22 05:40:00	SPY	ETF	297.59	297.59	297.59	297.59	600.0
2019-07-22 05:45:00	SPY	ETF	297.59	297.6	297.49	297.53	3840.0
2019-07-22 05:50:00	SPY	ETF	297.54	297.54	297.53	297.54	6200.0
2019-07-22 05:55:00	SPY	ETF	297.56	297.56	297.56	297.56	651.0
2019-07-22 06:00:00	SPY	ETF	297.54	297.54	297.54	297.54	500.0
2019-07-22 06:05:00	SPY	ETF	297.49	297.49	297.49	297.49	400.0
2019-07-22 06:10:00	SPY	ETF	297.52	297.52	297.48	297.51	2937.0
2019-07-22 06:20:00	SPY	ETF	297.58	297.58	297.58	297.58	100.0
2019-07-22 06:30:00	SPY	ETF	297.62	297.8	297.62	297.8	6038.0
2019-07-22 06:35:00	SPY	ETF	297.83	297.83	297.83	297.83	1000.0
2019-07-22 06:40:00	SPY	ETF	297.77	297.79	297.73	297.79	10445.0
2019-07-22 06:45:00	SPY	ETF	297.73	297.73	297.73	297.73	129.0
2019-07-22 06:50:00	SPY	ETF	297.77	297.77	297.77	297.77	100.0
2019-07-22 06:55:00	SPY	ETF	297.79	297.79	297.76	297.76	3300.0
2019-07-22 07:00:00	SPY	ETF	297.74	297.79	297.74	297.79	13815.0
2019-07-22 07:05:00	SPY	ETF	297.76	297.78	297.73	297.73	960.0
2019-07-22 07:10:00	SPY	ETF	297.76	297.81	297.73	297.79	21859.0
2019-07-22 07:15:00	SPY	ETF	297.77	297.78	297.72	297.72	2169.0
2019-07-22 07:20:00	SPY	ETF	297.72	297.72	297.67	297.67	3720.0
2019-07-22 07:25:00	SPY	ETF	297.69	297.69	297.64	297.66	8107.0
2019-07-22 07:30:00	SPY	ETF	297.67	297.7	297.6	297.67	52092.0
2019-07-22 07:35:00	SPY	ETF	297.66	297.69	297.65	297.65	2870.0
2019-07-22 07:40:00	SPY	ETF	297.67	297.69	297.64	297.67	7113.0
2019-07-22 07:45:00	SPY	ETF	297.67	297.69	297.66	297.68	4772.0
2019-07-22 07:50:00	SPY	ETF	297.71	297.71	297.64	297.68	62160.0
2019-07-22 07:55:00	SPY	ETF	297.69	297.69	297.66	297.67	18685.0
2019-07-22 08:00:00	SPY	ETF	297.7601	297.7601	297.25	297.65	21590.0
2019-07-22 08:05:00	SPY	ETF	297.64	297.88	297.51	297.55	79104.0
2019-07-22 08:10:00	SPY	ETF	297.54	297.54	297.38	297.38	29931.0
2019-07-22 08:15:00	SPY	ETF	297.34	298.0	297.34	297.86	143662.0
2019-07-22 08:20:00	SPY	ETF	297.87	297.97	297.75	297.79	105204.0
2019-07-22 08:25:00	SPY	ETF	297.79	297.79	297.59	297.69	55080.0
2019-07-22 08:30:00	SPY	ETF	297.77	297.84	297.69	297.81	41981.0

> showing 50 of 60,245 rows — these rows as CSV

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