PREVIEW / etf_1min / 2018-03-20

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-03-20.parquet
  size:    2.7 MB
  rows:    144,671

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-03-20 04:00:00	SPY	ETF	271.21	271.21	271.21	271.21	350.0
2018-03-20 04:04:00	SPY	ETF	271.16	271.16	271.16	271.16	1030.0
2018-03-20 04:12:00	SPY	ETF	271.24	271.24	271.24	271.24	300.0
2018-03-20 04:16:00	SPY	ETF	271.18	271.18	271.18	271.18	100.0
2018-03-20 04:17:00	SPY	ETF	271.16	271.16	271.16	271.16	420.0
2018-03-20 04:20:00	SPY	ETF	271.25	271.25	271.25	271.25	100.0
2018-03-20 04:23:00	SPY	ETF	271.22	271.22	271.22	271.22	400.0
2018-03-20 04:25:00	SPY	ETF	271.22	271.26	271.22	271.26	400.0
2018-03-20 04:29:00	SPY	ETF	271.16	271.16	271.16	271.16	400.0
2018-03-20 04:32:00	SPY	ETF	271.13	271.13	271.05	271.05	4800.0
2018-03-20 04:34:00	SPY	ETF	271.0	271.0	270.97	270.97	10000.0
2018-03-20 04:35:00	SPY	ETF	271.01	271.01	271.01	271.01	100.0
2018-03-20 04:36:00	SPY	ETF	270.98	270.98	270.98	270.98	200.0
2018-03-20 04:37:00	SPY	ETF	270.98	270.99	270.98	270.99	12300.0
2018-03-20 04:38:00	SPY	ETF	271.05	271.05	271.05	271.05	300.0
2018-03-20 04:39:00	SPY	ETF	271.06	271.08	271.06	271.08	900.0
2018-03-20 04:40:00	SPY	ETF	271.05	271.05	271.05	271.05	3800.0
2018-03-20 04:41:00	SPY	ETF	271.05	271.05	271.05	271.05	2100.0
2018-03-20 04:43:00	SPY	ETF	271.05	271.06	271.05	271.06	2000.0
2018-03-20 04:44:00	SPY	ETF	271.11	271.11	271.11	271.11	600.0
2018-03-20 04:48:00	SPY	ETF	271.05	271.05	271.05	271.05	800.0
2018-03-20 04:49:00	SPY	ETF	271.05	271.05	271.04	271.05	4300.0
2018-03-20 04:52:00	SPY	ETF	271.25	271.25	271.25	271.25	100.0
2018-03-20 04:54:00	SPY	ETF	271.25	271.26	271.21	271.26	800.0
2018-03-20 04:55:00	SPY	ETF	271.2	271.2	271.2	271.2	2000.0
2018-03-20 04:59:00	SPY	ETF	271.18	271.26	271.18	271.26	800.0
2018-03-20 05:00:00	SPY	ETF	271.21	271.21	271.21	271.21	300.0
2018-03-20 05:04:00	SPY	ETF	271.16	271.16	271.16	271.16	100.0
2018-03-20 05:08:00	SPY	ETF	270.98	270.98	270.98	270.98	350.0
2018-03-20 05:09:00	SPY	ETF	270.95	270.95	270.9	270.91	10300.0
2018-03-20 05:12:00	SPY	ETF	270.87	270.87	270.78	270.82	10500.0
2018-03-20 05:13:00	SPY	ETF	270.77	270.77	270.65	270.65	8015.0
2018-03-20 05:14:00	SPY	ETF	270.61	270.61	270.61	270.61	5050.0
2018-03-20 05:16:00	SPY	ETF	270.68	270.68	270.68	270.68	100.0
2018-03-20 05:19:00	SPY	ETF	270.7	270.7	270.65	270.66	2600.0
2018-03-20 05:24:00	SPY	ETF	270.73	270.73	270.73	270.73	500.0
2018-03-20 05:25:00	SPY	ETF	270.7	270.7	270.7	270.7	300.0
2018-03-20 05:26:00	SPY	ETF	270.7	270.7	270.68	270.68	300.0
2018-03-20 05:31:00	SPY	ETF	270.65	270.65	270.65	270.65	400.0
2018-03-20 05:32:00	SPY	ETF	270.68	270.68	270.68	270.68	400.0
2018-03-20 05:36:00	SPY	ETF	270.67	270.67	270.67	270.67	1000.0
2018-03-20 05:38:00	SPY	ETF	270.77	270.77	270.77	270.77	300.0
2018-03-20 05:40:00	SPY	ETF	270.78	270.78	270.78	270.78	550.0
2018-03-20 05:42:00	SPY	ETF	270.76	270.76	270.7	270.7	1600.0
2018-03-20 05:44:00	SPY	ETF	270.69	270.69	270.69	270.69	600.0
2018-03-20 05:48:00	SPY	ETF	270.8	270.8	270.8	270.8	5030.0
2018-03-20 05:49:00	SPY	ETF	270.77	270.77	270.77	270.77	600.0
2018-03-20 05:53:00	SPY	ETF	270.73	270.73	270.73	270.73	300.0
2018-03-20 05:54:00	SPY	ETF	270.89	270.89	270.89	270.89	160.0
2018-03-20 05:55:00	SPY	ETF	270.89	270.89	270.88	270.88	1900.0

> showing 50 of 144,671 rows — these rows as CSV

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