PREVIEW / etf_1min / 2020-02-03

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-02-03.parquet
  size:    3.7 MB
  rows:    192,371

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-02-03 04:00:00	SPY	ETF	323.5	323.5	323.44	323.44	3051.0
2020-02-03 04:01:00	SPY	ETF	323.5	323.5	323.42	323.42	1409.0
2020-02-03 04:02:00	SPY	ETF	323.4	323.4	323.3	323.3	1300.0
2020-02-03 04:03:00	SPY	ETF	323.28	323.42	323.28	323.42	3127.0
2020-02-03 04:04:00	SPY	ETF	323.32	323.32	323.0	323.32	1100.0
2020-02-03 04:05:00	SPY	ETF	323.33	323.33	323.28	323.28	1900.0
2020-02-03 04:06:00	SPY	ETF	323.33	323.36	323.3	323.36	2550.0
2020-02-03 04:07:00	SPY	ETF	323.35	323.35	323.35	323.35	108.0
2020-02-03 04:08:00	SPY	ETF	323.21	323.21	323.07	323.17	4880.0
2020-02-03 04:09:00	SPY	ETF	323.19	323.19	323.19	323.19	20161.0
2020-02-03 04:11:00	SPY	ETF	323.22	323.22	323.22	323.22	100.0
2020-02-03 04:12:00	SPY	ETF	323.2	323.29	323.11	323.29	17410.0
2020-02-03 04:13:00	SPY	ETF	323.29	323.29	323.29	323.29	4004.0
2020-02-03 04:14:00	SPY	ETF	323.39	323.39	323.39	323.39	550.0
2020-02-03 04:15:00	SPY	ETF	323.39	323.39	323.39	323.39	300.0
2020-02-03 04:16:00	SPY	ETF	323.46	323.52	323.46	323.52	10700.0
2020-02-03 04:17:00	SPY	ETF	323.52	323.52	323.52	323.52	300.0
2020-02-03 04:19:00	SPY	ETF	323.31	323.31	323.31	323.31	200.0
2020-02-03 04:21:00	SPY	ETF	323.21	323.21	323.14	323.14	1100.0
2020-02-03 04:22:00	SPY	ETF	323.16	323.16	323.16	323.16	146.0
2020-02-03 04:23:00	SPY	ETF	323.14	323.14	323.14	323.14	450.0
2020-02-03 04:24:00	SPY	ETF	323.19	323.19	323.19	323.19	100.0
2020-02-03 04:31:00	SPY	ETF	323.01	323.01	323.0	323.0	4103.0
2020-02-03 04:32:00	SPY	ETF	323.04	323.04	323.04	323.04	100.0
2020-02-03 04:33:00	SPY	ETF	323.07	323.07	323.07	323.07	500.0
2020-02-03 04:34:00	SPY	ETF	323.15	323.15	323.14	323.14	350.0
2020-02-03 04:37:00	SPY	ETF	323.0	323.0	323.0	323.0	100.0
2020-02-03 04:42:00	SPY	ETF	323.05	323.05	323.05	323.05	117.0
2020-02-03 04:44:00	SPY	ETF	322.99	322.99	322.99	322.99	750.0
2020-02-03 04:45:00	SPY	ETF	322.84	322.84	322.82	322.82	400.0
2020-02-03 04:46:00	SPY	ETF	322.9	322.9	322.9	322.9	100.0
2020-02-03 04:47:00	SPY	ETF	322.95	322.97	322.95	322.97	885.0
2020-02-03 04:48:00	SPY	ETF	322.94	323.0	322.94	323.0	1376.0
2020-02-03 04:49:00	SPY	ETF	322.97	323.02	322.97	323.02	2350.0
2020-02-03 04:50:00	SPY	ETF	323.05	323.09	323.05	323.09	212.0
2020-02-03 04:51:00	SPY	ETF	323.07	323.07	323.07	323.07	930.0
2020-02-03 04:52:00	SPY	ETF	323.08	323.08	323.08	323.08	500.0
2020-02-03 04:56:00	SPY	ETF	322.87	322.95	322.87	322.9	1400.0
2020-02-03 04:57:00	SPY	ETF	322.93	322.93	322.93	322.93	100.0
2020-02-03 04:58:00	SPY	ETF	322.98	322.98	322.98	322.98	200.0
2020-02-03 05:01:00	SPY	ETF	322.84	322.87	322.84	322.87	1700.0
2020-02-03 05:02:00	SPY	ETF	322.77	322.77	322.72	322.72	1003.0
2020-02-03 05:04:00	SPY	ETF	322.84	322.84	322.8	322.8	861.0
2020-02-03 05:05:00	SPY	ETF	322.77	322.82	322.77	322.82	1050.0
2020-02-03 05:06:00	SPY	ETF	322.84	322.84	322.84	322.84	1000.0
2020-02-03 05:07:00	SPY	ETF	322.87	322.92	322.87	322.92	700.0
2020-02-03 05:13:00	SPY	ETF	323.3	323.3	323.3	323.3	500.0
2020-02-03 05:16:00	SPY	ETF	323.22	323.22	323.22	323.22	1025.0
2020-02-03 05:17:00	SPY	ETF	323.3	323.3	323.3	323.3	540.0
2020-02-03 05:22:00	SPY	ETF	323.03	323.03	323.03	323.03	125.0

> showing 50 of 192,371 rows — these rows as CSV

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