PREVIEW / etf_5min / 2009-04-29

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-04-29.parquet
  size:    684 KB
  rows:    29,757

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-04-29 04:15:00	SPY	ETF	86.29	86.3	86.29	86.29	1026.0
2009-04-29 04:20:00	SPY	ETF	86.33	86.33	86.32	86.32	400.0
2009-04-29 04:30:00	SPY	ETF	86.13	86.13	86.12	86.12	1100.0
2009-04-29 04:40:00	SPY	ETF	86.14	86.14	86.14	86.14	500.0
2009-04-29 04:50:00	SPY	ETF	86.15	86.15	86.12	86.12	1700.0
2009-04-29 05:00:00	SPY	ETF	86.17	86.24	86.17	86.24	1000.0
2009-04-29 05:10:00	SPY	ETF	86.28	86.28	86.28	86.28	5000.0
2009-04-29 05:15:00	SPY	ETF	86.3	86.33	86.3	86.33	5100.0
2009-04-29 05:20:00	SPY	ETF	86.31	86.36	86.31	86.36	300.0
2009-04-29 05:25:00	SPY	ETF	86.36	86.53	86.32	86.53	13500.0
2009-04-29 05:30:00	SPY	ETF	86.5	86.5	86.5	86.5	1000.0
2009-04-29 05:35:00	SPY	ETF	86.52	86.53	86.5	86.5	1600.0
2009-04-29 05:40:00	SPY	ETF	86.57	86.57	86.57	86.57	700.0
2009-04-29 05:45:00	SPY	ETF	86.64	86.7	86.64	86.7	5500.0
2009-04-29 05:50:00	SPY	ETF	86.69	86.71	86.69	86.71	5200.0
2009-04-29 06:00:00	SPY	ETF	86.64	86.64	86.64	86.64	5000.0
2009-04-29 06:05:00	SPY	ETF	86.63	86.63	86.62	86.62	20100.0
2009-04-29 06:10:00	SPY	ETF	86.57	86.57	86.57	86.57	400.0
2009-04-29 06:15:00	SPY	ETF	86.55	86.55	86.55	86.55	100.0
2009-04-29 06:25:00	SPY	ETF	86.66	86.66	86.66	86.66	139.0
2009-04-29 06:30:00	SPY	ETF	86.61	86.63	86.61	86.63	800.0
2009-04-29 06:35:00	SPY	ETF	86.55	86.55	86.49	86.49	11389.0
2009-04-29 06:40:00	SPY	ETF	86.48	86.49	86.43	86.43	5900.0
2009-04-29 06:55:00	SPY	ETF	86.45	86.48	86.45	86.47	5000.0
2009-04-29 07:00:00	SPY	ETF	86.45	86.5	86.33	86.33	90009.0
2009-04-29 07:05:00	SPY	ETF	86.33	86.38	86.28	86.38	57380.0
2009-04-29 07:10:00	SPY	ETF	86.35	86.38	86.33	86.35	25230.0
2009-04-29 07:15:00	SPY	ETF	86.33	86.39	86.27	86.39	98467.0
2009-04-29 07:20:00	SPY	ETF	86.38	86.41	86.37	86.37	67738.0
2009-04-29 07:25:00	SPY	ETF	86.37	86.38	86.35	86.38	20719.0
2009-04-29 07:30:00	SPY	ETF	86.36	86.38	86.32	86.32	13876.0
2009-04-29 07:35:00	SPY	ETF	86.32	86.35	86.3	86.33	16869.0
2009-04-29 07:40:00	SPY	ETF	86.32	86.39	86.32	86.37	46767.0
2009-04-29 07:45:00	SPY	ETF	86.37	86.44	86.36	86.43	83200.0
2009-04-29 07:50:00	SPY	ETF	86.43	86.5	86.43	86.48	117486.0
2009-04-29 07:55:00	SPY	ETF	86.47	86.48	86.46	86.48	8299.0
2009-04-29 08:00:00	SPY	ETF	86.47	86.47	86.32	86.45	637603.0
2009-04-29 08:05:00	SPY	ETF	86.46	86.48	86.43	86.48	70847.0
2009-04-29 08:10:00	SPY	ETF	86.48	86.62	86.48	86.62	284859.0
2009-04-29 08:15:00	SPY	ETF	86.62	86.68	86.61	86.64	204942.0
2009-04-29 08:20:00	SPY	ETF	86.63	86.75	86.63	86.67	463051.0
2009-04-29 08:25:00	SPY	ETF	86.67	86.7	86.3	86.3	416728.0
2009-04-29 08:30:00	SPY	ETF	86.63	86.71	86.14	86.59	2539762.0
2009-04-29 08:35:00	SPY	ETF	86.58	86.58	86.37	86.41	604481.0
2009-04-29 08:40:00	SPY	ETF	86.41	86.57	86.39	86.57	482039.0
2009-04-29 08:45:00	SPY	ETF	86.56	86.57	86.51	86.55	163321.0
2009-04-29 08:50:00	SPY	ETF	86.55	86.59	86.35	86.54	141316.0
2009-04-29 08:55:00	SPY	ETF	86.54	86.55	86.44	86.44	285665.0
2009-04-29 09:00:00	SPY	ETF	86.44	86.53	86.44	86.45	104939.0
2009-04-29 09:05:00	SPY	ETF	86.45	86.46	86.24	86.25	357969.0

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

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