PREVIEW / etf_1min / 2018-05-22

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-05-22.parquet
  size:    2.8 MB
  rows:    144,480

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-05-22 04:00:00	SPY	ETF	273.7	273.72	273.7	273.72	577.0
2018-05-22 04:03:00	SPY	ETF	273.72	273.72	273.72	273.72	3502.0
2018-05-22 04:04:00	SPY	ETF	273.72	273.72	273.72	273.72	680.0
2018-05-22 04:05:00	SPY	ETF	273.72	273.73	273.72	273.73	4310.0
2018-05-22 04:06:00	SPY	ETF	273.75	273.78	273.75	273.78	210.0
2018-05-22 04:07:00	SPY	ETF	273.78	273.78	273.78	273.78	300.0
2018-05-22 04:08:00	SPY	ETF	273.79	273.79	273.78	273.78	250.0
2018-05-22 04:09:00	SPY	ETF	273.75	273.75	273.75	273.75	300.0
2018-05-22 04:11:00	SPY	ETF	273.78	273.78	273.78	273.78	100.0
2018-05-22 04:16:00	SPY	ETF	273.79	273.79	273.79	273.79	1850.0
2018-05-22 04:25:00	SPY	ETF	273.73	273.73	273.73	273.73	100.0
2018-05-22 04:29:00	SPY	ETF	273.8	273.8	273.8	273.8	300.0
2018-05-22 04:30:00	SPY	ETF	273.77	273.77	273.77	273.77	138.0
2018-05-22 04:52:00	SPY	ETF	273.81	273.81	273.81	273.81	100.0
2018-05-22 04:54:00	SPY	ETF	273.82	273.82	273.82	273.82	1100.0
2018-05-22 04:55:00	SPY	ETF	273.82	273.82	273.82	273.82	1500.0
2018-05-22 05:07:00	SPY	ETF	273.85	273.85	273.85	273.85	300.0
2018-05-22 05:15:00	SPY	ETF	273.87	273.87	273.87	273.87	300.0
2018-05-22 05:19:00	SPY	ETF	273.86	273.86	273.86	273.86	350.0
2018-05-22 05:21:00	SPY	ETF	273.86	273.86	273.86	273.86	300.0
2018-05-22 05:24:00	SPY	ETF	273.92	273.92	273.92	273.92	1000.0
2018-05-22 05:32:00	SPY	ETF	273.81	273.81	273.81	273.81	300.0
2018-05-22 05:34:00	SPY	ETF	273.89	273.89	273.89	273.89	450.0
2018-05-22 05:36:00	SPY	ETF	273.88	273.88	273.88	273.88	300.0
2018-05-22 05:38:00	SPY	ETF	273.94	273.94	273.94	273.94	300.0
2018-05-22 05:41:00	SPY	ETF	273.8	273.8	273.8	273.8	115.0
2018-05-22 05:43:00	SPY	ETF	273.82	273.82	273.82	273.82	100.0
2018-05-22 05:51:00	SPY	ETF	273.86	273.86	273.86	273.86	400.0
2018-05-22 05:58:00	SPY	ETF	273.86	273.86	273.86	273.86	100.0
2018-05-22 05:59:00	SPY	ETF	273.86	273.88	273.86	273.88	900.0
2018-05-22 06:03:00	SPY	ETF	273.93	273.93	273.93	273.93	600.0
2018-05-22 06:04:00	SPY	ETF	273.96	273.96	273.96	273.96	300.0
2018-05-22 06:08:00	SPY	ETF	273.96	273.96	273.96	273.96	310.0
2018-05-22 06:09:00	SPY	ETF	273.96	273.96	273.96	273.96	1100.0
2018-05-22 06:11:00	SPY	ETF	273.99	273.99	273.99	273.99	305.0
2018-05-22 06:13:00	SPY	ETF	273.96	273.96	273.96	273.96	1000.0
2018-05-22 06:14:00	SPY	ETF	273.96	273.96	273.96	273.96	405.0
2018-05-22 06:17:00	SPY	ETF	273.96	273.96	273.96	273.96	295.0
2018-05-22 06:22:00	SPY	ETF	273.93	273.93	273.93	273.93	100.0
2018-05-22 06:27:00	SPY	ETF	273.9	273.9	273.9	273.9	300.0
2018-05-22 06:37:00	SPY	ETF	273.87	273.87	273.87	273.87	1000.0
2018-05-22 06:38:00	SPY	ETF	273.83	273.83	273.83	273.83	300.0
2018-05-22 06:40:00	SPY	ETF	273.8	273.8	273.8	273.8	400.0
2018-05-22 06:42:00	SPY	ETF	273.76	273.8	273.75	273.8	5000.0
2018-05-22 06:43:00	SPY	ETF	273.77	273.77	273.73	273.73	1400.0
2018-05-22 06:45:00	SPY	ETF	273.79	273.79	273.79	273.79	1000.0
2018-05-22 06:47:00	SPY	ETF	273.79	273.79	273.79	273.79	160.0
2018-05-22 06:49:00	SPY	ETF	273.79	273.88	273.79	273.88	6100.0
2018-05-22 06:50:00	SPY	ETF	273.89	273.89	273.89	273.89	300.0
2018-05-22 06:55:00	SPY	ETF	273.85	273.86	273.85	273.86	400.0

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

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