PREVIEW / etf_1min / 2008-07-01

all etf 1-min files

  file:    by_date/etf_1min/2008/2008-07-01.parquet
  size:    1.3 MB
  rows:    77,811

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
2008-07-01 04:49:00	SPY	ETF	127.8	127.8	127.8	127.8	100.0
2008-07-01 04:54:00	SPY	ETF	127.5	127.5	127.5	127.5	100.0
2008-07-01 05:04:00	SPY	ETF	127.34	127.34	127.34	127.34	100.0
2008-07-01 05:25:00	SPY	ETF	127.0	127.0	127.0	127.0	600.0
2008-07-01 05:34:00	SPY	ETF	126.86	126.86	126.85	126.85	1200.0
2008-07-01 05:49:00	SPY	ETF	126.72	126.72	126.72	126.72	1000.0
2008-07-01 05:50:00	SPY	ETF	126.68	126.68	126.68	126.68	1000.0
2008-07-01 06:16:00	SPY	ETF	126.67	126.67	126.65	126.65	500.0
2008-07-01 06:18:00	SPY	ETF	126.7	126.7	126.65	126.65	8300.0
2008-07-01 06:21:00	SPY	ETF	126.6	126.6	126.6	126.6	500.0
2008-07-01 06:22:00	SPY	ETF	126.61	126.61	126.61	126.61	100.0
2008-07-01 06:28:00	SPY	ETF	126.64	126.7	126.64	126.7	104000.0
2008-07-01 06:31:00	SPY	ETF	126.7	126.7	126.7	126.7	100.0
2008-07-01 06:34:00	SPY	ETF	126.7	126.7	126.7	126.7	1000.0
2008-07-01 06:37:00	SPY	ETF	126.7	126.7	126.7	126.7	1500.0
2008-07-01 06:38:00	SPY	ETF	126.7	126.7	126.7	126.7	47500.0
2008-07-01 06:39:00	SPY	ETF	126.79	126.79	126.79	126.79	100.0
2008-07-01 06:40:00	SPY	ETF	126.79	126.8	126.79	126.8	27500.0
2008-07-01 06:46:00	SPY	ETF	126.66	126.69	126.64	126.65	179700.0
2008-07-01 06:47:00	SPY	ETF	126.64	126.67	126.64	126.67	1100.0
2008-07-01 06:48:00	SPY	ETF	126.69	126.69	126.61	126.61	2200.0
2008-07-01 06:49:00	SPY	ETF	126.61	126.61	126.6	126.6	40000.0
2008-07-01 06:50:00	SPY	ETF	126.6	126.6	126.58	126.58	63100.0
2008-07-01 06:51:00	SPY	ETF	126.5	126.57	126.5	126.57	200.0
2008-07-01 06:52:00	SPY	ETF	126.57	126.57	126.57	126.57	25000.0
2008-07-01 06:53:00	SPY	ETF	126.55	126.55	126.45	126.45	1700.0
2008-07-01 06:54:00	SPY	ETF	126.45	126.45	126.45	126.45	24800.0
2008-07-01 06:56:00	SPY	ETF	126.6	126.6	126.6	126.6	300.0
2008-07-01 06:57:00	SPY	ETF	126.6	126.6	126.6	126.6	13400.0
2008-07-01 06:58:00	SPY	ETF	126.6	126.6	126.6	126.6	13100.0
2008-07-01 07:00:00	SPY	ETF	126.6	126.6	126.5	126.5	43500.0
2008-07-01 07:01:00	SPY	ETF	126.58	126.58	126.53	126.53	55528.0
2008-07-01 07:02:00	SPY	ETF	126.54	126.54	126.52	126.52	1600.0
2008-07-01 07:03:00	SPY	ETF	126.56	126.57	126.52	126.56	5865.0
2008-07-01 07:04:00	SPY	ETF	126.6	126.6	126.58	126.58	52000.0
2008-07-01 07:05:00	SPY	ETF	126.6	126.64	126.6	126.64	46441.0
2008-07-01 07:06:00	SPY	ETF	126.6	126.61	126.6	126.61	91000.0
2008-07-01 07:07:00	SPY	ETF	126.61	126.66	126.6	126.66	30500.0
2008-07-01 07:08:00	SPY	ETF	126.66	126.66	126.6	126.61	11500.0
2008-07-01 07:09:00	SPY	ETF	126.6	126.61	126.6	126.6	5000.0
2008-07-01 07:10:00	SPY	ETF	126.62	126.62	126.62	126.62	1300.0
2008-07-01 07:11:00	SPY	ETF	126.62	126.64	126.61	126.64	78100.0
2008-07-01 07:12:00	SPY	ETF	126.6	126.6	126.6	126.6	2500.0
2008-07-01 07:13:00	SPY	ETF	126.6	126.6	126.58	126.58	93101.0
2008-07-01 07:14:00	SPY	ETF	126.58	126.58	126.58	126.58	62700.0
2008-07-01 07:15:00	SPY	ETF	126.62	126.73	126.62	126.65	231100.0
2008-07-01 07:16:00	SPY	ETF	126.61	126.63	126.56	126.63	163204.0
2008-07-01 07:17:00	SPY	ETF	126.63	126.63	126.6	126.6	13800.0
2008-07-01 07:18:00	SPY	ETF	126.6	126.61	126.55	126.55	217954.0
2008-07-01 07:19:00	SPY	ETF	126.56	126.59	126.55	126.57	63005.0

> showing 50 of 77,811 rows — these rows as CSV

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