PREVIEW / etf_1min / 2019-10-21

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-10-21.parquet
  size:    2.9 MB
  rows:    151,088

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-10-21 04:00:00	SPY	ETF	298.82	298.94	298.82	298.92	1830.0
2019-10-21 04:01:00	SPY	ETF	298.88	298.88	298.88	298.88	300.0
2019-10-21 04:03:00	SPY	ETF	298.87	298.87	298.87	298.87	213.0
2019-10-21 04:04:00	SPY	ETF	298.9	298.9	298.9	298.9	200.0
2019-10-21 04:05:00	SPY	ETF	298.9	298.9	298.89	298.89	310.0
2019-10-21 04:06:00	SPY	ETF	298.95	298.95	298.95	298.95	110.0
2019-10-21 04:07:00	SPY	ETF	298.98	299.0	298.98	298.99	855.0
2019-10-21 04:08:00	SPY	ETF	298.9	298.94	298.9	298.94	300.0
2019-10-21 04:09:00	SPY	ETF	298.94	298.95	298.9	298.9	2450.0
2019-10-21 04:10:00	SPY	ETF	298.93	298.96	298.93	298.93	1350.0
2019-10-21 04:11:00	SPY	ETF	298.97	298.97	298.97	298.97	153.0
2019-10-21 04:12:00	SPY	ETF	298.92	298.92	298.92	298.92	400.0
2019-10-21 04:14:00	SPY	ETF	298.96	298.96	298.96	298.96	100.0
2019-10-21 04:15:00	SPY	ETF	299.01	299.01	299.01	299.01	100.0
2019-10-21 04:16:00	SPY	ETF	299.04	299.04	299.02	299.02	2100.0
2019-10-21 04:17:00	SPY	ETF	299.03	299.03	299.0	299.0	900.0
2019-10-21 04:20:00	SPY	ETF	299.03	299.03	299.03	299.03	400.0
2019-10-21 04:23:00	SPY	ETF	298.97	298.97	298.97	298.97	500.0
2019-10-21 04:27:00	SPY	ETF	298.95	298.95	298.95	298.95	500.0
2019-10-21 04:28:00	SPY	ETF	298.95	298.95	298.95	298.95	100.0
2019-10-21 04:30:00	SPY	ETF	299.0	299.0	298.99	299.0	4400.0
2019-10-21 04:32:00	SPY	ETF	299.04	299.04	299.04	299.04	100.0
2019-10-21 04:38:00	SPY	ETF	299.0	299.0	299.0	299.0	400.0
2019-10-21 04:42:00	SPY	ETF	298.9	298.9	298.9	298.9	800.0
2019-10-21 04:44:00	SPY	ETF	298.96	298.97	298.96	298.97	700.0
2019-10-21 04:46:00	SPY	ETF	299.07	299.07	299.07	299.07	100.0
2019-10-21 04:50:00	SPY	ETF	298.95	298.95	298.9	298.95	2400.0
2019-10-21 04:54:00	SPY	ETF	298.88	298.88	298.88	298.88	200.0
2019-10-21 05:01:00	SPY	ETF	298.8	298.81	298.8	298.8	1100.0
2019-10-21 05:02:00	SPY	ETF	298.8	298.8	298.8	298.8	100.0
2019-10-21 05:03:00	SPY	ETF	298.8	298.8	298.8	298.8	2050.0
2019-10-21 05:06:00	SPY	ETF	298.8	298.8	298.8	298.8	1500.0
2019-10-21 05:08:00	SPY	ETF	298.9	298.92	298.9	298.92	3100.0
2019-10-21 05:14:00	SPY	ETF	298.95	298.95	298.95	298.95	1000.0
2019-10-21 05:15:00	SPY	ETF	298.93	298.93	298.92	298.92	2550.0
2019-10-21 05:16:00	SPY	ETF	298.92	298.92	298.87	298.87	3900.0
2019-10-21 05:17:00	SPY	ETF	298.83	298.83	298.83	298.83	1000.0
2019-10-21 05:18:00	SPY	ETF	298.82	298.82	298.79	298.79	4400.0
2019-10-21 05:19:00	SPY	ETF	298.83	298.83	298.83	298.83	450.0
2019-10-21 05:21:00	SPY	ETF	298.82	298.82	298.75	298.75	6800.0
2019-10-21 05:22:00	SPY	ETF	298.77	298.77	298.75	298.75	3400.0
2019-10-21 05:23:00	SPY	ETF	298.73	298.73	298.73	298.73	1999.0
2019-10-21 05:28:00	SPY	ETF	298.8	298.8	298.8	298.8	500.0
2019-10-21 05:32:00	SPY	ETF	298.82	298.82	298.79	298.79	3386.0
2019-10-21 05:34:00	SPY	ETF	298.86	298.94	298.86	298.9	6550.0
2019-10-21 05:36:00	SPY	ETF	298.9	298.9	298.83	298.83	1250.0
2019-10-21 05:38:00	SPY	ETF	298.91	298.91	298.91	298.91	1000.0
2019-10-21 05:40:00	SPY	ETF	298.93	298.93	298.93	298.93	500.0
2019-10-21 05:41:00	SPY	ETF	298.93	298.93	298.93	298.93	500.0
2019-10-21 05:45:00	SPY	ETF	299.04	299.04	299.04	299.04	990.0

> showing 50 of 151,088 rows — these rows as CSV

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