PREVIEW / etf_5min / 2006-07-31

all etf 5-min files

  file:    by_date/etf_5min/2006/2006-07-31.parquet
  size:    197 KB
  rows:    10,342

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
2006-07-31 06:40:00	SPY	ETF	127.7	127.7	127.7	127.7	100.0
2006-07-31 07:00:00	SPY	ETF	127.66	127.66	127.66	127.66	1500.0
2006-07-31 07:10:00	SPY	ETF	127.67	127.71	127.67	127.71	2200.0
2006-07-31 07:15:00	SPY	ETF	127.75	127.75	127.75	127.75	900.0
2006-07-31 07:20:00	SPY	ETF	127.75	127.79	127.75	127.77	1400.0
2006-07-31 07:25:00	SPY	ETF	127.77	127.79	127.75	127.75	19100.0
2006-07-31 07:30:00	SPY	ETF	127.74	127.75	127.74	127.75	1100.0
2006-07-31 07:45:00	SPY	ETF	127.78	127.79	127.78	127.79	10000.0
2006-07-31 07:50:00	SPY	ETF	127.79	127.79	127.79	127.79	200.0
2006-07-31 07:55:00	SPY	ETF	127.79	127.79	127.79	127.79	1000.0
2006-07-31 08:00:00	SPY	ETF	127.63	127.84	127.63	127.81	22400.0
2006-07-31 08:05:00	SPY	ETF	127.76	127.8	127.76	127.77	4300.0
2006-07-31 08:10:00	SPY	ETF	127.77	127.79	127.77	127.79	4000.0
2006-07-31 08:15:00	SPY	ETF	127.8	127.8	127.75	127.78	3900.0
2006-07-31 08:20:00	SPY	ETF	127.78	127.78	127.77	127.77	700.0
2006-07-31 08:25:00	SPY	ETF	127.76	127.76	127.69	127.71	78500.0
2006-07-31 08:30:00	SPY	ETF	127.71	127.72	127.68	127.68	49900.0
2006-07-31 08:35:00	SPY	ETF	127.68	127.73	127.68	127.73	42100.0
2006-07-31 08:40:00	SPY	ETF	127.73	127.79	127.71	127.76	60700.0
2006-07-31 08:45:00	SPY	ETF	127.76	127.8	127.76	127.78	3300.0
2006-07-31 08:50:00	SPY	ETF	127.78	127.79	127.66	127.69	86000.0
2006-07-31 08:55:00	SPY	ETF	127.69	127.69	127.61	127.61	121500.0
2006-07-31 09:00:00	SPY	ETF	127.64	127.66	127.64	127.65	22500.0
2006-07-31 09:05:00	SPY	ETF	127.63	127.64	127.6	127.64	96800.0
2006-07-31 09:10:00	SPY	ETF	127.64	127.71	127.64	127.7	7700.0
2006-07-31 09:15:00	SPY	ETF	127.7	127.7	127.64	127.65	19300.0
2006-07-31 09:20:00	SPY	ETF	127.63	127.71	127.62	127.62	27900.0
2006-07-31 09:25:00	SPY	ETF	127.66	127.7	127.65	127.7	58800.0
2006-07-31 09:30:00	SPY	ETF	127.66	127.7	126.55	127.52	656000.0
2006-07-31 09:35:00	SPY	ETF	127.52	127.72	127.5	127.69	2727300.0
2006-07-31 09:40:00	SPY	ETF	127.69	127.7	127.53	127.58	622500.0
2006-07-31 09:45:00	SPY	ETF	127.58	127.71	127.45	127.48	1615300.0
2006-07-31 09:50:00	SPY	ETF	127.48	127.6	127.47	127.57	1859800.0
2006-07-31 09:55:00	SPY	ETF	127.57	127.64	127.53	127.6	679400.0
2006-07-31 10:00:00	SPY	ETF	127.61	127.7	127.56	127.65	1782600.0
2006-07-31 10:05:00	SPY	ETF	127.59	127.78	127.59	127.67	1369700.0
2006-07-31 10:10:00	SPY	ETF	127.68	127.69	127.47	127.54	1663900.0
2006-07-31 10:15:00	SPY	ETF	127.54	127.61	127.52	127.53	327900.0
2006-07-31 10:20:00	SPY	ETF	127.54	127.75	127.5	127.74	1647500.0
2006-07-31 10:25:00	SPY	ETF	127.75	127.9	127.71	127.85	1857800.0
2006-07-31 10:30:00	SPY	ETF	127.85	127.87	127.67	127.7	667400.0
2006-07-31 10:35:00	SPY	ETF	127.69	127.74	127.63	127.72	401700.0
2006-07-31 10:40:00	SPY	ETF	127.73	127.82	127.66	127.7088	540300.0
2006-07-31 10:45:00	SPY	ETF	127.71	127.73	127.65	127.68	328600.0
2006-07-31 10:50:00	SPY	ETF	127.68	127.82	127.65	127.82	383500.0
2006-07-31 10:55:00	SPY	ETF	127.82	127.85	127.71	127.76	291600.0
2006-07-31 11:00:00	SPY	ETF	127.75	127.85	127.75	127.77	977900.0
2006-07-31 11:05:00	SPY	ETF	127.77	127.87	127.75	127.85	331400.0
2006-07-31 11:10:00	SPY	ETF	127.82	127.85	127.7	127.78	427300.0
2006-07-31 11:15:00	SPY	ETF	127.79	127.84	127.75	127.77	267400.0

> showing 50 of 10,342 rows — these rows as CSV

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