PREVIEW / etf_1min / 2018-05-08

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-05-08.parquet
  size:    2.8 MB
  rows:    151,924

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-08 04:04:00	SPY	ETF	266.75	266.75	266.75	266.75	156.0
2018-05-08 04:12:00	SPY	ETF	266.63	266.63	266.63	266.63	200.0
2018-05-08 04:14:00	SPY	ETF	266.53	266.53	266.53	266.53	427.0
2018-05-08 04:18:00	SPY	ETF	266.35	266.35	266.35	266.35	200.0
2018-05-08 04:23:00	SPY	ETF	266.45	266.45	266.45	266.45	108.0
2018-05-08 04:31:00	SPY	ETF	266.32	266.32	266.3	266.3	368.0
2018-05-08 04:33:00	SPY	ETF	266.3	266.3	266.3	266.3	300.0
2018-05-08 04:34:00	SPY	ETF	266.33	266.33	266.33	266.33	904.0
2018-05-08 04:37:00	SPY	ETF	266.28	266.3	266.28	266.3	823.0
2018-05-08 04:38:00	SPY	ETF	266.3	266.3	266.3	266.3	400.0
2018-05-08 04:39:00	SPY	ETF	266.25	266.25	266.21	266.21	231.0
2018-05-08 04:40:00	SPY	ETF	266.19	266.19	266.13	266.13	404.0
2018-05-08 04:41:00	SPY	ETF	266.2	266.2	266.2	266.2	624.0
2018-05-08 04:42:00	SPY	ETF	266.31	266.31	266.27	266.27	412.0
2018-05-08 04:44:00	SPY	ETF	266.38	266.38	266.38	266.38	500.0
2018-05-08 04:47:00	SPY	ETF	266.33	266.33	266.33	266.33	500.0
2018-05-08 04:49:00	SPY	ETF	266.33	266.33	266.33	266.33	300.0
2018-05-08 04:54:00	SPY	ETF	266.42	266.42	266.42	266.42	2000.0
2018-05-08 04:56:00	SPY	ETF	266.43	266.43	266.43	266.43	400.0
2018-05-08 05:00:00	SPY	ETF	266.38	266.38	266.38	266.38	2804.0
2018-05-08 05:02:00	SPY	ETF	266.28	266.28	266.28	266.28	1004.0
2018-05-08 05:03:00	SPY	ETF	266.3	266.36	266.3	266.36	1300.0
2018-05-08 05:05:00	SPY	ETF	266.33	266.33	266.33	266.33	300.0
2018-05-08 05:06:00	SPY	ETF	266.17	266.17	266.17	266.17	118.0
2018-05-08 05:10:00	SPY	ETF	266.18	266.18	266.06	266.06	522.0
2018-05-08 05:11:00	SPY	ETF	266.03	266.03	266.03	266.03	1110.0
2018-05-08 05:12:00	SPY	ETF	266.03	266.03	266.03	266.03	200.0
2018-05-08 05:14:00	SPY	ETF	265.96	265.96	265.93	265.93	200.0
2018-05-08 05:15:00	SPY	ETF	265.89	265.89	265.89	265.89	133.0
2018-05-08 05:17:00	SPY	ETF	265.91	265.91	265.91	265.91	800.0
2018-05-08 05:23:00	SPY	ETF	266.01	266.01	266.01	266.01	504.0
2018-05-08 05:25:00	SPY	ETF	265.92	265.92	265.88	265.88	608.0
2018-05-08 05:26:00	SPY	ETF	266.04	266.04	266.03	266.03	898.0
2018-05-08 05:28:00	SPY	ETF	266.03	266.03	266.03	266.03	500.0
2018-05-08 05:34:00	SPY	ETF	266.14	266.14	266.14	266.14	100.0
2018-05-08 05:36:00	SPY	ETF	266.23	266.23	266.23	266.23	250.0
2018-05-08 05:37:00	SPY	ETF	266.19	266.19	266.19	266.19	404.0
2018-05-08 05:45:00	SPY	ETF	266.07	266.07	266.07	266.07	131.0
2018-05-08 05:50:00	SPY	ETF	266.18	266.18	266.18	266.18	800.0
2018-05-08 05:51:00	SPY	ETF	266.21	266.21	266.21	266.21	100.0
2018-05-08 05:54:00	SPY	ETF	266.15	266.18	266.15	266.18	200.0
2018-05-08 05:55:00	SPY	ETF	266.19	266.19	266.09	266.09	807.0
2018-05-08 05:56:00	SPY	ETF	266.11	266.11	266.11	266.11	300.0
2018-05-08 05:58:00	SPY	ETF	266.13	266.13	266.13	266.13	600.0
2018-05-08 06:01:00	SPY	ETF	266.22	266.27	266.22	266.27	1279.0
2018-05-08 06:03:00	SPY	ETF	266.24	266.24	266.24	266.24	335.0
2018-05-08 06:04:00	SPY	ETF	266.24	266.3	266.24	266.3	1342.0
2018-05-08 06:07:00	SPY	ETF	266.33	266.33	266.33	266.33	100.0
2018-05-08 06:09:00	SPY	ETF	266.33	266.33	266.33	266.33	100.0
2018-05-08 06:10:00	SPY	ETF	266.33	266.33	266.33	266.33	100.0

> showing 50 of 151,924 rows — these rows as CSV

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