PREVIEW / etf_5min / 2009-04-14

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-04-14.parquet
  size:    687 KB
  rows:    29,539

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-14 04:15:00	SPY	ETF	85.3	85.31	85.26	85.26	2550.0
2009-04-14 04:20:00	SPY	ETF	85.36	85.36	85.36	85.36	1800.0
2009-04-14 04:25:00	SPY	ETF	85.36	85.36	85.36	85.36	200.0
2009-04-14 04:35:00	SPY	ETF	85.33	85.33	85.33	85.33	500.0
2009-04-14 04:45:00	SPY	ETF	85.45	85.45	85.45	85.45	200.0
2009-04-14 05:00:00	SPY	ETF	85.53	85.53	85.53	85.53	200.0
2009-04-14 05:25:00	SPY	ETF	85.61	85.61	85.57	85.57	400.0
2009-04-14 05:30:00	SPY	ETF	85.68	85.76	85.68	85.76	500.0
2009-04-14 05:35:00	SPY	ETF	85.83	85.83	85.75	85.75	700.0
2009-04-14 05:40:00	SPY	ETF	85.83	85.83	85.83	85.83	16200.0
2009-04-14 05:45:00	SPY	ETF	85.79	85.79	85.78	85.79	20000.0
2009-04-14 05:50:00	SPY	ETF	85.85	85.85	85.74	85.74	5115.0
2009-04-14 05:55:00	SPY	ETF	85.74	85.81	85.74	85.81	5200.0
2009-04-14 06:00:00	SPY	ETF	85.8	85.8	85.8	85.8	300.0
2009-04-14 06:10:00	SPY	ETF	85.8	85.8	85.8	85.8	300.0
2009-04-14 06:15:00	SPY	ETF	85.79	85.85	85.79	85.8	1800.0
2009-04-14 06:20:00	SPY	ETF	85.8	85.8	85.61	85.61	20300.0
2009-04-14 06:25:00	SPY	ETF	85.63	85.63	85.55	85.55	20200.0
2009-04-14 06:30:00	SPY	ETF	85.5	85.5	85.5	85.5	199.0
2009-04-14 06:35:00	SPY	ETF	85.47	85.5	85.47	85.5	1300.0
2009-04-14 06:40:00	SPY	ETF	85.49	85.55	85.49	85.55	3265.0
2009-04-14 06:45:00	SPY	ETF	85.6	85.65	85.6	85.65	2100.0
2009-04-14 06:50:00	SPY	ETF	85.5	85.5	85.5	85.5	5000.0
2009-04-14 06:55:00	SPY	ETF	85.55	85.59	85.55	85.59	11700.0
2009-04-14 07:00:00	SPY	ETF	85.6	85.64	85.58	85.59	79449.0
2009-04-14 07:05:00	SPY	ETF	85.61	85.61	85.53	85.56	136501.0
2009-04-14 07:10:00	SPY	ETF	85.61	85.71	85.59	85.63	23100.0
2009-04-14 07:15:00	SPY	ETF	85.66	85.84	85.66	85.81	19674.0
2009-04-14 07:20:00	SPY	ETF	85.78	85.8	85.65	85.74	148875.0
2009-04-14 07:25:00	SPY	ETF	85.74	85.75	85.6	85.6	277100.0
2009-04-14 07:30:00	SPY	ETF	85.59	85.59	85.56	85.57	8000.0
2009-04-14 07:35:00	SPY	ETF	85.59	85.59	85.48	85.52	51571.0
2009-04-14 07:40:00	SPY	ETF	85.51	85.54	85.49	85.5	127786.0
2009-04-14 07:45:00	SPY	ETF	85.5	85.61	85.5	85.56	212500.0
2009-04-14 07:50:00	SPY	ETF	85.56	85.62	85.55	85.59	137227.0
2009-04-14 07:55:00	SPY	ETF	85.59	85.59	85.54	85.56	168100.0
2009-04-14 08:00:00	SPY	ETF	85.56	85.77	85.1357	85.75	2215423.0
2009-04-14 08:05:00	SPY	ETF	85.76	86.06	85.75	86.03	1009838.0
2009-04-14 08:10:00	SPY	ETF	86.02	86.2	86.01	86.16	1431575.0
2009-04-14 08:15:00	SPY	ETF	86.16	86.17	86.05	86.17	521205.0
2009-04-14 08:20:00	SPY	ETF	86.16	86.19	86.09	86.17	483685.0
2009-04-14 08:25:00	SPY	ETF	86.18	86.18	86.06	86.07	290382.0
2009-04-14 08:30:00	SPY	ETF	86.06	86.06	85.44	85.54	1816589.0
2009-04-14 08:35:00	SPY	ETF	85.54	85.59	85.36	85.39	710767.0
2009-04-14 08:40:00	SPY	ETF	85.38	85.4	85.17	85.24	972494.0
2009-04-14 08:45:00	SPY	ETF	85.23	85.35	85.22	85.32	609370.0
2009-04-14 08:50:00	SPY	ETF	85.32	85.32	84.99	85.0	769678.0
2009-04-14 08:55:00	SPY	ETF	85.0	85.13	84.97	85.08	430515.0
2009-04-14 09:00:00	SPY	ETF	85.08	85.15	85.05	85.06	164691.0
2009-04-14 09:05:00	SPY	ETF	85.05	85.1	84.99	85.03	600259.0

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

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