PREVIEW / etf_5min / 2009-09-03

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-09-03.parquet
  size:    675 KB
  rows:    28,937

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-09-03 04:15:00	SPY	ETF	100.3	100.3	100.3	100.3	3000.0
2009-09-03 04:50:00	SPY	ETF	100.38	100.4	100.38	100.4	650.0
2009-09-03 04:55:00	SPY	ETF	100.41	100.45	100.41	100.45	200.0
2009-09-03 05:25:00	SPY	ETF	100.4	100.4	100.4	100.4	200.0
2009-09-03 05:45:00	SPY	ETF	100.31	100.31	100.31	100.31	5000.0
2009-09-03 06:05:00	SPY	ETF	100.35	100.35	100.35	100.35	1000.0
2009-09-03 06:10:00	SPY	ETF	100.35	100.35	100.35	100.35	500.0
2009-09-03 06:20:00	SPY	ETF	100.38	100.38	100.38	100.38	200.0
2009-09-03 06:40:00	SPY	ETF	100.34	100.34	100.34	100.34	1000.0
2009-09-03 06:45:00	SPY	ETF	100.29	100.29	100.29	100.29	100.0
2009-09-03 06:50:00	SPY	ETF	100.41	100.41	100.36	100.36	200.0
2009-09-03 06:55:00	SPY	ETF	100.41	100.41	100.41	100.41	100.0
2009-09-03 07:00:00	SPY	ETF	100.44	100.44	100.4	100.4	6500.0
2009-09-03 07:05:00	SPY	ETF	100.41	100.46	100.41	100.46	4277.0
2009-09-03 07:10:00	SPY	ETF	100.44	100.48	100.41	100.47	6500.0
2009-09-03 07:15:00	SPY	ETF	100.45	100.48	100.4	100.4	19426.0
2009-09-03 07:20:00	SPY	ETF	100.41	100.54	100.41	100.53	71677.0
2009-09-03 07:25:00	SPY	ETF	100.51	100.68	100.51	100.65	27504.0
2009-09-03 07:30:00	SPY	ETF	100.64	100.82	100.64	100.8	78028.0
2009-09-03 07:35:00	SPY	ETF	100.8	100.87	100.77	100.83	102925.0
2009-09-03 07:40:00	SPY	ETF	100.8	100.8	100.72	100.72	76995.0
2009-09-03 07:45:00	SPY	ETF	100.74	100.74	100.69	100.72	107250.0
2009-09-03 07:50:00	SPY	ETF	100.75	100.75	100.66	100.66	73100.0
2009-09-03 07:55:00	SPY	ETF	100.66	100.7	100.65	100.66	256645.0
2009-09-03 08:00:00	SPY	ETF	100.65	100.67	100.35	100.64	119008.0
2009-09-03 08:05:00	SPY	ETF	100.64	100.67	100.62	100.66	69943.0
2009-09-03 08:10:00	SPY	ETF	100.67	100.72	100.64	100.7	140515.0
2009-09-03 08:15:00	SPY	ETF	100.7	100.75	100.69	100.72	203360.0
2009-09-03 08:20:00	SPY	ETF	100.72	100.73	100.67	100.72	93258.0
2009-09-03 08:25:00	SPY	ETF	100.72	100.82	100.72	100.77	364272.0
2009-09-03 08:30:00	SPY	ETF	100.77	100.8	100.36	100.52	2459054.0
2009-09-03 08:35:00	SPY	ETF	100.52	100.61	100.48	100.49	541215.0
2009-09-03 08:40:00	SPY	ETF	100.49	100.56	100.42	100.56	443538.0
2009-09-03 08:45:00	SPY	ETF	100.55	100.56	100.44	100.45	189000.0
2009-09-03 08:50:00	SPY	ETF	100.45	100.49	100.43	100.45	62000.0
2009-09-03 08:55:00	SPY	ETF	100.45	100.48	100.44	100.46	678084.0
2009-09-03 09:00:00	SPY	ETF	100.45	100.52	100.43	100.49	165856.0
2009-09-03 09:05:00	SPY	ETF	100.49	100.53	100.46	100.46	77195.0
2009-09-03 09:10:00	SPY	ETF	100.47	100.52	100.44	100.45	85221.0
2009-09-03 09:15:00	SPY	ETF	100.45	100.46	100.37	100.37	130255.0
2009-09-03 09:20:00	SPY	ETF	100.37	100.41	100.31	100.37	385864.0
2009-09-03 09:25:00	SPY	ETF	100.37	100.43	100.37	100.4	162763.0
2009-09-03 09:30:00	SPY	ETF	100.4	100.62	100.22	100.45	4797597.0
2009-09-03 09:35:00	SPY	ETF	100.44	100.5	100.25	100.335	3393465.0
2009-09-03 09:40:00	SPY	ETF	100.34	100.41	100.29	100.38	2408517.0
2009-09-03 09:45:00	SPY	ETF	100.3899	100.45	100.24	100.3699	2583645.0
2009-09-03 09:50:00	SPY	ETF	100.37	100.45	100.31	100.38	1908021.0
2009-09-03 09:55:00	SPY	ETF	100.39	100.44	100.09	100.35	4201272.0
2009-09-03 10:00:00	SPY	ETF	100.35	100.58	100.02	100.07	8839608.0
2009-09-03 10:05:00	SPY	ETF	100.08	100.77	99.81	100.02	5595380.0

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

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