PREVIEW / etf_1min / 2020-01-27

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-01-27.parquet
  size:    3.9 MB
  rows:    202,157

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
2020-01-27 04:00:00	SPY	ETF	325.61	325.61	325.41	325.57	8361.0
2020-01-27 04:01:00	SPY	ETF	325.41	325.46	325.39	325.39	1626.0
2020-01-27 04:02:00	SPY	ETF	325.44	325.46	325.39	325.39	1275.0
2020-01-27 04:03:00	SPY	ETF	325.4	325.42	325.4	325.4	1500.0
2020-01-27 04:04:00	SPY	ETF	325.4	325.46	325.34	325.43	7700.0
2020-01-27 04:05:00	SPY	ETF	325.45	325.45	325.38	325.44	1968.0
2020-01-27 04:06:00	SPY	ETF	325.39	325.42	325.39	325.42	407.0
2020-01-27 04:07:00	SPY	ETF	325.34	325.34	325.34	325.34	200.0
2020-01-27 04:08:00	SPY	ETF	325.35	325.35	325.3	325.33	600.0
2020-01-27 04:09:00	SPY	ETF	325.26	325.34	325.26	325.34	817.0
2020-01-27 04:10:00	SPY	ETF	325.4	325.45	325.4	325.45	5200.0
2020-01-27 04:11:00	SPY	ETF	325.47	325.47	325.47	325.47	466.0
2020-01-27 04:12:00	SPY	ETF	325.35	325.35	325.26	325.26	1600.0
2020-01-27 04:13:00	SPY	ETF	325.25	325.25	325.16	325.19	1200.0
2020-01-27 04:15:00	SPY	ETF	325.14	325.17	325.13	325.17	2599.0
2020-01-27 04:16:00	SPY	ETF	325.1	325.1	325.0	325.0	3188.0
2020-01-27 04:17:00	SPY	ETF	325.0	325.0	324.93	324.94	2769.0
2020-01-27 04:18:00	SPY	ETF	324.94	324.94	324.93	324.93	2800.0
2020-01-27 04:19:00	SPY	ETF	324.91	324.91	324.84	324.84	701.0
2020-01-27 04:20:00	SPY	ETF	324.99	324.99	324.99	324.99	130.0
2020-01-27 04:21:00	SPY	ETF	325.0	325.07	325.0	325.07	5873.0
2020-01-27 04:22:00	SPY	ETF	324.94	324.94	324.94	324.94	260.0
2020-01-27 04:23:00	SPY	ETF	325.0	325.09	324.98	324.98	6100.0
2020-01-27 04:25:00	SPY	ETF	325.04	325.04	325.04	325.04	150.0
2020-01-27 04:26:00	SPY	ETF	324.9	324.96	324.89	324.94	630.0
2020-01-27 04:27:00	SPY	ETF	324.88	324.88	324.88	324.88	150.0
2020-01-27 04:28:00	SPY	ETF	324.78	324.78	324.73	324.73	8901.0
2020-01-27 04:29:00	SPY	ETF	324.78	324.83	324.78	324.83	2200.0
2020-01-27 04:30:00	SPY	ETF	324.78	324.88	324.78	324.88	5205.0
2020-01-27 04:31:00	SPY	ETF	324.78	324.78	324.78	324.78	157.0
2020-01-27 04:32:00	SPY	ETF	324.75	324.75	324.74	324.74	1550.0
2020-01-27 04:33:00	SPY	ETF	324.78	324.78	324.76	324.76	315.0
2020-01-27 04:34:00	SPY	ETF	324.8	324.8	324.77	324.77	450.0
2020-01-27 04:35:00	SPY	ETF	324.76	324.76	324.69	324.69	2551.0
2020-01-27 04:36:00	SPY	ETF	324.65	324.65	324.65	324.65	1551.0
2020-01-27 04:37:00	SPY	ETF	324.65	324.65	324.65	324.65	200.0
2020-01-27 04:38:00	SPY	ETF	324.6	324.65	324.6	324.65	891.0
2020-01-27 04:39:00	SPY	ETF	324.58	324.58	324.58	324.58	305.0
2020-01-27 04:40:00	SPY	ETF	324.65	324.65	324.65	324.65	200.0
2020-01-27 04:41:00	SPY	ETF	324.65	324.65	324.65	324.65	104.0
2020-01-27 04:42:00	SPY	ETF	324.65	324.65	324.58	324.58	298.0
2020-01-27 04:43:00	SPY	ETF	324.52	324.52	324.5	324.5	3163.0
2020-01-27 04:45:00	SPY	ETF	324.47	324.47	324.47	324.47	230.0
2020-01-27 04:46:00	SPY	ETF	324.53	324.53	324.5	324.5	450.0
2020-01-27 04:47:00	SPY	ETF	324.49	324.49	324.49	324.49	330.0
2020-01-27 04:48:00	SPY	ETF	324.42	324.42	324.4	324.4	2663.0
2020-01-27 04:49:00	SPY	ETF	324.32	324.32	324.32	324.32	600.0
2020-01-27 04:52:00	SPY	ETF	324.48	324.48	324.42	324.42	200.0
2020-01-27 04:53:00	SPY	ETF	324.51	324.56	324.51	324.56	1380.0
2020-01-27 04:54:00	SPY	ETF	324.58	324.6	324.58	324.6	1850.0

> showing 50 of 202,157 rows — these rows as CSV

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