PREVIEW / etf_1min / 2017-03-03

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-03-03.parquet
  size:    2.8 MB
  rows:    146,461

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
2017-03-03 04:00:00	SPY	ETF	237.88	237.88	237.79	237.79	926.0
2017-03-03 04:04:00	SPY	ETF	237.84	237.84	237.84	237.84	400.0
2017-03-03 04:08:00	SPY	ETF	237.77	237.77	237.77	237.77	200.0
2017-03-03 04:18:00	SPY	ETF	237.79	237.79	237.79	237.79	1500.0
2017-03-03 04:22:00	SPY	ETF	237.78	237.78	237.78	237.78	100.0
2017-03-03 04:28:00	SPY	ETF	237.79	237.79	237.79	237.79	100.0
2017-03-03 04:33:00	SPY	ETF	237.75	237.75	237.75	237.75	1700.0
2017-03-03 04:35:00	SPY	ETF	237.75	237.75	237.75	237.75	100.0
2017-03-03 04:37:00	SPY	ETF	237.66	237.66	237.66	237.66	3000.0
2017-03-03 04:38:00	SPY	ETF	237.69	237.69	237.69	237.69	3000.0
2017-03-03 04:39:00	SPY	ETF	237.73	237.73	237.73	237.73	400.0
2017-03-03 04:40:00	SPY	ETF	237.73	237.73	237.73	237.73	2600.0
2017-03-03 04:51:00	SPY	ETF	237.75	237.75	237.75	237.75	300.0
2017-03-03 05:05:00	SPY	ETF	237.76	237.76	237.76	237.76	300.0
2017-03-03 05:11:00	SPY	ETF	237.8	237.8	237.8	237.8	2500.0
2017-03-03 05:15:00	SPY	ETF	237.85	237.85	237.85	237.85	300.0
2017-03-03 05:16:00	SPY	ETF	237.85	237.85	237.85	237.85	501.0
2017-03-03 05:17:00	SPY	ETF	237.82	237.82	237.82	237.82	101.0
2017-03-03 05:25:00	SPY	ETF	237.83	237.83	237.83	237.83	1000.0
2017-03-03 05:43:00	SPY	ETF	237.98	237.99	237.98	237.98	16101.0
2017-03-03 05:53:00	SPY	ETF	238.05	238.09	238.05	238.09	1602.0
2017-03-03 05:54:00	SPY	ETF	238.08	238.09	238.08	238.09	2400.0
2017-03-03 06:11:00	SPY	ETF	238.07	238.07	238.07	238.07	100.0
2017-03-03 06:15:00	SPY	ETF	238.16	238.23	238.16	238.2	1045.0
2017-03-03 06:20:00	SPY	ETF	238.19	238.19	238.19	238.19	1000.0
2017-03-03 06:22:00	SPY	ETF	238.22	238.22	238.22	238.22	1000.0
2017-03-03 06:23:00	SPY	ETF	238.22	238.26	238.21	238.21	2728.0
2017-03-03 06:24:00	SPY	ETF	238.21	238.23	238.21	238.23	1601.0
2017-03-03 06:25:00	SPY	ETF	238.24	238.25	238.24	238.25	1325.0
2017-03-03 06:30:00	SPY	ETF	238.19	238.19	238.19	238.19	1500.0
2017-03-03 06:32:00	SPY	ETF	238.22	238.22	238.22	238.22	300.0
2017-03-03 06:34:00	SPY	ETF	238.23	238.25	238.23	238.25	1304.0
2017-03-03 06:37:00	SPY	ETF	238.3	238.3	238.26	238.28	23403.0
2017-03-03 06:38:00	SPY	ETF	238.28	238.28	238.27	238.27	14600.0
2017-03-03 06:39:00	SPY	ETF	238.28	238.31	238.28	238.31	12100.0
2017-03-03 06:41:00	SPY	ETF	238.29	238.29	238.29	238.29	200.0
2017-03-03 06:46:00	SPY	ETF	238.23	238.23	238.23	238.23	328.0
2017-03-03 06:56:00	SPY	ETF	238.17	238.17	238.17	238.17	101.0
2017-03-03 07:00:00	SPY	ETF	238.16	238.16	238.15	238.16	799.0
2017-03-03 07:02:00	SPY	ETF	238.16	238.16	238.16	238.16	400.0
2017-03-03 07:08:00	SPY	ETF	238.19	238.19	238.17	238.17	2201.0
2017-03-03 07:11:00	SPY	ETF	238.19	238.19	238.19	238.19	200.0
2017-03-03 07:19:00	SPY	ETF	238.21	238.21	238.21	238.21	226.0
2017-03-03 07:22:00	SPY	ETF	238.23	238.25	238.23	238.25	803.0
2017-03-03 07:23:00	SPY	ETF	238.25	238.25	238.23	238.23	1848.0
2017-03-03 07:24:00	SPY	ETF	238.22	238.22	238.19	238.19	353.0
2017-03-03 07:25:00	SPY	ETF	238.19	238.19	238.19	238.19	300.0
2017-03-03 07:26:00	SPY	ETF	238.19	238.19	238.19	238.19	5000.0
2017-03-03 07:27:00	SPY	ETF	238.18	238.18	238.18	238.18	1100.0
2017-03-03 07:28:00	SPY	ETF	238.18	238.18	238.18	238.18	1500.0

> showing 50 of 146,461 rows — these rows as CSV

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