PREVIEW / etf_5min / 2007-04-04

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-04-04.parquet
  size:    280 KB
  rows:    13,762

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-04-04 06:50:00	SPY	ETF	143.75	143.75	143.75	143.75	1000.0
2007-04-04 07:00:00	SPY	ETF	143.74	143.74	143.74	143.74	1000.0
2007-04-04 07:05:00	SPY	ETF	143.72	143.72	143.69	143.69	10700.0
2007-04-04 07:10:00	SPY	ETF	143.69	143.69	143.69	143.69	19000.0
2007-04-04 07:15:00	SPY	ETF	143.69	143.69	143.68	143.69	27200.0
2007-04-04 07:20:00	SPY	ETF	143.72	143.72	143.72	143.72	1500.0
2007-04-04 07:25:00	SPY	ETF	143.71	143.71	143.71	143.71	20000.0
2007-04-04 07:30:00	SPY	ETF	143.72	143.72	143.72	143.72	1000.0
2007-04-04 07:35:00	SPY	ETF	143.72	143.78	143.72	143.78	2500.0
2007-04-04 07:40:00	SPY	ETF	143.76	143.79	143.75	143.75	9000.0
2007-04-04 07:45:00	SPY	ETF	143.75	143.79	143.74	143.79	14000.0
2007-04-04 07:50:00	SPY	ETF	143.78	143.78	143.78	143.78	12400.0
2007-04-04 07:55:00	SPY	ETF	143.75	143.75	143.74	143.74	2700.0
2007-04-04 08:00:00	SPY	ETF	143.71	143.71	143.71	143.71	500.0
2007-04-04 08:05:00	SPY	ETF	143.73	143.73	143.64	143.64	39600.0
2007-04-04 08:10:00	SPY	ETF	143.67	143.68	143.65	143.65	80700.0
2007-04-04 08:15:00	SPY	ETF	143.65	143.85	143.53	143.65	304500.0
2007-04-04 08:20:00	SPY	ETF	143.65	143.67	143.58	143.61	511400.0
2007-04-04 08:25:00	SPY	ETF	143.6	143.64	143.6	143.64	66000.0
2007-04-04 08:30:00	SPY	ETF	143.63	143.63	143.51	143.58	82700.0
2007-04-04 08:35:00	SPY	ETF	143.52	143.58	143.51	143.57	17100.0
2007-04-04 08:40:00	SPY	ETF	143.57	143.58	143.53	143.56	62700.0
2007-04-04 08:45:00	SPY	ETF	143.54	143.54	143.54	143.54	39100.0
2007-04-04 08:50:00	SPY	ETF	143.54	143.55	143.48	143.48	203400.0
2007-04-04 08:55:00	SPY	ETF	143.49	143.54	143.48	143.48	59700.0
2007-04-04 09:00:00	SPY	ETF	143.49	143.5	143.44	143.46	108100.0
2007-04-04 09:05:00	SPY	ETF	143.46	143.5	143.39	143.5	98900.0
2007-04-04 09:10:00	SPY	ETF	143.51	143.91	143.51	143.77	2083900.0
2007-04-04 09:15:00	SPY	ETF	143.77	143.79	143.61	143.71	556500.0
2007-04-04 09:20:00	SPY	ETF	143.72	143.73	143.63	143.69	599000.0
2007-04-04 09:25:00	SPY	ETF	143.68	143.7	143.63	143.69	173800.0
2007-04-04 09:30:00	SPY	ETF	143.69	143.7	143.44	143.56	2563899.0
2007-04-04 09:35:00	SPY	ETF	143.56	143.81	143.56	143.72	3146921.0
2007-04-04 09:40:00	SPY	ETF	143.72	143.79	143.65	143.702	1832312.0
2007-04-04 09:45:00	SPY	ETF	143.7	143.75	143.63	143.69	1163300.0
2007-04-04 09:50:00	SPY	ETF	143.69	143.76	143.68	143.71	605100.0
2007-04-04 09:55:00	SPY	ETF	143.7	143.75	143.62	143.63	1202360.0
2007-04-04 10:00:00	SPY	ETF	143.64	143.64	143.16	143.51	4065700.0
2007-04-04 10:05:00	SPY	ETF	143.51	143.6	143.42	143.46	1307900.0
2007-04-04 10:10:00	SPY	ETF	143.46	143.58	143.44	143.54	690300.0
2007-04-04 10:15:00	SPY	ETF	143.55	143.63	143.5	143.5	595600.0
2007-04-04 10:20:00	SPY	ETF	143.5	143.72	143.48	143.68	921667.0
2007-04-04 10:25:00	SPY	ETF	143.69	143.74	143.65	143.7	1348818.0
2007-04-04 10:30:00	SPY	ETF	143.69	143.8	143.57	143.64	881700.0
2007-04-04 10:35:00	SPY	ETF	143.635	143.71	143.61	143.63	486900.0
2007-04-04 10:40:00	SPY	ETF	143.64	143.66	143.59	143.64	400000.0
2007-04-04 10:45:00	SPY	ETF	143.64	143.64	143.49	143.54	1625050.0
2007-04-04 10:50:00	SPY	ETF	143.53	143.57	143.5	143.55	508000.0
2007-04-04 10:55:00	SPY	ETF	143.55	143.64	143.55	143.62	246400.0
2007-04-04 11:00:00	SPY	ETF	143.62	143.68	143.59	143.62	429000.0

> showing 50 of 13,762 rows — these rows as CSV

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