PREVIEW / etf_1min / 2020-01-17

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-01-17.parquet
  size:    3.3 MB
  rows:    173,731

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-17 04:00:00	SPY	ETF	331.4	331.4	331.4	331.4	553.0
2020-01-17 04:03:00	SPY	ETF	331.46	331.46	331.46	331.46	150.0
2020-01-17 04:06:00	SPY	ETF	331.43	331.43	331.42	331.42	200.0
2020-01-17 04:11:00	SPY	ETF	331.5	331.5	331.5	331.5	200.0
2020-01-17 04:14:00	SPY	ETF	331.54	331.54	331.54	331.54	200.0
2020-01-17 04:15:00	SPY	ETF	331.55	331.55	331.55	331.55	100.0
2020-01-17 04:19:00	SPY	ETF	331.55	331.55	331.55	331.55	101.0
2020-01-17 04:27:00	SPY	ETF	331.54	331.54	331.54	331.54	400.0
2020-01-17 04:30:00	SPY	ETF	331.51	331.51	331.51	331.51	266.0
2020-01-17 04:37:00	SPY	ETF	331.47	331.48	331.47	331.48	300.0
2020-01-17 04:38:00	SPY	ETF	331.48	331.48	331.48	331.48	200.0
2020-01-17 04:46:00	SPY	ETF	331.47	331.47	331.47	331.47	2500.0
2020-01-17 04:51:00	SPY	ETF	331.58	331.58	331.58	331.58	701.0
2020-01-17 04:59:00	SPY	ETF	331.59	331.59	331.59	331.59	100.0
2020-01-17 05:09:00	SPY	ETF	331.69	331.69	331.69	331.69	225.0
2020-01-17 05:10:00	SPY	ETF	331.66	331.66	331.66	331.66	2005.0
2020-01-17 05:17:00	SPY	ETF	331.75	331.75	331.75	331.75	400.0
2020-01-17 05:18:00	SPY	ETF	331.89	331.89	331.89	331.89	2100.0
2020-01-17 05:20:00	SPY	ETF	331.79	331.79	331.79	331.79	400.0
2020-01-17 05:21:00	SPY	ETF	331.75	331.75	331.75	331.75	900.0
2020-01-17 05:23:00	SPY	ETF	331.74	331.74	331.74	331.74	100.0
2020-01-17 05:31:00	SPY	ETF	331.61	331.61	331.61	331.61	200.0
2020-01-17 05:43:00	SPY	ETF	331.64	331.64	331.64	331.64	150.0
2020-01-17 05:44:00	SPY	ETF	331.64	331.65	331.64	331.65	200.0
2020-01-17 05:51:00	SPY	ETF	331.67	331.67	331.67	331.67	300.0
2020-01-17 05:55:00	SPY	ETF	331.65	331.65	331.65	331.65	115.0
2020-01-17 05:57:00	SPY	ETF	331.65	331.65	331.65	331.65	285.0
2020-01-17 05:58:00	SPY	ETF	331.6	331.6	331.6	331.6	300.0
2020-01-17 05:59:00	SPY	ETF	331.6	331.6	331.6	331.6	400.0
2020-01-17 06:00:00	SPY	ETF	331.63	331.63	331.63	331.63	220.0
2020-01-17 06:08:00	SPY	ETF	331.64	331.66	331.64	331.66	360.0
2020-01-17 06:10:00	SPY	ETF	331.64	331.64	331.63	331.63	575.0
2020-01-17 06:13:00	SPY	ETF	331.58	331.59	331.58	331.59	500.0
2020-01-17 06:14:00	SPY	ETF	331.51	331.51	331.51	331.51	525.0
2020-01-17 06:18:00	SPY	ETF	331.6	331.61	331.6	331.61	1030.0
2020-01-17 06:19:00	SPY	ETF	331.6	331.6	331.6	331.6	100.0
2020-01-17 06:21:00	SPY	ETF	331.6	331.6	331.6	331.6	105.0
2020-01-17 06:25:00	SPY	ETF	331.66	331.66	331.66	331.66	105.0
2020-01-17 06:29:00	SPY	ETF	331.63	331.66	331.63	331.66	301.0
2020-01-17 06:33:00	SPY	ETF	331.6	331.6	331.6	331.6	5000.0
2020-01-17 06:40:00	SPY	ETF	331.69	331.69	331.69	331.69	204.0
2020-01-17 06:41:00	SPY	ETF	331.69	331.69	331.69	331.69	161.0
2020-01-17 06:43:00	SPY	ETF	331.6	331.66	331.6	331.6	5200.0
2020-01-17 06:44:00	SPY	ETF	331.66	331.66	331.66	331.66	1000.0
2020-01-17 06:45:00	SPY	ETF	331.66	331.66	331.66	331.66	1000.0
2020-01-17 06:47:00	SPY	ETF	331.6	331.66	331.6	331.66	900.0
2020-01-17 06:48:00	SPY	ETF	331.66	331.66	331.66	331.66	410.0
2020-01-17 06:52:00	SPY	ETF	331.6	331.6	331.6	331.6	100.0
2020-01-17 06:53:00	SPY	ETF	331.63	331.63	331.63	331.63	530.0
2020-01-17 06:54:00	SPY	ETF	331.6	331.63	331.6	331.63	1216.0

> showing 50 of 173,731 rows — these rows as CSV

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