PREVIEW / etf_1min / 2018-11-01

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-11-01.parquet
  size:    3.4 MB
  rows:    180,195

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-11-01 04:02:00	SPY	ETF	270.6	270.7	270.6	270.7	200.0
2018-11-01 04:04:00	SPY	ETF	270.6	270.7	270.6	270.7	1050.0
2018-11-01 04:06:00	SPY	ETF	270.81	270.9	270.81	270.85	2000.0
2018-11-01 04:09:00	SPY	ETF	270.86	270.86	270.86	270.86	100.0
2018-11-01 04:10:00	SPY	ETF	270.93	270.93	270.93	270.93	125.0
2018-11-01 04:11:00	SPY	ETF	270.89	270.89	270.89	270.89	660.0
2018-11-01 04:15:00	SPY	ETF	270.8	270.8	270.8	270.8	500.0
2018-11-01 04:17:00	SPY	ETF	270.86	270.88	270.86	270.88	700.0
2018-11-01 04:18:00	SPY	ETF	270.95	270.95	270.95	270.95	210.0
2018-11-01 04:19:00	SPY	ETF	271.05	271.07	271.0	271.05	5300.0
2018-11-01 04:20:00	SPY	ETF	271.02	271.05	271.02	271.05	1500.0
2018-11-01 04:21:00	SPY	ETF	271.05	271.19	271.05	271.19	1430.0
2018-11-01 04:22:00	SPY	ETF	271.23	271.23	271.16	271.16	2020.0
2018-11-01 04:23:00	SPY	ETF	271.15	271.15	271.15	271.15	500.0
2018-11-01 04:24:00	SPY	ETF	271.17	271.17	271.17	271.17	334.0
2018-11-01 04:27:00	SPY	ETF	271.21	271.21	271.21	271.21	409.0
2018-11-01 04:28:00	SPY	ETF	271.22	271.3	271.22	271.3	1338.0
2018-11-01 04:29:00	SPY	ETF	271.31	271.32	271.31	271.32	1141.0
2018-11-01 04:32:00	SPY	ETF	271.32	271.32	271.32	271.32	100.0
2018-11-01 04:33:00	SPY	ETF	271.21	271.21	271.21	271.21	1000.0
2018-11-01 04:36:00	SPY	ETF	271.17	271.17	271.17	271.17	1000.0
2018-11-01 04:37:00	SPY	ETF	271.2	271.2	271.2	271.2	1000.0
2018-11-01 04:38:00	SPY	ETF	271.23	271.23	271.23	271.23	600.0
2018-11-01 04:41:00	SPY	ETF	271.21	271.21	271.21	271.21	1000.0
2018-11-01 04:44:00	SPY	ETF	271.17	271.17	271.11	271.11	3469.0
2018-11-01 04:45:00	SPY	ETF	271.19	271.19	271.19	271.19	500.0
2018-11-01 04:46:00	SPY	ETF	271.2	271.25	271.2	271.25	1040.0
2018-11-01 04:47:00	SPY	ETF	271.3	271.35	271.3	271.35	869.0
2018-11-01 04:48:00	SPY	ETF	271.4	271.45	271.4	271.45	1788.0
2018-11-01 04:49:00	SPY	ETF	271.41	271.45	271.41	271.45	700.0
2018-11-01 04:50:00	SPY	ETF	271.45	271.45	271.45	271.45	309.0
2018-11-01 04:51:00	SPY	ETF	271.49	271.56	271.49	271.56	1688.0
2018-11-01 04:53:00	SPY	ETF	271.54	271.54	271.54	271.54	100.0
2018-11-01 04:54:00	SPY	ETF	271.44	271.44	271.4	271.4	1160.0
2018-11-01 04:55:00	SPY	ETF	271.42	271.42	271.42	271.42	1000.0
2018-11-01 04:56:00	SPY	ETF	271.46	271.46	271.46	271.46	500.0
2018-11-01 04:57:00	SPY	ETF	271.41	271.41	271.4	271.4	800.0
2018-11-01 04:58:00	SPY	ETF	271.46	271.46	271.46	271.46	500.0
2018-11-01 05:01:00	SPY	ETF	271.5	271.55	271.5	271.55	1200.0
2018-11-01 05:02:00	SPY	ETF	271.59	271.64	271.59	271.63	11300.0
2018-11-01 05:04:00	SPY	ETF	271.67	271.67	271.67	271.67	5000.0
2018-11-01 05:07:00	SPY	ETF	271.6	271.6	271.6	271.6	5120.0
2018-11-01 05:08:00	SPY	ETF	271.55	271.55	271.55	271.55	500.0
2018-11-01 05:09:00	SPY	ETF	271.5	271.5	271.45	271.45	1280.0
2018-11-01 05:10:00	SPY	ETF	271.45	271.45	271.45	271.45	600.0
2018-11-01 05:12:00	SPY	ETF	271.4	271.4	271.4	271.4	600.0
2018-11-01 05:13:00	SPY	ETF	271.38	271.38	271.38	271.38	150.0
2018-11-01 05:15:00	SPY	ETF	271.35	271.35	271.35	271.35	1280.0
2018-11-01 05:18:00	SPY	ETF	271.4	271.4	271.4	271.4	400.0
2018-11-01 05:21:00	SPY	ETF	271.35	271.35	271.35	271.35	1000.0

> showing 50 of 180,195 rows — these rows as CSV

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