PREVIEW / etf_1min / 2018-10-10

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-10-10.parquet
  size:    3.9 MB
  rows:    193,244

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-10 04:08:00	SPY	ETF	287.45	287.45	287.45	287.45	208.0
2018-10-10 04:09:00	SPY	ETF	287.32	287.32	287.32	287.32	100.0
2018-10-10 04:14:00	SPY	ETF	287.25	287.25	287.25	287.25	200.0
2018-10-10 04:28:00	SPY	ETF	287.21	287.21	287.21	287.21	100.0
2018-10-10 04:34:00	SPY	ETF	287.27	287.27	287.27	287.27	100.0
2018-10-10 04:35:00	SPY	ETF	287.27	287.27	287.27	287.27	115.0
2018-10-10 04:40:00	SPY	ETF	287.47	287.54	287.47	287.54	1000.0
2018-10-10 04:41:00	SPY	ETF	287.51	287.51	287.51	287.51	200.0
2018-10-10 04:46:00	SPY	ETF	287.39	287.39	287.39	287.39	1500.0
2018-10-10 04:51:00	SPY	ETF	287.34	287.34	287.34	287.34	100.0
2018-10-10 04:57:00	SPY	ETF	287.36	287.36	287.36	287.36	696.0
2018-10-10 04:58:00	SPY	ETF	287.39	287.39	287.33	287.33	600.0
2018-10-10 04:59:00	SPY	ETF	287.31	287.31	287.31	287.31	100.0
2018-10-10 05:01:00	SPY	ETF	287.26	287.27	287.26	287.27	900.0
2018-10-10 05:03:00	SPY	ETF	287.24	287.24	287.24	287.24	600.0
2018-10-10 05:24:00	SPY	ETF	287.34	287.39	287.34	287.39	400.0
2018-10-10 05:27:00	SPY	ETF	287.38	287.39	287.38	287.39	1200.0
2018-10-10 05:30:00	SPY	ETF	287.44	287.49	287.44	287.49	300.0
2018-10-10 05:34:00	SPY	ETF	287.42	287.42	287.42	287.42	400.0
2018-10-10 05:35:00	SPY	ETF	287.42	287.42	287.42	287.42	300.0
2018-10-10 05:36:00	SPY	ETF	287.42	287.42	287.42	287.42	300.0
2018-10-10 05:39:00	SPY	ETF	287.41	287.46	287.41	287.46	400.0
2018-10-10 05:42:00	SPY	ETF	287.46	287.46	287.46	287.46	700.0
2018-10-10 05:44:00	SPY	ETF	287.46	287.46	287.46	287.46	400.0
2018-10-10 05:47:00	SPY	ETF	287.41	287.41	287.41	287.41	300.0
2018-10-10 05:54:00	SPY	ETF	287.29	287.29	287.29	287.29	1055.0
2018-10-10 05:55:00	SPY	ETF	287.26	287.26	287.23	287.23	3085.0
2018-10-10 05:57:00	SPY	ETF	287.29	287.29	287.23	287.23	1100.0
2018-10-10 05:58:00	SPY	ETF	287.26	287.26	287.26	287.26	100.0
2018-10-10 05:59:00	SPY	ETF	287.24	287.26	287.24	287.26	300.0
2018-10-10 06:03:00	SPY	ETF	287.34	287.34	287.34	287.34	800.0
2018-10-10 06:05:00	SPY	ETF	287.39	287.39	287.39	287.39	300.0
2018-10-10 06:08:00	SPY	ETF	287.37	287.39	287.37	287.39	1500.0
2018-10-10 06:09:00	SPY	ETF	287.39	287.39	287.39	287.39	300.0
2018-10-10 06:10:00	SPY	ETF	287.36	287.36	287.36	287.36	1000.0
2018-10-10 06:11:00	SPY	ETF	287.35	287.36	287.35	287.36	425.0
2018-10-10 06:17:00	SPY	ETF	287.49	287.51	287.49	287.51	1125.0
2018-10-10 06:28:00	SPY	ETF	287.48	287.48	287.48	287.48	300.0
2018-10-10 06:29:00	SPY	ETF	287.48	287.48	287.48	287.48	100.0
2018-10-10 06:35:00	SPY	ETF	287.59	287.59	287.59	287.59	200.0
2018-10-10 06:36:00	SPY	ETF	287.62	287.62	287.62	287.62	100.0
2018-10-10 06:40:00	SPY	ETF	287.67	287.67	287.67	287.67	4000.0
2018-10-10 06:43:00	SPY	ETF	287.63	287.63	287.63	287.63	200.0
2018-10-10 06:44:00	SPY	ETF	287.64	287.66	287.63	287.63	400.0
2018-10-10 06:48:00	SPY	ETF	287.72	287.74	287.72	287.74	4000.0
2018-10-10 06:49:00	SPY	ETF	287.73	287.74	287.68	287.68	6500.0
2018-10-10 06:52:00	SPY	ETF	287.66	287.66	287.66	287.66	100.0
2018-10-10 06:54:00	SPY	ETF	287.63	287.63	287.63	287.63	100.0
2018-10-10 07:02:00	SPY	ETF	287.59	287.59	287.56	287.56	1345.0
2018-10-10 07:03:00	SPY	ETF	287.59	287.59	287.59	287.59	200.0

> showing 50 of 193,244 rows — these rows as CSV

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