PREVIEW / etf_5min / 2019-11-22

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-11-22.parquet
  size:    1.4 MB
  rows:    59,333

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-11-22 04:00:00	SPY	ETF	311.3	311.42	311.22	311.22	5252.0
2019-11-22 04:05:00	SPY	ETF	311.27	311.33	311.26	311.28	4120.0
2019-11-22 04:10:00	SPY	ETF	311.07	311.08	311.05	311.05	2500.0
2019-11-22 04:15:00	SPY	ETF	311.0	311.03	310.96	310.96	1710.0
2019-11-22 04:25:00	SPY	ETF	310.97	311.03	310.97	311.03	2000.0
2019-11-22 04:30:00	SPY	ETF	310.97	310.97	310.97	310.97	1000.0
2019-11-22 04:35:00	SPY	ETF	310.94	310.96	310.94	310.96	1154.0
2019-11-22 04:45:00	SPY	ETF	310.97	311.05	310.97	311.05	2208.0
2019-11-22 04:50:00	SPY	ETF	311.05	311.05	311.05	311.05	508.0
2019-11-22 05:05:00	SPY	ETF	311.06	311.06	311.06	311.06	100.0
2019-11-22 05:10:00	SPY	ETF	310.98	311.01	310.96	311.01	1020.0
2019-11-22 05:15:00	SPY	ETF	311.01	311.07	311.0	311.06	2300.0
2019-11-22 05:20:00	SPY	ETF	311.07	311.07	311.07	311.07	300.0
2019-11-22 05:25:00	SPY	ETF	311.15	311.15	311.13	311.13	2210.0
2019-11-22 05:30:00	SPY	ETF	311.08	311.08	311.04	311.06	2300.0
2019-11-22 05:35:00	SPY	ETF	311.08	311.08	310.99	310.99	3200.0
2019-11-22 05:40:00	SPY	ETF	311.04	311.04	310.98	310.98	2803.0
2019-11-22 05:45:00	SPY	ETF	311.0	311.04	310.9	310.9	3767.0
2019-11-22 05:50:00	SPY	ETF	310.98	310.98	310.98	310.98	900.0
2019-11-22 05:55:00	SPY	ETF	311.01	311.01	310.97	310.97	1601.0
2019-11-22 06:00:00	SPY	ETF	310.95	311.0	310.89	310.89	3603.0
2019-11-22 06:05:00	SPY	ETF	310.91	310.91	310.82	310.84	3117.0
2019-11-22 06:10:00	SPY	ETF	310.86	310.86	310.65	310.66	5459.0
2019-11-22 06:15:00	SPY	ETF	310.64	310.73	310.62	310.7	4533.0
2019-11-22 06:20:00	SPY	ETF	310.7	310.73	310.69	310.7	1237.0
2019-11-22 06:25:00	SPY	ETF	310.67	310.76	310.67	310.76	1550.0
2019-11-22 06:30:00	SPY	ETF	310.74	310.79	310.74	310.78	2200.0
2019-11-22 06:35:00	SPY	ETF	310.75	310.77	310.72	310.77	503.0
2019-11-22 06:40:00	SPY	ETF	310.79	310.85	310.79	310.84	3300.0
2019-11-22 06:45:00	SPY	ETF	310.84	310.88	310.84	310.85	1400.0
2019-11-22 06:50:00	SPY	ETF	310.84	310.84	310.82	310.84	1325.0
2019-11-22 06:55:00	SPY	ETF	310.9	310.9	310.9	310.9	600.0
2019-11-22 07:00:00	SPY	ETF	310.91	311.04	310.91	311.0	4939.0
2019-11-22 07:05:00	SPY	ETF	311.0	311.11	311.0	311.1	2971.0
2019-11-22 07:10:00	SPY	ETF	311.06	311.06	311.03	311.03	820.0
2019-11-22 07:15:00	SPY	ETF	311.05	311.09	310.99	310.99	11520.0
2019-11-22 07:20:00	SPY	ETF	310.96	310.96	310.96	310.96	513.0
2019-11-22 07:25:00	SPY	ETF	310.97	311.07	310.97	311.01	3580.0
2019-11-22 07:30:00	SPY	ETF	311.02	311.02	310.93	310.96	4800.0
2019-11-22 07:35:00	SPY	ETF	310.97	310.97	310.91	310.92	1580.0
2019-11-22 07:40:00	SPY	ETF	310.93	311.04	310.9	311.04	42485.0
2019-11-22 07:45:00	SPY	ETF	311.01	311.02	311.0	311.01	911.0
2019-11-22 07:50:00	SPY	ETF	311.02	311.02	310.96	310.99	5788.0
2019-11-22 07:55:00	SPY	ETF	311.02	311.02	310.99	311.0	2407.0
2019-11-22 08:00:00	SPY	ETF	311.0099	311.4	310.73	310.97	18530.0
2019-11-22 08:05:00	SPY	ETF	310.96	310.96	310.9	310.94	7230.0
2019-11-22 08:10:00	SPY	ETF	310.94	310.94	310.86	310.87	15664.0
2019-11-22 08:15:00	SPY	ETF	310.87	310.87	310.82	310.82	5059.0
2019-11-22 08:20:00	SPY	ETF	310.86	310.86	310.79	310.81	2790.0
2019-11-22 08:25:00	SPY	ETF	310.78	310.78	310.76	310.78	7724.0

> showing 50 of 59,333 rows — these rows as CSV

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