PREVIEW / etf_1min / 2009-04-20

all etf 1-min files

  file:    by_date/etf_1min/2009/2009-04-20.parquet
  size:    1.7 MB
  rows:    94,949

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
2009-04-20 04:12:00	SPY	ETF	86.42	86.42	86.42	86.42	4000.0
2009-04-20 04:15:00	SPY	ETF	86.46	86.46	86.43	86.43	1000.0
2009-04-20 04:17:00	SPY	ETF	86.43	86.44	86.42	86.42	1062.0
2009-04-20 04:20:00	SPY	ETF	86.41	86.41	86.4	86.4	1500.0
2009-04-20 04:23:00	SPY	ETF	86.38	86.38	86.38	86.38	300.0
2009-04-20 04:30:00	SPY	ETF	86.33	86.33	86.3	86.3	2600.0
2009-04-20 04:33:00	SPY	ETF	86.36	86.36	86.36	86.36	200.0
2009-04-20 04:35:00	SPY	ETF	86.4	86.4	86.4	86.4	1500.0
2009-04-20 04:38:00	SPY	ETF	86.34	86.34	86.34	86.34	290.0
2009-04-20 04:39:00	SPY	ETF	86.34	86.34	86.34	86.34	500.0
2009-04-20 04:40:00	SPY	ETF	86.34	86.34	86.31	86.31	700.0
2009-04-20 04:41:00	SPY	ETF	86.26	86.27	86.26	86.26	800.0
2009-04-20 04:42:00	SPY	ETF	86.25	86.25	86.25	86.25	200.0
2009-04-20 04:43:00	SPY	ETF	86.25	86.25	86.25	86.25	754.0
2009-04-20 04:45:00	SPY	ETF	86.22	86.22	86.22	86.22	200.0
2009-04-20 04:47:00	SPY	ETF	86.25	86.25	86.25	86.25	146.0
2009-04-20 04:58:00	SPY	ETF	86.29	86.29	86.29	86.29	200.0
2009-04-20 05:00:00	SPY	ETF	86.28	86.28	86.26	86.26	504.0
2009-04-20 05:02:00	SPY	ETF	86.22	86.22	86.2	86.22	400.0
2009-04-20 05:07:00	SPY	ETF	86.2	86.2	86.2	86.2	4900.0
2009-04-20 05:10:00	SPY	ETF	86.11	86.11	86.11	86.11	300.0
2009-04-20 05:16:00	SPY	ETF	86.09	86.09	86.01	86.01	517.0
2009-04-20 05:17:00	SPY	ETF	86.01	86.01	86.01	86.01	200.0
2009-04-20 05:18:00	SPY	ETF	86.04	86.04	86.04	86.04	100.0
2009-04-20 05:20:00	SPY	ETF	86.0	86.0	86.0	86.0	2700.0
2009-04-20 05:21:00	SPY	ETF	86.0	86.0	86.0	86.0	3900.0
2009-04-20 05:22:00	SPY	ETF	85.97	85.97	85.97	85.97	100.0
2009-04-20 05:28:00	SPY	ETF	86.02	86.02	86.0	86.0	200.0
2009-04-20 05:29:00	SPY	ETF	86.01	86.01	86.01	86.01	300.0
2009-04-20 05:32:00	SPY	ETF	85.97	85.97	85.97	85.97	200.0
2009-04-20 05:34:00	SPY	ETF	85.99	85.99	85.99	85.99	200.0
2009-04-20 05:35:00	SPY	ETF	86.02	86.03	86.02	86.03	15000.0
2009-04-20 05:40:00	SPY	ETF	86.03	86.03	85.99	85.99	10300.0
2009-04-20 05:41:00	SPY	ETF	86.01	86.03	86.01	86.03	5000.0
2009-04-20 05:48:00	SPY	ETF	85.91	85.91	85.91	85.91	10000.0
2009-04-20 05:49:00	SPY	ETF	85.88	85.88	85.88	85.88	400.0
2009-04-20 05:51:00	SPY	ETF	85.92	85.92	85.92	85.92	300.0
2009-04-20 05:52:00	SPY	ETF	85.92	85.92	85.92	85.92	100.0
2009-04-20 06:00:00	SPY	ETF	85.86	85.86	85.86	85.86	100.0
2009-04-20 06:03:00	SPY	ETF	85.9	85.9	85.9	85.9	2600.0
2009-04-20 06:04:00	SPY	ETF	85.9	85.9	85.9	85.9	2500.0
2009-04-20 06:06:00	SPY	ETF	85.87	85.87	85.87	85.87	5000.0
2009-04-20 06:08:00	SPY	ETF	85.97	85.97	85.97	85.97	900.0
2009-04-20 06:09:00	SPY	ETF	86.03	86.05	86.03	86.05	8337.0
2009-04-20 06:10:00	SPY	ETF	86.03	86.03	86.03	86.03	1000.0
2009-04-20 06:13:00	SPY	ETF	86.05	86.05	86.05	86.05	500.0
2009-04-20 06:14:00	SPY	ETF	86.06	86.06	86.06	86.06	1000.0
2009-04-20 06:15:00	SPY	ETF	86.07	86.07	86.07	86.07	2000.0
2009-04-20 06:16:00	SPY	ETF	86.08	86.08	86.07	86.07	1300.0
2009-04-20 06:17:00	SPY	ETF	86.07	86.07	86.07	86.07	1000.0

> showing 50 of 94,949 rows — these rows as CSV

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