PREVIEW / etf_1min / 2018-01-12

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-01-12.parquet
  size:    3.3 MB
  rows:    167,610

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-01-12 04:00:00	SPY	ETF	276.76	276.76	276.45	276.45	1295.0
2018-01-12 04:01:00	SPY	ETF	276.52	276.52	276.52	276.52	195.0
2018-01-12 04:03:00	SPY	ETF	276.84	276.84	276.84	276.84	600.0
2018-01-12 04:04:00	SPY	ETF	276.86	276.86	276.86	276.86	200.0
2018-01-12 04:06:00	SPY	ETF	276.86	276.86	276.82	276.82	1400.0
2018-01-12 04:07:00	SPY	ETF	276.86	276.88	276.86	276.88	205.0
2018-01-12 04:08:00	SPY	ETF	276.86	276.86	276.85	276.85	1100.0
2018-01-12 04:09:00	SPY	ETF	276.82	276.82	276.82	276.82	300.0
2018-01-12 04:10:00	SPY	ETF	276.82	276.83	276.82	276.83	300.0
2018-01-12 04:12:00	SPY	ETF	276.88	276.88	276.88	276.88	300.0
2018-01-12 04:14:00	SPY	ETF	276.87	276.87	276.87	276.87	400.0
2018-01-12 04:17:00	SPY	ETF	276.88	276.92	276.88	276.92	2520.0
2018-01-12 04:19:00	SPY	ETF	276.92	276.92	276.92	276.92	100.0
2018-01-12 04:20:00	SPY	ETF	276.92	276.92	276.92	276.92	409.0
2018-01-12 04:21:00	SPY	ETF	276.92	276.92	276.92	276.92	300.0
2018-01-12 04:27:00	SPY	ETF	276.87	276.87	276.87	276.87	400.0
2018-01-12 04:32:00	SPY	ETF	276.84	276.84	276.84	276.84	400.0
2018-01-12 04:33:00	SPY	ETF	276.84	276.84	276.84	276.84	500.0
2018-01-12 04:34:00	SPY	ETF	276.84	276.84	276.84	276.84	1000.0
2018-01-12 04:36:00	SPY	ETF	276.79	276.79	276.79	276.79	100.0
2018-01-12 04:37:00	SPY	ETF	276.82	276.85	276.82	276.85	1100.0
2018-01-12 04:39:00	SPY	ETF	276.85	276.85	276.85	276.85	500.0
2018-01-12 04:40:00	SPY	ETF	276.88	276.88	276.88	276.88	500.0
2018-01-12 04:45:00	SPY	ETF	276.82	276.82	276.82	276.82	100.0
2018-01-12 04:48:00	SPY	ETF	276.85	276.85	276.85	276.85	500.0
2018-01-12 04:49:00	SPY	ETF	276.85	276.85	276.85	276.85	500.0
2018-01-12 05:01:00	SPY	ETF	276.75	276.75	276.75	276.75	200.0
2018-01-12 05:02:00	SPY	ETF	276.71	276.71	276.71	276.71	800.0
2018-01-12 05:10:00	SPY	ETF	276.8	276.8	276.8	276.8	400.0
2018-01-12 05:17:00	SPY	ETF	276.8	276.8	276.8	276.8	5000.0
2018-01-12 05:22:00	SPY	ETF	276.77	276.77	276.77	276.77	200.0
2018-01-12 05:25:00	SPY	ETF	276.74	276.74	276.74	276.74	100.0
2018-01-12 05:32:00	SPY	ETF	276.84	276.84	276.84	276.84	300.0
2018-01-12 05:45:00	SPY	ETF	276.83	276.83	276.83	276.83	400.0
2018-01-12 05:48:00	SPY	ETF	276.81	276.81	276.81	276.81	1000.0
2018-01-12 05:59:00	SPY	ETF	276.88	276.88	276.83	276.83	400.0
2018-01-12 06:00:00	SPY	ETF	276.85	276.85	276.85	276.85	3462.0
2018-01-12 06:09:00	SPY	ETF	276.88	276.88	276.88	276.88	400.0
2018-01-12 06:13:00	SPY	ETF	276.86	276.86	276.86	276.86	1500.0
2018-01-12 06:15:00	SPY	ETF	276.9	276.9	276.9	276.9	410.0
2018-01-12 06:23:00	SPY	ETF	276.85	276.85	276.85	276.85	300.0
2018-01-12 06:29:00	SPY	ETF	276.82	276.82	276.82	276.82	10000.0
2018-01-12 06:30:00	SPY	ETF	276.84	276.84	276.84	276.84	8100.0
2018-01-12 06:31:00	SPY	ETF	276.83	276.84	276.83	276.83	10000.0
2018-01-12 06:34:00	SPY	ETF	276.83	276.85	276.83	276.85	2000.0
2018-01-12 06:35:00	SPY	ETF	276.85	276.88	276.85	276.88	4650.0
2018-01-12 06:36:00	SPY	ETF	276.88	276.88	276.88	276.88	1750.0
2018-01-12 06:38:00	SPY	ETF	276.83	276.83	276.83	276.83	400.0
2018-01-12 06:41:00	SPY	ETF	276.87	276.87	276.87	276.87	600.0
2018-01-12 06:43:00	SPY	ETF	276.87	276.87	276.87	276.87	500.0

> showing 50 of 167,610 rows — these rows as CSV

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