PREVIEW / etf_1min / 2020-01-10

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-01-10.parquet
  size:    3.4 MB
  rows:    172,299

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-10 04:01:00	SPY	ETF	327.22	327.22	327.22	327.22	100.0
2020-01-10 04:03:00	SPY	ETF	327.2	327.2	327.2	327.2	100.0
2020-01-10 04:08:00	SPY	ETF	327.15	327.15	327.15	327.15	540.0
2020-01-10 04:09:00	SPY	ETF	327.17	327.19	327.17	327.19	1327.0
2020-01-10 04:21:00	SPY	ETF	327.21	327.21	327.21	327.21	100.0
2020-01-10 04:23:00	SPY	ETF	327.25	327.25	327.25	327.25	100.0
2020-01-10 04:24:00	SPY	ETF	327.25	327.29	327.25	327.29	500.0
2020-01-10 04:28:00	SPY	ETF	327.3	327.3	327.3	327.3	350.0
2020-01-10 04:33:00	SPY	ETF	327.33	327.33	327.33	327.33	100.0
2020-01-10 04:38:00	SPY	ETF	327.36	327.36	327.36	327.36	500.0
2020-01-10 04:42:00	SPY	ETF	327.32	327.32	327.32	327.32	100.0
2020-01-10 04:47:00	SPY	ETF	327.39	327.41	327.39	327.41	910.0
2020-01-10 04:49:00	SPY	ETF	327.4	327.4	327.4	327.4	199.0
2020-01-10 04:50:00	SPY	ETF	327.37	327.37	327.37	327.37	300.0
2020-01-10 04:55:00	SPY	ETF	327.4	327.4	327.4	327.4	100.0
2020-01-10 04:56:00	SPY	ETF	327.41	327.41	327.41	327.41	100.0
2020-01-10 04:58:00	SPY	ETF	327.4	327.4	327.4	327.4	300.0
2020-01-10 05:08:00	SPY	ETF	327.43	327.43	327.43	327.43	300.0
2020-01-10 05:10:00	SPY	ETF	327.44	327.44	327.44	327.44	200.0
2020-01-10 05:13:00	SPY	ETF	327.48	327.48	327.48	327.48	100.0
2020-01-10 05:14:00	SPY	ETF	327.5	327.5	327.5	327.5	500.0
2020-01-10 05:28:00	SPY	ETF	327.41	327.41	327.41	327.41	150.0
2020-01-10 05:33:00	SPY	ETF	327.49	327.49	327.49	327.49	300.0
2020-01-10 05:36:00	SPY	ETF	327.49	327.5	327.49	327.5	673.0
2020-01-10 05:37:00	SPY	ETF	327.49	327.49	327.49	327.49	497.0
2020-01-10 05:40:00	SPY	ETF	327.49	327.49	327.49	327.49	300.0
2020-01-10 05:44:00	SPY	ETF	327.46	327.46	327.46	327.46	500.0
2020-01-10 05:56:00	SPY	ETF	327.44	327.44	327.44	327.44	300.0
2020-01-10 05:59:00	SPY	ETF	327.42	327.42	327.42	327.42	100.0
2020-01-10 06:00:00	SPY	ETF	327.41	327.41	327.41	327.41	700.0
2020-01-10 06:06:00	SPY	ETF	327.43	327.43	327.43	327.43	100.0
2020-01-10 06:09:00	SPY	ETF	327.51	327.51	327.51	327.51	400.0
2020-01-10 06:11:00	SPY	ETF	327.53	327.55	327.53	327.55	813.0
2020-01-10 06:14:00	SPY	ETF	327.51	327.51	327.51	327.51	100.0
2020-01-10 06:15:00	SPY	ETF	327.51	327.51	327.51	327.51	440.0
2020-01-10 06:18:00	SPY	ETF	327.53	327.53	327.53	327.53	110.0
2020-01-10 06:19:00	SPY	ETF	327.59	327.6	327.59	327.6	2490.0
2020-01-10 06:20:00	SPY	ETF	327.56	327.59	327.56	327.59	900.0
2020-01-10 06:22:00	SPY	ETF	327.56	327.56	327.56	327.56	100.0
2020-01-10 06:24:00	SPY	ETF	327.63	327.71	327.63	327.71	5921.0
2020-01-10 06:26:00	SPY	ETF	327.68	327.73	327.68	327.73	2443.0
2020-01-10 06:27:00	SPY	ETF	327.71	327.71	327.71	327.71	310.0
2020-01-10 06:28:00	SPY	ETF	327.7	327.7	327.7	327.7	603.0
2020-01-10 06:31:00	SPY	ETF	327.68	327.71	327.68	327.71	1197.0
2020-01-10 06:32:00	SPY	ETF	327.73	327.74	327.73	327.74	610.0
2020-01-10 06:33:00	SPY	ETF	327.72	327.72	327.72	327.72	100.0
2020-01-10 06:34:00	SPY	ETF	327.71	327.72	327.71	327.72	1550.0
2020-01-10 06:42:00	SPY	ETF	327.62	327.62	327.62	327.62	204.0
2020-01-10 06:44:00	SPY	ETF	327.6	327.6	327.6	327.6	110.0
2020-01-10 06:49:00	SPY	ETF	327.62	327.62	327.62	327.62	200.0

> showing 50 of 172,299 rows — these rows as CSV

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