PREVIEW / etf_1min / 2020-01-14

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-01-14.parquet
  size:    3.4 MB
  rows:    179,076

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-14 04:00:00	SPY	ETF	327.31	327.4	327.31	327.4	551.0
2020-01-14 04:01:00	SPY	ETF	327.44	327.44	327.36	327.36	603.0
2020-01-14 04:02:00	SPY	ETF	327.37	327.37	327.36	327.36	1300.0
2020-01-14 04:03:00	SPY	ETF	327.35	327.35	327.35	327.35	400.0
2020-01-14 04:05:00	SPY	ETF	327.43	327.43	327.43	327.43	150.0
2020-01-14 04:07:00	SPY	ETF	327.41	327.41	327.4	327.4	300.0
2020-01-14 04:09:00	SPY	ETF	327.39	327.39	327.39	327.39	1000.0
2020-01-14 04:12:00	SPY	ETF	327.46	327.46	327.46	327.46	1115.0
2020-01-14 04:14:00	SPY	ETF	327.49	327.49	327.44	327.44	600.0
2020-01-14 04:15:00	SPY	ETF	327.46	327.46	327.41	327.41	2970.0
2020-01-14 04:17:00	SPY	ETF	327.46	327.46	327.46	327.46	500.0
2020-01-14 04:19:00	SPY	ETF	327.63	327.63	327.61	327.61	1800.0
2020-01-14 04:29:00	SPY	ETF	327.71	327.74	327.71	327.74	410.0
2020-01-14 04:32:00	SPY	ETF	327.82	327.82	327.82	327.82	100.0
2020-01-14 04:34:00	SPY	ETF	327.83	327.94	327.83	327.94	336.0
2020-01-14 04:35:00	SPY	ETF	327.99	327.99	327.99	327.99	219.0
2020-01-14 04:37:00	SPY	ETF	328.11	328.17	328.06	328.06	705.0
2020-01-14 04:38:00	SPY	ETF	328.11	328.11	328.11	328.11	1000.0
2020-01-14 04:44:00	SPY	ETF	328.0	328.0	328.0	328.0	500.0
2020-01-14 04:46:00	SPY	ETF	327.99	328.07	327.99	328.07	1203.0
2020-01-14 04:48:00	SPY	ETF	328.07	328.07	328.07	328.07	300.0
2020-01-14 04:50:00	SPY	ETF	328.1	328.1	328.1	328.1	500.0
2020-01-14 04:51:00	SPY	ETF	328.18	328.34	328.18	328.29	2400.0
2020-01-14 04:54:00	SPY	ETF	328.16	328.16	328.16	328.16	300.0
2020-01-14 05:01:00	SPY	ETF	328.14	328.14	328.14	328.14	1000.0
2020-01-14 05:02:00	SPY	ETF	328.13	328.13	328.07	328.07	4803.0
2020-01-14 05:03:00	SPY	ETF	328.09	328.11	328.09	328.11	700.0
2020-01-14 05:04:00	SPY	ETF	328.1	328.1	328.1	328.1	500.0
2020-01-14 05:07:00	SPY	ETF	328.01	328.02	327.96	328.02	2201.0
2020-01-14 05:09:00	SPY	ETF	328.01	328.01	328.01	328.01	600.0
2020-01-14 05:10:00	SPY	ETF	328.02	328.02	328.02	328.02	500.0
2020-01-14 05:11:00	SPY	ETF	328.03	328.03	328.03	328.03	300.0
2020-01-14 05:15:00	SPY	ETF	328.21	328.22	328.21	328.22	1200.0
2020-01-14 05:20:00	SPY	ETF	328.21	328.21	328.21	328.21	500.0
2020-01-14 05:23:00	SPY	ETF	328.14	328.14	328.14	328.14	200.0
2020-01-14 05:24:00	SPY	ETF	328.13	328.13	328.1	328.1	2803.0
2020-01-14 05:31:00	SPY	ETF	328.02	328.02	328.02	328.02	150.0
2020-01-14 05:33:00	SPY	ETF	327.98	327.98	327.97	327.98	1988.0
2020-01-14 05:38:00	SPY	ETF	327.93	327.93	327.93	327.93	505.0
2020-01-14 05:43:00	SPY	ETF	327.93	327.93	327.93	327.93	170.0
2020-01-14 05:44:00	SPY	ETF	327.91	327.91	327.91	327.91	600.0
2020-01-14 05:45:00	SPY	ETF	327.93	327.93	327.93	327.93	200.0
2020-01-14 05:47:00	SPY	ETF	327.85	327.85	327.78	327.78	700.0
2020-01-14 05:48:00	SPY	ETF	327.6	327.6	327.53	327.53	557.0
2020-01-14 05:49:00	SPY	ETF	327.5	327.61	327.5	327.61	800.0
2020-01-14 05:51:00	SPY	ETF	327.63	327.63	327.61	327.61	1900.0
2020-01-14 05:52:00	SPY	ETF	327.65	327.65	327.65	327.65	1000.0
2020-01-14 05:55:00	SPY	ETF	327.72	327.73	327.72	327.73	1000.0
2020-01-14 05:59:00	SPY	ETF	327.73	327.73	327.73	327.73	101.0
2020-01-14 06:00:00	SPY	ETF	327.7	327.7	327.66	327.66	1301.0

> showing 50 of 179,076 rows — these rows as CSV

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