PREVIEW / etf_1min / 2018-10-01

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-10-01.parquet
  size:    3.1 MB
  rows:    161,753

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-10-01 04:00:00	SPY	ETF	292.21	292.38	292.21	292.38	3291.0
2018-10-01 04:01:00	SPY	ETF	292.39	292.39	292.39	292.39	1275.0
2018-10-01 04:04:00	SPY	ETF	292.32	292.38	292.32	292.38	315.0
2018-10-01 04:10:00	SPY	ETF	292.43	292.43	292.43	292.43	500.0
2018-10-01 04:13:00	SPY	ETF	292.34	292.34	292.34	292.34	170.0
2018-10-01 04:18:00	SPY	ETF	292.4	292.4	292.4	292.4	256.0
2018-10-01 04:27:00	SPY	ETF	292.45	292.47	292.45	292.47	369.0
2018-10-01 04:29:00	SPY	ETF	292.34	292.47	292.34	292.47	3500.0
2018-10-01 04:36:00	SPY	ETF	292.33	292.33	292.33	292.33	200.0
2018-10-01 04:37:00	SPY	ETF	292.39	292.39	292.39	292.39	302.0
2018-10-01 04:38:00	SPY	ETF	292.33	292.33	292.33	292.33	100.0
2018-10-01 04:53:00	SPY	ETF	292.47	292.47	292.47	292.47	706.0
2018-10-01 04:56:00	SPY	ETF	292.47	292.47	292.47	292.47	100.0
2018-10-01 05:05:00	SPY	ETF	292.41	292.41	292.41	292.41	100.0
2018-10-01 05:09:00	SPY	ETF	292.43	292.43	292.43	292.43	500.0
2018-10-01 05:10:00	SPY	ETF	292.41	292.41	292.41	292.41	100.0
2018-10-01 05:16:00	SPY	ETF	292.4	292.4	292.4	292.4	100.0
2018-10-01 05:17:00	SPY	ETF	292.36	292.36	292.36	292.36	402.0
2018-10-01 05:19:00	SPY	ETF	292.45	292.45	292.45	292.45	198.0
2018-10-01 05:22:00	SPY	ETF	292.36	292.36	292.36	292.36	638.0
2018-10-01 05:24:00	SPY	ETF	292.36	292.36	292.36	292.36	150.0
2018-10-01 05:26:00	SPY	ETF	292.33	292.33	292.33	292.33	6500.0
2018-10-01 05:27:00	SPY	ETF	292.33	292.33	292.33	292.33	3500.0
2018-10-01 05:28:00	SPY	ETF	292.37	292.37	292.37	292.37	500.0
2018-10-01 05:31:00	SPY	ETF	292.37	292.37	292.37	292.37	10000.0
2018-10-01 05:32:00	SPY	ETF	292.37	292.37	292.37	292.37	10000.0
2018-10-01 05:34:00	SPY	ETF	292.38	292.38	292.38	292.38	2520.0
2018-10-01 05:35:00	SPY	ETF	292.38	292.38	292.38	292.38	5002.0
2018-10-01 05:38:00	SPY	ETF	292.35	292.35	292.35	292.35	300.0
2018-10-01 05:40:00	SPY	ETF	292.35	292.38	292.35	292.38	12180.0
2018-10-01 05:44:00	SPY	ETF	292.4	292.4	292.4	292.4	200.0
2018-10-01 05:49:00	SPY	ETF	292.39	292.46	292.39	292.39	10000.0
2018-10-01 05:58:00	SPY	ETF	292.41	292.41	292.41	292.41	2400.0
2018-10-01 06:00:00	SPY	ETF	292.46	292.46	292.46	292.46	202.0
2018-10-01 06:01:00	SPY	ETF	292.42	292.42	292.42	292.42	600.0
2018-10-01 06:02:00	SPY	ETF	292.36	292.36	292.36	292.36	600.0
2018-10-01 06:03:00	SPY	ETF	292.42	292.42	292.42	292.42	500.0
2018-10-01 06:06:00	SPY	ETF	292.44	292.44	292.44	292.44	180.0
2018-10-01 06:09:00	SPY	ETF	292.37	292.39	292.37	292.37	1000.0
2018-10-01 06:11:00	SPY	ETF	292.39	292.39	292.39	292.39	300.0
2018-10-01 06:13:00	SPY	ETF	292.42	292.42	292.42	292.42	310.0
2018-10-01 06:14:00	SPY	ETF	292.39	292.4	292.39	292.4	2700.0
2018-10-01 06:20:00	SPY	ETF	292.32	292.32	292.32	292.32	240.0
2018-10-01 06:27:00	SPY	ETF	292.22	292.27	292.22	292.27	1100.0
2018-10-01 06:30:00	SPY	ETF	292.4	292.4	292.4	292.4	1000.0
2018-10-01 06:33:00	SPY	ETF	292.35	292.35	292.35	292.35	800.0
2018-10-01 06:36:00	SPY	ETF	292.24	292.24	292.2	292.2	10000.0
2018-10-01 06:38:00	SPY	ETF	292.28	292.37	292.28	292.37	400.0
2018-10-01 06:42:00	SPY	ETF	292.39	292.41	292.39	292.41	900.0
2018-10-01 06:45:00	SPY	ETF	292.41	292.42	292.41	292.42	600.0

> showing 50 of 161,753 rows — these rows as CSV

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