PREVIEW / etf_1min / 2007-07-31

all etf 1-min files

  file:    by_date/etf_1min/2007/2007-07-31.parquet
  size:    870 KB
  rows:    55,068

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
2007-07-31 05:54:00	SPY	ETF	147.89	147.89	147.89	147.89	5000.0
2007-07-31 06:03:00	SPY	ETF	147.88	147.88	147.88	147.88	500.0
2007-07-31 06:10:00	SPY	ETF	147.91	147.91	147.91	147.91	300.0
2007-07-31 06:15:00	SPY	ETF	147.91	147.91	147.91	147.91	6000.0
2007-07-31 06:41:00	SPY	ETF	148.0	148.0	148.0	148.0	2500.0
2007-07-31 06:44:00	SPY	ETF	148.03	148.03	148.03	148.03	50000.0
2007-07-31 06:46:00	SPY	ETF	148.0	148.0	148.0	148.0	4500.0
2007-07-31 06:47:00	SPY	ETF	148.0	148.0	148.0	148.0	17400.0
2007-07-31 06:52:00	SPY	ETF	148.05	148.05	148.05	148.05	500.0
2007-07-31 06:53:00	SPY	ETF	148.1	148.1	148.1	148.1	500.0
2007-07-31 06:54:00	SPY	ETF	148.13	148.18	148.13	148.18	28100.0
2007-07-31 06:55:00	SPY	ETF	148.15	148.17	148.15	148.17	50000.0
2007-07-31 06:56:00	SPY	ETF	148.15	148.15	148.15	148.15	7500.0
2007-07-31 06:57:00	SPY	ETF	148.13	148.13	148.13	148.13	10000.0
2007-07-31 06:58:00	SPY	ETF	148.15	148.15	148.15	148.15	500.0
2007-07-31 06:59:00	SPY	ETF	148.2	148.2	148.19	148.2	125000.0
2007-07-31 07:00:00	SPY	ETF	148.22	148.29	148.22	148.25	60100.0
2007-07-31 07:01:00	SPY	ETF	148.31	148.33	148.31	148.33	700.0
2007-07-31 07:02:00	SPY	ETF	148.36	148.36	148.36	148.36	12500.0
2007-07-31 07:03:00	SPY	ETF	148.33	148.36	148.33	148.36	91000.0
2007-07-31 07:04:00	SPY	ETF	148.39	148.4	148.36	148.4	94300.0
2007-07-31 07:05:00	SPY	ETF	148.41	148.41	148.4	148.4	9200.0
2007-07-31 07:06:00	SPY	ETF	148.42	148.44	148.42	148.44	44900.0
2007-07-31 07:07:00	SPY	ETF	148.4	148.41	148.36	148.36	65200.0
2007-07-31 07:08:00	SPY	ETF	148.4	148.5	148.36	148.45	143400.0
2007-07-31 07:09:00	SPY	ETF	148.45	148.47	148.39	148.39	129300.0
2007-07-31 07:10:00	SPY	ETF	148.37	148.39	148.36	148.36	7000.0
2007-07-31 07:11:00	SPY	ETF	148.43	148.43	148.39	148.41	72500.0
2007-07-31 07:12:00	SPY	ETF	148.39	148.48	148.37	148.37	231600.0
2007-07-31 07:13:00	SPY	ETF	148.36	148.36	148.32	148.32	17000.0
2007-07-31 07:14:00	SPY	ETF	148.38	148.38	148.38	148.38	15000.0
2007-07-31 07:15:00	SPY	ETF	148.35	148.4	148.35	148.35	37100.0
2007-07-31 07:16:00	SPY	ETF	148.38	148.4	148.35	148.38	50000.0
2007-07-31 07:17:00	SPY	ETF	148.38	148.38	148.38	148.38	2100.0
2007-07-31 07:18:00	SPY	ETF	148.48	148.52	148.48	148.5	24000.0
2007-07-31 07:19:00	SPY	ETF	148.5	148.5	148.5	148.5	33500.0
2007-07-31 07:20:00	SPY	ETF	148.48	148.48	148.48	148.48	20000.0
2007-07-31 07:21:00	SPY	ETF	148.47	148.5	148.47	148.5	50000.0
2007-07-31 07:22:00	SPY	ETF	148.47	148.49	148.46	148.46	56000.0
2007-07-31 07:23:00	SPY	ETF	148.49	148.49	148.49	148.49	5000.0
2007-07-31 07:24:00	SPY	ETF	148.47	148.49	148.45	148.45	81700.0
2007-07-31 07:25:00	SPY	ETF	148.49	148.5	148.43	148.45	63300.0
2007-07-31 07:26:00	SPY	ETF	148.45	148.49	148.42	148.49	40000.0
2007-07-31 07:27:00	SPY	ETF	148.49	148.53	148.49	148.53	99300.0
2007-07-31 07:28:00	SPY	ETF	148.54	148.58	148.54	148.58	218400.0
2007-07-31 07:29:00	SPY	ETF	148.58	148.58	148.56	148.58	148500.0
2007-07-31 07:30:00	SPY	ETF	148.57	148.6	148.55	148.59	64400.0
2007-07-31 07:31:00	SPY	ETF	148.57	148.61	148.54	148.61	37000.0
2007-07-31 07:32:00	SPY	ETF	148.64	148.66	148.63	148.63	26900.0
2007-07-31 07:33:00	SPY	ETF	148.63	148.66	148.63	148.63	28500.0

> showing 50 of 55,068 rows — these rows as CSV

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