PREVIEW / etf_1min / 2019-08-29

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-08-29.parquet
  size:    3.2 MB
  rows:    164,499

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-08-29 04:00:00	SPY	ETF	290.86	290.86	290.78	290.78	3064.0
2019-08-29 04:01:00	SPY	ETF	290.88	290.88	290.88	290.88	3182.0
2019-08-29 04:02:00	SPY	ETF	290.72	290.75	290.72	290.75	1656.0
2019-08-29 04:03:00	SPY	ETF	290.8	290.8	290.74	290.74	340.0
2019-08-29 04:04:00	SPY	ETF	290.71	290.71	290.7	290.7	1510.0
2019-08-29 04:05:00	SPY	ETF	290.57	290.6	290.57	290.6	3530.0
2019-08-29 04:06:00	SPY	ETF	290.63	290.68	290.63	290.68	814.0
2019-08-29 04:07:00	SPY	ETF	290.66	290.66	290.66	290.66	250.0
2019-08-29 04:08:00	SPY	ETF	290.7	290.7	290.7	290.7	100.0
2019-08-29 04:09:00	SPY	ETF	290.74	290.74	290.7	290.7	795.0
2019-08-29 04:11:00	SPY	ETF	290.8	290.83	290.76	290.78	2070.0
2019-08-29 04:13:00	SPY	ETF	290.8	290.8	290.8	290.8	1930.0
2019-08-29 04:14:00	SPY	ETF	290.75	290.75	290.75	290.75	125.0
2019-08-29 04:15:00	SPY	ETF	290.8	290.8	290.8	290.8	507.0
2019-08-29 04:16:00	SPY	ETF	290.84	290.99	290.84	290.99	3636.0
2019-08-29 04:17:00	SPY	ETF	290.96	291.01	290.96	291.01	2220.0
2019-08-29 04:18:00	SPY	ETF	290.98	290.98	290.98	290.98	1110.0
2019-08-29 04:20:00	SPY	ETF	290.98	290.98	290.95	290.95	2390.0
2019-08-29 04:21:00	SPY	ETF	290.96	290.96	290.96	290.96	250.0
2019-08-29 04:22:00	SPY	ETF	290.96	290.96	290.96	290.96	700.0
2019-08-29 04:23:00	SPY	ETF	290.91	290.91	290.9	290.9	200.0
2019-08-29 04:24:00	SPY	ETF	290.93	290.98	290.93	290.98	325.0
2019-08-29 04:25:00	SPY	ETF	290.88	290.88	290.88	290.88	130.0
2019-08-29 04:28:00	SPY	ETF	290.85	290.85	290.85	290.85	480.0
2019-08-29 04:29:00	SPY	ETF	290.93	290.93	290.93	290.93	400.0
2019-08-29 04:31:00	SPY	ETF	290.8	290.8	290.8	290.8	600.0
2019-08-29 04:33:00	SPY	ETF	290.88	290.88	290.88	290.88	1123.0
2019-08-29 04:35:00	SPY	ETF	290.87	290.87	290.87	290.87	150.0
2019-08-29 04:36:00	SPY	ETF	290.97	291.12	290.97	291.12	5525.0
2019-08-29 04:37:00	SPY	ETF	291.08	291.08	290.98	290.98	725.0
2019-08-29 04:39:00	SPY	ETF	291.03	291.03	291.03	291.03	550.0
2019-08-29 04:43:00	SPY	ETF	291.15	291.18	291.15	291.18	6904.0
2019-08-29 04:45:00	SPY	ETF	290.98	290.98	290.98	290.98	140.0
2019-08-29 04:46:00	SPY	ETF	290.85	290.85	290.85	290.85	1114.0
2019-08-29 04:49:00	SPY	ETF	290.89	290.89	290.89	290.89	200.0
2019-08-29 04:51:00	SPY	ETF	290.98	291.0	290.98	291.0	1400.0
2019-08-29 04:52:00	SPY	ETF	291.16	291.18	291.1	291.1	1333.0
2019-08-29 04:54:00	SPY	ETF	291.1	291.1	291.1	291.1	1025.0
2019-08-29 04:55:00	SPY	ETF	291.02	291.02	291.02	291.02	115.0
2019-08-29 04:57:00	SPY	ETF	290.94	290.94	290.94	290.94	2000.0
2019-08-29 05:00:00	SPY	ETF	291.15	291.18	291.15	291.18	1100.0
2019-08-29 05:03:00	SPY	ETF	291.23	291.42	291.23	291.42	3437.0
2019-08-29 05:04:00	SPY	ETF	291.42	291.6	291.42	291.6	3692.0
2019-08-29 05:05:00	SPY	ETF	291.57	291.67	291.57	291.67	1330.0
2019-08-29 05:06:00	SPY	ETF	291.6	291.6	291.55	291.55	2125.0
2019-08-29 05:08:00	SPY	ETF	291.56	291.56	291.56	291.56	275.0
2019-08-29 05:09:00	SPY	ETF	291.59	291.59	291.59	291.59	150.0
2019-08-29 05:10:00	SPY	ETF	291.62	291.62	291.62	291.62	235.0
2019-08-29 05:11:00	SPY	ETF	291.63	291.63	291.61	291.61	1130.0
2019-08-29 05:12:00	SPY	ETF	291.59	291.59	291.59	291.59	1006.0

> showing 50 of 164,499 rows — these rows as CSV

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