PREVIEW / etf_5min / 2010-04-01

all etf 5-min files

  file:    by_date/etf_5min/2010/2010-04-01.parquet
  size:    772 KB
  rows:    33,337

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
2010-04-01 04:15:00	SPY	ETF	117.58	117.58	117.56	117.56	2420.0
2010-04-01 04:25:00	SPY	ETF	117.61	117.61	117.61	117.61	900.0
2010-04-01 04:30:00	SPY	ETF	117.6	117.6	117.6	117.6	130.0
2010-04-01 04:55:00	SPY	ETF	117.63	117.63	117.63	117.63	100.0
2010-04-01 05:20:00	SPY	ETF	117.53	117.53	117.53	117.53	100.0
2010-04-01 05:35:00	SPY	ETF	117.52	117.52	117.52	117.52	309.0
2010-04-01 05:40:00	SPY	ETF	117.55	117.55	117.55	117.55	100.0
2010-04-01 05:45:00	SPY	ETF	117.51	117.51	117.51	117.51	2000.0
2010-04-01 06:00:00	SPY	ETF	117.52	117.52	117.52	117.52	500.0
2010-04-01 06:05:00	SPY	ETF	117.51	117.51	117.51	117.51	1000.0
2010-04-01 06:10:00	SPY	ETF	117.51	117.51	117.51	117.51	2500.0
2010-04-01 06:20:00	SPY	ETF	117.51	117.54	117.51	117.54	6100.0
2010-04-01 06:25:00	SPY	ETF	117.52	117.54	117.52	117.52	10400.0
2010-04-01 06:35:00	SPY	ETF	117.52	117.52	117.52	117.52	100.0
2010-04-01 06:50:00	SPY	ETF	117.46	117.46	117.46	117.46	300.0
2010-04-01 06:55:00	SPY	ETF	117.44	117.45	117.42	117.45	35000.0
2010-04-01 07:00:00	SPY	ETF	117.48	117.51	117.45	117.46	11200.0
2010-04-01 07:05:00	SPY	ETF	117.46	117.47	117.45	117.45	71600.0
2010-04-01 07:10:00	SPY	ETF	117.46	117.47	117.45	117.47	85600.0
2010-04-01 07:15:00	SPY	ETF	117.48	117.52	117.47	117.49	25200.0
2010-04-01 07:20:00	SPY	ETF	117.5	117.5	117.47	117.49	27900.0
2010-04-01 07:25:00	SPY	ETF	117.52	117.58	117.49	117.52	14700.0
2010-04-01 07:30:00	SPY	ETF	117.53	117.53	117.49	117.52	2720.0
2010-04-01 07:35:00	SPY	ETF	117.51	117.53	117.48	117.51	139424.0
2010-04-01 07:40:00	SPY	ETF	117.55	117.55	117.5	117.5	77900.0
2010-04-01 07:45:00	SPY	ETF	117.51	117.55	117.51	117.52	2475.0
2010-04-01 07:50:00	SPY	ETF	117.53	117.53	117.5	117.5	7300.0
2010-04-01 07:55:00	SPY	ETF	117.51	117.51	117.51	117.51	50200.0
2010-04-01 08:00:00	SPY	ETF	117.51	117.53	116.99	117.49	241713.0
2010-04-01 08:05:00	SPY	ETF	117.5	117.5	117.48	117.49	41500.0
2010-04-01 08:10:00	SPY	ETF	117.48	117.52	117.48	117.52	61273.0
2010-04-01 08:15:00	SPY	ETF	117.51	117.52	117.48	117.49	83126.0
2010-04-01 08:20:00	SPY	ETF	117.5	117.56	117.49	117.55	156670.0
2010-04-01 08:25:00	SPY	ETF	117.56	117.6	117.53	117.54	197899.0
2010-04-01 08:30:00	SPY	ETF	117.6	117.73	117.49	117.67	407529.0
2010-04-01 08:35:00	SPY	ETF	117.67	117.78	117.63	117.76	197703.0
2010-04-01 08:40:00	SPY	ETF	117.75	117.79	117.71	117.77	373332.0
2010-04-01 08:45:00	SPY	ETF	117.78	117.78	117.0	117.74	277073.0
2010-04-01 08:50:00	SPY	ETF	117.74	117.75	117.69	117.71	162645.0
2010-04-01 08:55:00	SPY	ETF	117.7	117.7	117.68	117.69	64780.0
2010-04-01 09:00:00	SPY	ETF	117.69	117.73	117.68	117.71	107340.0
2010-04-01 09:05:00	SPY	ETF	117.7	117.74	117.69	117.73	130743.0
2010-04-01 09:10:00	SPY	ETF	117.73	117.74	117.7	117.71	51839.0
2010-04-01 09:15:00	SPY	ETF	117.71	117.72	117.0	117.0	109645.0
2010-04-01 09:20:00	SPY	ETF	117.69	117.73	117.0	117.7	78089.0
2010-04-01 09:25:00	SPY	ETF	117.7	117.81	117.68	117.79	795618.0
2010-04-01 09:30:00	SPY	ETF	117.8	118.0	117.77	117.96	6128895.0
2010-04-01 09:35:00	SPY	ETF	117.96	118.09	117.96	117.96	5155019.0
2010-04-01 09:40:00	SPY	ETF	117.96	118.05	117.94	118.0	2663507.0
2010-04-01 09:45:00	SPY	ETF	118.0	118.19	118.0	118.05	3922531.0

> showing 50 of 33,337 rows — these rows as CSV

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