PREVIEW / etf_1min / 2009-08-20

all etf 1-min files

  file:    by_date/etf_1min/2009/2009-08-20.parquet
  size:    1.5 MB
  rows:    84,077

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-08-20 04:05:00	SPY	ETF	100.67	100.67	100.67	100.67	200.0
2009-08-20 04:15:00	SPY	ETF	100.67	100.7	100.67	100.7	1400.0
2009-08-20 04:30:00	SPY	ETF	100.76	100.76	100.72	100.72	275.0
2009-08-20 04:58:00	SPY	ETF	100.77	100.77	100.76	100.76	700.0
2009-08-20 05:12:00	SPY	ETF	100.71	100.71	100.68	100.68	1100.0
2009-08-20 05:13:00	SPY	ETF	100.68	100.68	100.68	100.68	500.0
2009-08-20 05:18:00	SPY	ETF	100.67	100.67	100.67	100.67	500.0
2009-08-20 05:35:00	SPY	ETF	100.67	100.67	100.67	100.67	600.0
2009-08-20 05:49:00	SPY	ETF	100.65	100.65	100.65	100.65	100.0
2009-08-20 06:03:00	SPY	ETF	100.63	100.63	100.63	100.63	500.0
2009-08-20 06:07:00	SPY	ETF	100.55	100.55	100.51	100.51	500.0
2009-08-20 06:08:00	SPY	ETF	100.47	100.47	100.46	100.46	600.0
2009-08-20 06:12:00	SPY	ETF	100.45	100.45	100.45	100.45	500.0
2009-08-20 06:14:00	SPY	ETF	100.5	100.5	100.5	100.5	500.0
2009-08-20 06:18:00	SPY	ETF	100.49	100.49	100.49	100.49	200.0
2009-08-20 06:22:00	SPY	ETF	100.55	100.55	100.55	100.55	500.0
2009-08-20 06:27:00	SPY	ETF	100.55	100.55	100.55	100.55	100.0
2009-08-20 06:28:00	SPY	ETF	100.55	100.55	100.55	100.55	9900.0
2009-08-20 06:29:00	SPY	ETF	100.58	100.58	100.58	100.58	20000.0
2009-08-20 06:42:00	SPY	ETF	100.49	100.49	100.49	100.49	25500.0
2009-08-20 06:44:00	SPY	ETF	100.49	100.49	100.49	100.49	300.0
2009-08-20 06:47:00	SPY	ETF	100.47	100.47	100.47	100.47	1100.0
2009-08-20 06:48:00	SPY	ETF	100.5	100.5	100.5	100.5	1400.0
2009-08-20 06:50:00	SPY	ETF	100.52	100.52	100.52	100.52	200.0
2009-08-20 06:55:00	SPY	ETF	100.53	100.53	100.53	100.53	1200.0
2009-08-20 06:56:00	SPY	ETF	100.55	100.55	100.55	100.55	14000.0
2009-08-20 06:59:00	SPY	ETF	100.54	100.54	100.54	100.54	400.0
2009-08-20 07:00:00	SPY	ETF	100.56	100.57	100.54	100.54	2850.0
2009-08-20 07:01:00	SPY	ETF	100.53	100.55	100.53	100.55	15900.0
2009-08-20 07:02:00	SPY	ETF	100.52	100.52	100.52	100.52	3000.0
2009-08-20 07:03:00	SPY	ETF	100.52	100.52	100.52	100.52	7000.0
2009-08-20 07:04:00	SPY	ETF	100.51	100.51	100.46	100.46	1400.0
2009-08-20 07:05:00	SPY	ETF	100.42	100.42	100.41	100.41	25000.0
2009-08-20 07:06:00	SPY	ETF	100.42	100.42	100.4	100.4	650.0
2009-08-20 07:08:00	SPY	ETF	100.38	100.38	100.38	100.38	2200.0
2009-08-20 07:09:00	SPY	ETF	100.4	100.4	100.38	100.4	5500.0
2009-08-20 07:10:00	SPY	ETF	100.38	100.38	100.32	100.32	69700.0
2009-08-20 07:11:00	SPY	ETF	100.3	100.32	100.28	100.32	6400.0
2009-08-20 07:12:00	SPY	ETF	100.32	100.34	100.32	100.34	700.0
2009-08-20 07:13:00	SPY	ETF	100.33	100.34	100.28	100.28	1575.0
2009-08-20 07:14:00	SPY	ETF	100.28	100.28	100.28	100.28	2000.0
2009-08-20 07:15:00	SPY	ETF	100.34	100.34	100.34	100.34	5000.0
2009-08-20 07:16:00	SPY	ETF	100.35	100.36	100.33	100.35	3500.0
2009-08-20 07:17:00	SPY	ETF	100.33	100.35	100.33	100.35	35600.0
2009-08-20 07:18:00	SPY	ETF	100.37	100.38	100.37	100.37	35000.0
2009-08-20 07:19:00	SPY	ETF	100.36	100.38	100.35	100.35	120800.0
2009-08-20 07:20:00	SPY	ETF	100.36	100.36	100.36	100.36	1600.0
2009-08-20 07:22:00	SPY	ETF	100.39	100.39	100.38	100.39	20000.0
2009-08-20 07:24:00	SPY	ETF	100.37	100.37	100.37	100.37	1100.0
2009-08-20 07:25:00	SPY	ETF	100.37	100.37	100.37	100.37	1000.0

> showing 50 of 84,077 rows — these rows as CSV

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