PREVIEW / etf_1min / 2019-05-07

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-05-07.parquet
  size:    3.6 MB
  rows:    185,107

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
2019-05-07 04:00:00	SPY	ETF	291.81	292.0	291.81	292.0	1611.0
2019-05-07 04:01:00	SPY	ETF	291.95	291.95	291.95	291.95	3010.0
2019-05-07 04:02:00	SPY	ETF	292.0	292.07	292.0	292.07	20304.0
2019-05-07 04:05:00	SPY	ETF	291.85	291.85	291.85	291.85	100.0
2019-05-07 04:09:00	SPY	ETF	291.85	291.85	291.85	291.85	150.0
2019-05-07 04:10:00	SPY	ETF	291.85	291.85	291.85	291.85	154.0
2019-05-07 04:14:00	SPY	ETF	291.85	291.85	291.85	291.85	515.0
2019-05-07 04:21:00	SPY	ETF	291.73	291.75	291.73	291.75	350.0
2019-05-07 04:31:00	SPY	ETF	291.81	291.81	291.81	291.81	1015.0
2019-05-07 04:34:00	SPY	ETF	291.7	291.7	291.7	291.7	200.0
2019-05-07 04:36:00	SPY	ETF	291.75	291.75	291.75	291.75	1000.0
2019-05-07 04:40:00	SPY	ETF	291.7	291.7	291.7	291.7	700.0
2019-05-07 04:43:00	SPY	ETF	291.71	291.71	291.71	291.71	1300.0
2019-05-07 04:47:00	SPY	ETF	291.7	291.7	291.7	291.7	2000.0
2019-05-07 04:56:00	SPY	ETF	291.5	291.5	291.5	291.5	750.0
2019-05-07 04:58:00	SPY	ETF	291.56	291.56	291.56	291.56	500.0
2019-05-07 04:59:00	SPY	ETF	291.53	291.53	291.48	291.48	1330.0
2019-05-07 05:12:00	SPY	ETF	291.41	291.42	291.41	291.42	300.0
2019-05-07 05:18:00	SPY	ETF	291.46	291.46	291.46	291.46	100.0
2019-05-07 05:23:00	SPY	ETF	291.38	291.38	291.38	291.38	100.0
2019-05-07 05:25:00	SPY	ETF	291.4	291.4	291.4	291.4	300.0
2019-05-07 05:28:00	SPY	ETF	291.37	291.37	291.37	291.37	100.0
2019-05-07 05:30:00	SPY	ETF	291.25	291.25	291.25	291.25	704.0
2019-05-07 05:33:00	SPY	ETF	291.16	291.16	291.16	291.16	111.0
2019-05-07 05:34:00	SPY	ETF	291.21	291.21	291.21	291.21	100.0
2019-05-07 05:37:00	SPY	ETF	291.15	291.15	291.15	291.15	100.0
2019-05-07 05:42:00	SPY	ETF	291.26	291.26	291.26	291.26	2000.0
2019-05-07 05:47:00	SPY	ETF	291.32	291.32	291.32	291.32	104.0
2019-05-07 05:51:00	SPY	ETF	291.36	291.36	291.36	291.36	601.0
2019-05-07 05:52:00	SPY	ETF	291.4	291.43	291.4	291.43	1351.0
2019-05-07 05:56:00	SPY	ETF	291.38	291.38	291.38	291.38	300.0
2019-05-07 05:57:00	SPY	ETF	291.4	291.4	291.4	291.4	204.0
2019-05-07 06:00:00	SPY	ETF	291.39	291.39	291.39	291.39	100.0
2019-05-07 06:01:00	SPY	ETF	291.4	291.4	291.4	291.4	100.0
2019-05-07 06:02:00	SPY	ETF	291.4	291.43	291.4	291.43	2100.0
2019-05-07 06:04:00	SPY	ETF	291.4	291.4	291.4	291.4	500.0
2019-05-07 06:11:00	SPY	ETF	291.3	291.3	291.3	291.3	100.0
2019-05-07 06:21:00	SPY	ETF	291.33	291.33	291.33	291.33	600.0
2019-05-07 06:22:00	SPY	ETF	291.3	291.3	291.3	291.3	600.0
2019-05-07 06:23:00	SPY	ETF	291.3	291.3	291.3	291.3	600.0
2019-05-07 06:28:00	SPY	ETF	291.3	291.3	291.3	291.3	500.0
2019-05-07 06:31:00	SPY	ETF	291.35	291.35	291.35	291.35	400.0
2019-05-07 06:34:00	SPY	ETF	291.3	291.31	291.3	291.31	1500.0
2019-05-07 06:35:00	SPY	ETF	291.35	291.35	291.3	291.3	3500.0
2019-05-07 06:36:00	SPY	ETF	291.35	291.39	291.35	291.38	36000.0
2019-05-07 06:39:00	SPY	ETF	291.38	291.38	291.36	291.37	3615.0
2019-05-07 06:40:00	SPY	ETF	291.38	291.39	291.38	291.38	1600.0
2019-05-07 06:42:00	SPY	ETF	291.39	291.41	291.39	291.41	1000.0
2019-05-07 06:43:00	SPY	ETF	291.39	291.39	291.38	291.38	1580.0
2019-05-07 06:44:00	SPY	ETF	291.36	291.38	291.36	291.38	600.0

> showing 50 of 185,107 rows — these rows as CSV

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