PREVIEW / etf_5min / 2009-05-01

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-05-01.parquet
  size:    655 KB
  rows:    28,198

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-05-01 04:15:00	SPY	ETF	87.7	87.7	87.7	87.7	900.0
2009-05-01 04:20:00	SPY	ETF	87.7	87.7	87.7	87.7	100.0
2009-05-01 04:55:00	SPY	ETF	87.73	87.73	87.73	87.73	100.0
2009-05-01 05:00:00	SPY	ETF	87.78	87.84	87.78	87.84	1100.0
2009-05-01 05:15:00	SPY	ETF	87.77	87.77	87.77	87.77	100.0
2009-05-01 05:40:00	SPY	ETF	87.72	87.77	87.72	87.77	15150.0
2009-05-01 05:45:00	SPY	ETF	87.77	87.78	87.77	87.78	17500.0
2009-05-01 06:00:00	SPY	ETF	87.78	87.78	87.77	87.77	15600.0
2009-05-01 06:30:00	SPY	ETF	87.75	87.75	87.75	87.75	2500.0
2009-05-01 06:45:00	SPY	ETF	87.8	87.89	87.8	87.89	18002.0
2009-05-01 06:50:00	SPY	ETF	87.87	87.87	87.82	87.86	15634.0
2009-05-01 06:55:00	SPY	ETF	87.88	87.9	87.88	87.89	2100.0
2009-05-01 07:00:00	SPY	ETF	87.86	87.88	87.85	87.85	14810.0
2009-05-01 07:05:00	SPY	ETF	87.83	87.86	87.8	87.86	11435.0
2009-05-01 07:10:00	SPY	ETF	87.86	87.87	87.83	87.85	10300.0
2009-05-01 07:15:00	SPY	ETF	87.87	87.87	87.82	87.82	2508.0
2009-05-01 07:20:00	SPY	ETF	87.82	87.87	87.81	87.86	10338.0
2009-05-01 07:25:00	SPY	ETF	87.84	87.88	87.84	87.86	52219.0
2009-05-01 07:30:00	SPY	ETF	87.88	87.92	87.88	87.9	30611.0
2009-05-01 07:35:00	SPY	ETF	87.92	87.94	87.91	87.94	37369.0
2009-05-01 07:40:00	SPY	ETF	87.94	87.94	87.88	87.88	47131.0
2009-05-01 07:45:00	SPY	ETF	87.86	87.87	87.84	87.84	61616.0
2009-05-01 07:50:00	SPY	ETF	87.85	87.9	87.83	87.9	48167.0
2009-05-01 07:55:00	SPY	ETF	87.88	87.88	87.84	87.86	129007.0
2009-05-01 08:00:00	SPY	ETF	87.86	87.88	87.78	87.87	957735.0
2009-05-01 08:05:00	SPY	ETF	87.86	87.87	87.82	87.82	54240.0
2009-05-01 08:10:00	SPY	ETF	87.81	87.82	87.74	87.81	171974.0
2009-05-01 08:15:00	SPY	ETF	87.83	87.89	87.82	87.85	69727.0
2009-05-01 08:20:00	SPY	ETF	87.86	87.88	87.25	87.84	266153.0
2009-05-01 08:25:00	SPY	ETF	87.83	87.83	87.76	87.79	123220.0
2009-05-01 08:30:00	SPY	ETF	87.8	87.84	87.79	87.79	85204.0
2009-05-01 08:35:00	SPY	ETF	87.78	87.81	87.7	87.75	219376.0
2009-05-01 08:40:00	SPY	ETF	87.75	87.78	87.72	87.74	78210.0
2009-05-01 08:45:00	SPY	ETF	87.76	87.76	87.55	87.74	81544.0
2009-05-01 08:50:00	SPY	ETF	87.9	87.9	87.42	87.72	60441.0
2009-05-01 08:55:00	SPY	ETF	87.71	87.74	87.68	87.73	143402.0
2009-05-01 09:00:00	SPY	ETF	87.73	87.73	87.56	87.58	380418.0
2009-05-01 09:05:00	SPY	ETF	87.57	87.57	87.47	87.56	782477.0
2009-05-01 09:10:00	SPY	ETF	87.55	87.56	87.45	87.48	374179.0
2009-05-01 09:15:00	SPY	ETF	87.48	87.5	87.28	87.45	862279.0
2009-05-01 09:20:00	SPY	ETF	87.45	87.49	87.43	87.46	156565.0
2009-05-01 09:25:00	SPY	ETF	87.47	87.47	87.37	87.45	498463.0
2009-05-01 09:30:00	SPY	ETF	87.44	87.48	87.18	87.24	3758753.0
2009-05-01 09:35:00	SPY	ETF	87.24	87.36	87.08	87.08	4963165.0
2009-05-01 09:40:00	SPY	ETF	87.09	87.16	87.02	87.13	3597217.0
2009-05-01 09:45:00	SPY	ETF	87.13	87.35	86.94	86.99	3045252.0
2009-05-01 09:50:00	SPY	ETF	86.9899	87.24	86.97	87.24	3636669.0
2009-05-01 09:55:00	SPY	ETF	87.24	87.41	87.23	87.36	3857956.0
2009-05-01 10:00:00	SPY	ETF	87.3601	87.5	87.14	87.42	7418209.0
2009-05-01 10:05:00	SPY	ETF	87.42	87.46	87.15	87.15	4043360.0

> showing 50 of 28,198 rows — these rows as CSV

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