PREVIEW / etf_5min / 2009-10-09

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-10-09.parquet
  size:    671 KB
  rows:    29,267

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-10-09 04:20:00	SPY	ETF	106.9	106.9	106.9	106.9	100.0
2009-10-09 04:25:00	SPY	ETF	106.79	106.79	106.79	106.79	100.0
2009-10-09 04:45:00	SPY	ETF	106.66	106.66	106.66	106.66	2500.0
2009-10-09 04:55:00	SPY	ETF	106.71	106.71	106.66	106.66	248.0
2009-10-09 05:20:00	SPY	ETF	106.66	106.66	106.66	106.66	5000.0
2009-10-09 05:55:00	SPY	ETF	106.51	106.51	106.45	106.48	2100.0
2009-10-09 06:00:00	SPY	ETF	106.48	106.48	106.48	106.48	1352.0
2009-10-09 06:15:00	SPY	ETF	106.6	106.62	106.6	106.62	648.0
2009-10-09 06:20:00	SPY	ETF	106.7	106.7	106.65	106.65	3700.0
2009-10-09 06:30:00	SPY	ETF	106.58	106.58	106.58	106.58	200.0
2009-10-09 06:40:00	SPY	ETF	106.62	106.62	106.59	106.59	400.0
2009-10-09 06:45:00	SPY	ETF	106.67	106.67	106.67	106.67	200.0
2009-10-09 06:50:00	SPY	ETF	106.69	106.69	106.69	106.69	100.0
2009-10-09 06:55:00	SPY	ETF	106.66	106.66	106.65	106.65	401.0
2009-10-09 07:00:00	SPY	ETF	106.72	106.78	106.72	106.78	2834.0
2009-10-09 07:05:00	SPY	ETF	106.79	106.86	106.77	106.85	24700.0
2009-10-09 07:10:00	SPY	ETF	106.82	106.82	106.76	106.76	17800.0
2009-10-09 07:15:00	SPY	ETF	106.78	106.82	106.78	106.8	9669.0
2009-10-09 07:20:00	SPY	ETF	106.79	106.8	106.76	106.76	1869.0
2009-10-09 07:25:00	SPY	ETF	106.74	106.74	106.7	106.73	2400.0
2009-10-09 07:30:00	SPY	ETF	106.73	106.73	106.73	106.73	369.0
2009-10-09 07:35:00	SPY	ETF	106.71	106.71	106.69	106.69	5700.0
2009-10-09 07:40:00	SPY	ETF	106.68	106.69	106.68	106.69	15200.0
2009-10-09 07:45:00	SPY	ETF	106.66	106.67	106.66	106.66	20700.0
2009-10-09 07:50:00	SPY	ETF	106.68	106.69	106.67	106.68	4502.0
2009-10-09 07:55:00	SPY	ETF	106.69	106.69	106.66	106.66	29500.0
2009-10-09 08:00:00	SPY	ETF	106.65	106.69	106.59	106.62	209752.0
2009-10-09 08:05:00	SPY	ETF	106.62	106.62	106.55	106.56	140135.0
2009-10-09 08:10:00	SPY	ETF	106.56	106.56	106.44	106.48	148305.0
2009-10-09 08:15:00	SPY	ETF	106.47	106.59	106.43	106.47	336783.0
2009-10-09 08:20:00	SPY	ETF	106.46	106.47	106.38	106.39	222769.0
2009-10-09 08:25:00	SPY	ETF	106.4	106.42	106.33	106.4	261837.0
2009-10-09 08:30:00	SPY	ETF	106.41	106.48	106.37	106.44	313406.0
2009-10-09 08:35:00	SPY	ETF	106.44	106.51	106.44	106.49	100098.0
2009-10-09 08:40:00	SPY	ETF	106.49	106.49	106.46	106.48	186236.0
2009-10-09 08:45:00	SPY	ETF	106.49	106.6	106.48	106.6	370332.0
2009-10-09 08:50:00	SPY	ETF	106.59	106.62	106.57	106.62	202736.0
2009-10-09 08:55:00	SPY	ETF	106.62	106.72	106.61	106.64	261182.0
2009-10-09 09:00:00	SPY	ETF	106.63	106.68	106.5	106.51	710596.0
2009-10-09 09:05:00	SPY	ETF	106.51	106.54	106.48	106.5	259827.0
2009-10-09 09:10:00	SPY	ETF	106.51	106.6	106.5	106.59	251204.0
2009-10-09 09:15:00	SPY	ETF	106.57	106.58	106.49	106.49	138557.0
2009-10-09 09:20:00	SPY	ETF	106.49	106.5	106.47	106.48	50857.0
2009-10-09 09:25:00	SPY	ETF	106.48	106.7	106.48	106.64	334103.0
2009-10-09 09:30:00	SPY	ETF	106.64	106.65	106.36	106.512	3897552.0
2009-10-09 09:35:00	SPY	ETF	106.52	106.63	106.44	106.6	3475550.0
2009-10-09 09:40:00	SPY	ETF	106.6	106.76	106.54	106.75	2822935.0
2009-10-09 09:45:00	SPY	ETF	106.75	106.86	106.69	106.77	2985678.0
2009-10-09 09:50:00	SPY	ETF	106.77	106.91	106.76	106.81	2751543.0
2009-10-09 09:55:00	SPY	ETF	106.79	106.9	106.79	106.8901	1290538.0

> showing 50 of 29,267 rows — these rows as CSV

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