PREVIEW / etf_1hour / 2009-01-29

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-01-29.parquet
  size:    125 KB
  rows:    3,848

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-01-29 04:00:00	SPY	ETF	86.6	86.6	86.08	86.25	19800.0
2009-01-29 05:00:00	SPY	ETF	86.53	86.58	86.45	86.57	2600.0
2009-01-29 06:00:00	SPY	ETF	86.67	86.68	86.31	86.52	62500.0
2009-01-29 07:00:00	SPY	ETF	86.7	87.03	86.62	86.63	765768.0
2009-01-29 08:00:00	SPY	ETF	86.64	86.7	86.26	86.5	4471557.0
2009-01-29 09:00:00	SPY	ETF	86.49	86.51	85.66	85.81	34308839.0
2009-01-29 10:00:00	SPY	ETF	85.82	86.34	85.47	86.25	46231333.0
2009-01-29 11:00:00	SPY	ETF	86.25	86.31	85.55	85.68	27991307.0
2009-01-29 12:00:00	SPY	ETF	85.68	85.73	84.94	85.03	28173302.0
2009-01-29 13:00:00	SPY	ETF	85.03	86.15	84.71	84.935	35156099.0
2009-01-29 14:00:00	SPY	ETF	84.93	85.48	84.85	85.08	39153264.0
2009-01-29 15:00:00	SPY	ETF	85.08	87.4901	84.47	84.57	61963909.0
2009-01-29 16:00:00	SPY	ETF	84.58	85.83	84.46	84.74	14095933.0
2009-01-29 17:00:00	SPY	ETF	84.78	84.81	84.55	84.65	171881.0
2009-01-29 18:00:00	SPY	ETF	84.67	84.95	84.65	84.94	91372.0
2009-01-29 19:00:00	SPY	ETF	84.94	84.94	84.52	84.76	157344.0
2009-01-29 04:00:00	QQQ	ETF	30.0	30.0	29.9	29.9	6255.0
2009-01-29 05:00:00	QQQ	ETF	29.99	30.09	29.99	30.09	600.0
2009-01-29 06:00:00	QQQ	ETF	30.0	30.0	30.0	30.0	10300.0
2009-01-29 07:00:00	QQQ	ETF	30.07	30.24	30.07	30.13	169983.0
2009-01-29 08:00:00	QQQ	ETF	30.12	30.14	29.92	30.06	1625993.0
2009-01-29 09:00:00	QQQ	ETF	30.05	30.05	29.8	29.87	18888122.0
2009-01-29 10:00:00	QQQ	ETF	29.86	30.04	29.76	30.01	26081031.0
2009-01-29 11:00:00	QQQ	ETF	30.0	30.03	29.83	29.88	11841081.0
2009-01-29 12:00:00	QQQ	ETF	29.8779	29.89	29.59	29.61	13210465.0
2009-01-29 13:00:00	QQQ	ETF	29.61	29.68	29.48	29.6	15329771.0
2009-01-29 14:00:00	QQQ	ETF	29.6	29.81	29.57	29.69	15009919.0
2009-01-29 15:00:00	QQQ	ETF	29.69	29.81	29.5	29.58	21537916.0
2009-01-29 16:00:00	QQQ	ETF	29.58	29.76	29.52	29.7	5197558.0
2009-01-29 17:00:00	QQQ	ETF	29.71	29.72	29.61	29.67	141691.0
2009-01-29 18:00:00	QQQ	ETF	29.65	29.72	29.64	29.7	29206.0
2009-01-29 19:00:00	QQQ	ETF	29.7	29.7	29.6	29.66	16737.0
2009-01-29 06:00:00	IWM	ETF	46.88	46.88	46.88	46.88	330.0
2009-01-29 07:00:00	IWM	ETF	46.88	47.11	46.88	47.0	43470.0
2009-01-29 08:00:00	IWM	ETF	47.0	47.04	46.77	46.77	220483.0
2009-01-29 09:00:00	IWM	ETF	46.77	46.831	46.24	46.33	6242716.0
2009-01-29 10:00:00	IWM	ETF	46.33	46.65	46.04	46.56	9196949.0
2009-01-29 11:00:00	IWM	ETF	46.56	46.57	46.0775	46.16	4899012.0
2009-01-29 12:00:00	IWM	ETF	46.16	46.16	45.72	45.76	4750780.0
2009-01-29 13:00:00	IWM	ETF	45.76	45.77	45.3775	45.5	7003529.0
2009-01-29 14:00:00	IWM	ETF	45.5	45.82	45.47	45.54	6824855.0
2009-01-29 15:00:00	IWM	ETF	45.55	46.65	45.25	45.31	15023856.0
2009-01-29 16:00:00	IWM	ETF	45.31	45.71	45.27	45.59	1227924.0
2009-01-29 17:00:00	IWM	ETF	47.2332	47.2332	45.5	45.5	3006696.0
2009-01-29 18:00:00	IWM	ETF	45.64	45.64	45.64	45.64	500.0
2009-01-29 19:00:00	IWM	ETF	45.5	45.5	45.4	45.4	11553.0
2009-01-29 06:00:00	DIA	ETF	82.8	82.86	82.63	82.86	700.0
2009-01-29 07:00:00	DIA	ETF	83.04	83.22	82.92	82.92	7645.0
2009-01-29 08:00:00	DIA	ETF	82.96	83.04	82.71	82.9	49204.0
2009-01-29 09:00:00	DIA	ETF	82.85	82.93	82.37	82.49	2346502.0

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

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