PREVIEW / etf_5min / 2007-11-29

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-11-29.parquet
  size:    404 KB
  rows:    20,006

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-11-29 04:45:00	SPY	ETF	146.62	146.62	146.62	146.62	500.0
2007-11-29 05:00:00	SPY	ETF	146.54	146.54	146.54	146.54	100.0
2007-11-29 05:15:00	SPY	ETF	146.73	146.73	146.73	146.73	1500.0
2007-11-29 05:40:00	SPY	ETF	146.56	146.61	146.56	146.61	25000.0
2007-11-29 05:45:00	SPY	ETF	146.67	146.9	146.67	146.9	2600.0
2007-11-29 05:50:00	SPY	ETF	146.82	146.82	146.82	146.82	200.0
2007-11-29 05:55:00	SPY	ETF	146.81	146.81	146.81	146.81	500.0
2007-11-29 06:05:00	SPY	ETF	146.5	146.5	146.5	146.5	100.0
2007-11-29 06:10:00	SPY	ETF	146.31	146.42	146.31	146.42	6000.0
2007-11-29 06:15:00	SPY	ETF	146.53	146.67	146.53	146.67	5300.0
2007-11-29 06:25:00	SPY	ETF	146.57	146.57	146.57	146.57	100.0
2007-11-29 06:30:00	SPY	ETF	146.47	146.47	146.44	146.44	10200.0
2007-11-29 06:35:00	SPY	ETF	146.6	146.61	146.57	146.61	40000.0
2007-11-29 06:40:00	SPY	ETF	146.56	146.6	146.55	146.6	7100.0
2007-11-29 06:50:00	SPY	ETF	146.71	146.71	146.6	146.6	9000.0
2007-11-29 06:55:00	SPY	ETF	146.56	146.61	146.53	146.53	3900.0
2007-11-29 07:00:00	SPY	ETF	146.45	146.55	146.35	146.4	121200.0
2007-11-29 07:05:00	SPY	ETF	146.36	146.36	146.27	146.31	89200.0
2007-11-29 07:10:00	SPY	ETF	146.27	146.44	146.27	146.42	37400.0
2007-11-29 07:15:00	SPY	ETF	146.42	146.43	146.32	146.38	41200.0
2007-11-29 07:20:00	SPY	ETF	146.41	146.42	146.36	146.4	37400.0
2007-11-29 07:25:00	SPY	ETF	146.4	146.43	146.37	146.39	32100.0
2007-11-29 07:30:00	SPY	ETF	146.4	146.4	146.27	146.34	90300.0
2007-11-29 07:35:00	SPY	ETF	146.33	146.38	146.33	146.37	16800.0
2007-11-29 07:40:00	SPY	ETF	146.37	146.56	146.35	146.54	37500.0
2007-11-29 07:45:00	SPY	ETF	146.5	146.87	146.49	146.8	68800.0
2007-11-29 07:50:00	SPY	ETF	146.78	146.96	146.78	146.94	227600.0
2007-11-29 07:55:00	SPY	ETF	146.91	146.94	146.85	146.89	46100.0
2007-11-29 08:00:00	SPY	ETF	146.9	146.91	146.31	146.9	1023600.0
2007-11-29 08:05:00	SPY	ETF	146.9	146.93	146.87	146.89	254200.0
2007-11-29 08:10:00	SPY	ETF	146.89	147.0	146.88	146.96	144600.0
2007-11-29 08:15:00	SPY	ETF	146.96	146.97	146.83	146.88	37900.0
2007-11-29 08:20:00	SPY	ETF	146.89	146.89	146.61	146.61	640500.0
2007-11-29 08:25:00	SPY	ETF	146.63	146.63	146.51	146.52	948000.0
2007-11-29 08:30:00	SPY	ETF	146.54	146.79	146.46	146.63	383700.0
2007-11-29 08:35:00	SPY	ETF	146.64	146.71	146.52	146.53	72000.0
2007-11-29 08:40:00	SPY	ETF	146.53	146.62	146.49	146.6	85300.0
2007-11-29 08:45:00	SPY	ETF	146.57	146.69	146.47	146.69	93900.0
2007-11-29 08:50:00	SPY	ETF	146.7	146.8	146.68	146.8	49800.0
2007-11-29 08:55:00	SPY	ETF	146.8	146.88	146.79	146.82	123500.0
2007-11-29 09:00:00	SPY	ETF	146.83	146.83	146.66	146.68	120500.0
2007-11-29 09:05:00	SPY	ETF	146.69	146.89	146.27	146.89	2277400.0
2007-11-29 09:10:00	SPY	ETF	146.65	146.91	146.65	146.7	96600.0
2007-11-29 09:15:00	SPY	ETF	146.7	146.71	146.54	146.66	110300.0
2007-11-29 09:20:00	SPY	ETF	146.66	146.75	146.64	146.69	144100.0
2007-11-29 09:25:00	SPY	ETF	146.71	146.77	146.61	146.61	113100.0
2007-11-29 09:30:00	SPY	ETF	146.62	146.72	146.45	146.62	6178431.0
2007-11-29 09:35:00	SPY	ETF	146.62	146.96	146.5801	146.95	4256813.0
2007-11-29 09:40:00	SPY	ETF	146.95	147.14	146.87	147.14	5318008.0
2007-11-29 09:45:00	SPY	ETF	147.14	147.15	146.51	146.56	3799000.0

> showing 50 of 20,006 rows — these rows as CSV

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