PREVIEW / etf_1min / 2018-12-27

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-12-27.parquet
  size:    4.4 MB
  rows:    225,735

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-12-27 04:00:00	SPY	ETF	243.88	243.88	243.72	243.81	7452.0
2018-12-27 04:01:00	SPY	ETF	243.99	243.99	243.99	243.99	415.0
2018-12-27 04:02:00	SPY	ETF	243.85	243.85	243.75	243.75	3577.0
2018-12-27 04:03:00	SPY	ETF	243.65	243.65	243.65	243.65	420.0
2018-12-27 04:04:00	SPY	ETF	243.61	243.61	243.5	243.5	971.0
2018-12-27 04:05:00	SPY	ETF	243.5	243.5	243.5	243.5	610.0
2018-12-27 04:06:00	SPY	ETF	243.5	243.5	243.5	243.5	389.0
2018-12-27 04:07:00	SPY	ETF	243.55	243.55	243.55	243.55	250.0
2018-12-27 04:08:00	SPY	ETF	243.6	243.6	243.6	243.6	241.0
2018-12-27 04:09:00	SPY	ETF	243.6	243.68	243.6	243.65	1478.0
2018-12-27 04:10:00	SPY	ETF	243.73	243.73	243.73	243.73	600.0
2018-12-27 04:11:00	SPY	ETF	243.57	243.57	243.45	243.55	1823.0
2018-12-27 04:12:00	SPY	ETF	243.51	243.52	243.51	243.52	500.0
2018-12-27 04:13:00	SPY	ETF	243.33	243.33	243.3	243.32	355.0
2018-12-27 04:14:00	SPY	ETF	243.36	243.36	243.27	243.29	1809.0
2018-12-27 04:15:00	SPY	ETF	243.25	243.25	243.25	243.25	604.0
2018-12-27 04:16:00	SPY	ETF	243.15	243.15	243.09	243.14	944.0
2018-12-27 04:17:00	SPY	ETF	243.15	243.15	243.15	243.15	174.0
2018-12-27 04:18:00	SPY	ETF	243.25	243.25	243.25	243.25	150.0
2018-12-27 04:19:00	SPY	ETF	243.25	243.25	243.19	243.2	3474.0
2018-12-27 04:20:00	SPY	ETF	243.18	243.19	243.05	243.05	1007.0
2018-12-27 04:22:00	SPY	ETF	243.13	243.13	242.98	242.98	820.0
2018-12-27 04:23:00	SPY	ETF	243.01	243.01	243.01	243.01	104.0
2018-12-27 04:24:00	SPY	ETF	243.0	243.0	243.0	243.0	104.0
2018-12-27 04:25:00	SPY	ETF	242.85	242.85	242.75	242.8	3526.0
2018-12-27 04:26:00	SPY	ETF	242.75	242.75	242.75	242.75	104.0
2018-12-27 04:27:00	SPY	ETF	242.73	242.83	242.63	242.63	3730.0
2018-12-27 04:28:00	SPY	ETF	242.57	242.57	242.5	242.5	1554.0
2018-12-27 04:29:00	SPY	ETF	242.62	242.77	242.62	242.75	700.0
2018-12-27 04:30:00	SPY	ETF	242.78	242.78	242.78	242.78	500.0
2018-12-27 04:31:00	SPY	ETF	242.67	242.67	242.5	242.5	453.0
2018-12-27 04:32:00	SPY	ETF	242.73	242.77	242.73	242.77	1000.0
2018-12-27 04:33:00	SPY	ETF	242.66	242.66	242.58	242.58	1204.0
2018-12-27 04:34:00	SPY	ETF	242.6	242.6	242.6	242.6	600.0
2018-12-27 04:35:00	SPY	ETF	242.5	242.5	242.5	242.5	180.0
2018-12-27 04:37:00	SPY	ETF	242.44	242.45	242.42	242.42	5164.0
2018-12-27 04:38:00	SPY	ETF	242.52	242.52	242.52	242.52	1000.0
2018-12-27 04:39:00	SPY	ETF	242.4	242.62	242.4	242.56	6479.0
2018-12-27 04:40:00	SPY	ETF	242.6	242.6	242.56	242.56	7021.0
2018-12-27 04:41:00	SPY	ETF	242.5	242.56	242.5	242.56	550.0
2018-12-27 04:42:00	SPY	ETF	242.47	242.5	242.47	242.5	204.0
2018-12-27 04:43:00	SPY	ETF	242.56	242.72	242.56	242.72	995.0
2018-12-27 04:45:00	SPY	ETF	242.69	242.69	242.63	242.63	1500.0
2018-12-27 04:46:00	SPY	ETF	242.53	242.53	242.44	242.44	5904.0
2018-12-27 04:47:00	SPY	ETF	242.44	242.48	242.44	242.45	1750.0
2018-12-27 04:48:00	SPY	ETF	242.44	242.44	242.44	242.44	4118.0
2018-12-27 04:49:00	SPY	ETF	242.37	242.37	242.22	242.22	5939.0
2018-12-27 04:50:00	SPY	ETF	242.36	242.36	242.34	242.34	600.0
2018-12-27 04:51:00	SPY	ETF	242.37	242.37	242.37	242.37	7310.0
2018-12-27 04:52:00	SPY	ETF	242.31	242.31	242.28	242.28	1300.0

> showing 50 of 225,735 rows — these rows as CSV

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