PREVIEW / etf_1hour / 2008-04-29

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-04-29.parquet
  size:    105 KB
  rows:    3,372

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
2008-04-29 04:00:00	SPY	ETF	139.57	139.57	139.57	139.57	300.0
2008-04-29 05:00:00	SPY	ETF	139.43	139.43	139.37	139.41	500.0
2008-04-29 06:00:00	SPY	ETF	139.3	139.4	139.22	139.35	227200.0
2008-04-29 07:00:00	SPY	ETF	139.34	139.5	139.25	139.3	567205.0
2008-04-29 08:00:00	SPY	ETF	139.31	139.62	139.26	139.47	2201275.0
2008-04-29 09:00:00	SPY	ETF	139.47	139.73	139.22	139.31	16703098.0
2008-04-29 10:00:00	SPY	ETF	139.31	139.55	138.61	138.77	23050901.0
2008-04-29 11:00:00	SPY	ETF	138.77	139.07	138.67	138.88	14817301.0
2008-04-29 12:00:00	SPY	ETF	138.88	139.597	138.77	139.0	13473349.0
2008-04-29 13:00:00	SPY	ETF	139.0	139.41	138.94	139.25	15834602.0
2008-04-29 14:00:00	SPY	ETF	139.25	139.59	139.05	139.55	14769115.0
2008-04-29 15:00:00	SPY	ETF	139.55	139.61	138.97	139.07	19573408.0
2008-04-29 16:00:00	SPY	ETF	139.12	139.3	138.68	138.87	2884575.0
2008-04-29 17:00:00	SPY	ETF	138.85	138.88	138.8	138.85	121633.0
2008-04-29 18:00:00	SPY	ETF	138.84	139.01	138.84	139.01	31537.0
2008-04-29 19:00:00	SPY	ETF	138.94	139.0	138.9	138.95	12165.0
2008-04-29 04:00:00	QQQ	ETF	47.24	47.24	47.24	47.24	1000.0
2008-04-29 05:00:00	QQQ	ETF	47.15	47.15	47.15	47.15	200.0
2008-04-29 06:00:00	QQQ	ETF	47.13	47.13	47.07	47.1	950.0
2008-04-29 07:00:00	QQQ	ETF	47.1	47.16	47.09	47.11	80064.0
2008-04-29 08:00:00	QQQ	ETF	47.12	47.2	47.1	47.15	671174.0
2008-04-29 09:00:00	QQQ	ETF	47.14	47.35	47.11	47.32	10878546.0
2008-04-29 10:00:00	QQQ	ETF	47.32	47.39	47.06	47.19	18237307.0
2008-04-29 11:00:00	QQQ	ETF	47.19	47.38	47.16	47.27	6471158.0
2008-04-29 12:00:00	QQQ	ETF	47.28	47.358	47.18	47.27	8558067.0
2008-04-29 13:00:00	QQQ	ETF	47.27	47.57	47.25	47.45	9621697.0
2008-04-29 14:00:00	QQQ	ETF	47.44	47.73	47.32	47.71	14883161.0
2008-04-29 15:00:00	QQQ	ETF	47.71	47.76	47.52	47.6	14232099.0
2008-04-29 16:00:00	QQQ	ETF	47.6	47.634	47.2984	47.56	5828900.0
2008-04-29 17:00:00	QQQ	ETF	47.54	47.57	47.53	47.57	4364.0
2008-04-29 18:00:00	QQQ	ETF	47.55	47.58	47.53	47.57	15156.0
2008-04-29 19:00:00	QQQ	ETF	47.58	47.62	47.57	47.57	36483.0
2008-04-29 05:00:00	IWM	ETF	72.22	72.22	72.22	72.22	100.0
2008-04-29 06:00:00	IWM	ETF	72.17	72.17	72.17	72.17	100.0
2008-04-29 07:00:00	IWM	ETF	72.24	72.27	72.17	72.17	13000.0
2008-04-29 08:00:00	IWM	ETF	72.19	72.36	72.18	72.35	71079.0
2008-04-29 09:00:00	IWM	ETF	72.34	72.38	72.02	72.11	3785174.0
2008-04-29 10:00:00	IWM	ETF	72.12	72.26	71.63	71.67	7100937.0
2008-04-29 11:00:00	IWM	ETF	71.67	71.84	71.5	71.53	3381809.0
2008-04-29 12:00:00	IWM	ETF	71.52	71.61	71.32	71.33	4366920.0
2008-04-29 13:00:00	IWM	ETF	71.34	71.77	71.29	71.65	4221651.0
2008-04-29 14:00:00	IWM	ETF	71.65	71.99	71.5	71.95	4801480.0
2008-04-29 15:00:00	IWM	ETF	71.95	72.02	71.63	71.81	6960827.0
2008-04-29 16:00:00	IWM	ETF	71.81	72.36	71.61	71.7	2833863.0
2008-04-29 17:00:00	IWM	ETF	71.71	71.77	71.7	71.77	50961.0
2008-04-29 18:00:00	IWM	ETF	71.74	71.87	71.69	71.87	1600.0
2008-04-29 19:00:00	IWM	ETF	71.77	71.77	71.77	71.77	100.0
2008-04-29 07:00:00	DIA	ETF	128.31	128.37	128.31	128.37	200.0
2008-04-29 08:00:00	DIA	ETF	128.3	128.5	128.23	128.44	41192.0
2008-04-29 09:00:00	DIA	ETF	128.42	128.76	128.35	128.61	776246.0

> showing 50 of 3,372 rows — these rows as CSV

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