PREVIEW / etf_1hour / 2008-02-13

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-02-13.parquet
  size:    96 KB
  rows:    3,178

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-02-13 05:00:00	SPY	ETF	135.26	135.41	135.26	135.41	5800.0
2008-02-13 06:00:00	SPY	ETF	135.41	135.44	135.1	135.11	33800.0
2008-02-13 07:00:00	SPY	ETF	135.09	135.58	135.09	135.51	1059700.0
2008-02-13 08:00:00	SPY	ETF	135.5	136.27	134.58	135.9	9695540.0
2008-02-13 09:00:00	SPY	ETF	135.89	136.5	134.51	135.8	25430556.0
2008-02-13 10:00:00	SPY	ETF	135.79	136.21	135.14	135.54	36718886.0
2008-02-13 11:00:00	SPY	ETF	135.53	136.06	135.45	135.78	17957292.0
2008-02-13 12:00:00	SPY	ETF	135.78	136.23	135.72	136.02	13477207.0
2008-02-13 13:00:00	SPY	ETF	136.02	137.1	135.88	136.44	20222451.0
2008-02-13 14:00:00	SPY	ETF	136.45	136.64	136.08	136.53	17202423.0
2008-02-13 15:00:00	SPY	ETF	136.53	137.06	136.39	136.71	33283724.0
2008-02-13 16:00:00	SPY	ETF	136.68	136.82	135.5186	136.59	3715800.0
2008-02-13 17:00:00	SPY	ETF	136.53	136.61	136.37	136.47	367000.0
2008-02-13 18:00:00	SPY	ETF	136.54	136.59	136.43	136.59	31500.0
2008-02-13 19:00:00	SPY	ETF	136.64	136.67	136.59	136.64	45400.0
2008-02-13 04:00:00	QQQ	ETF	43.99	44.04	43.99	44.04	500.0
2008-02-13 06:00:00	QQQ	ETF	44.11	44.11	43.99	43.99	25500.0
2008-02-13 07:00:00	QQQ	ETF	44.0	44.16	43.99	44.14	430777.0
2008-02-13 08:00:00	QQQ	ETF	44.13	44.44	44.02	44.34	7000129.0
2008-02-13 09:00:00	QQQ	ETF	44.34	44.54	44.2	44.33	29652247.0
2008-02-13 10:00:00	QQQ	ETF	44.33	44.47	44.16	44.27	19684418.0
2008-02-13 11:00:00	QQQ	ETF	44.27	44.44	44.24	44.35	13142475.0
2008-02-13 12:00:00	QQQ	ETF	44.35	44.48	44.33	44.43	9072543.0
2008-02-13 13:00:00	QQQ	ETF	44.42	44.88	44.34	44.74	23716209.0
2008-02-13 14:00:00	QQQ	ETF	44.74	44.8	44.61	44.77	12931488.0
2008-02-13 15:00:00	QQQ	ETF	44.775	44.85	44.7	44.8	21642806.0
2008-02-13 16:00:00	QQQ	ETF	44.79	44.84	43.7917	44.81	10688504.0
2008-02-13 17:00:00	QQQ	ETF	44.8	44.84	44.76	44.84	449992.0
2008-02-13 18:00:00	QQQ	ETF	44.82	44.86	44.8	44.86	116794.0
2008-02-13 19:00:00	QQQ	ETF	44.86	44.87	44.84	44.86	131605.0
2008-02-13 05:00:00	IWM	ETF	70.58	70.58	70.58	70.58	200.0
2008-02-13 07:00:00	IWM	ETF	70.67	70.67	70.55	70.55	8600.0
2008-02-13 08:00:00	IWM	ETF	70.55	71.08	70.46	70.95	736500.0
2008-02-13 09:00:00	IWM	ETF	70.88	71.44	70.86	70.96	14888138.0
2008-02-13 10:00:00	IWM	ETF	70.96	71.31	70.7	70.94	12654375.0
2008-02-13 11:00:00	IWM	ETF	70.94	71.38	70.9	71.24	9607234.0
2008-02-13 12:00:00	IWM	ETF	71.23	71.59	71.21	71.41	8661481.0
2008-02-13 13:00:00	IWM	ETF	71.4	71.78	71.32	71.61	9120665.0
2008-02-13 14:00:00	IWM	ETF	71.6	71.83	71.36	71.73	9095606.0
2008-02-13 15:00:00	IWM	ETF	71.73	71.95	71.6	71.85	11640078.0
2008-02-13 16:00:00	IWM	ETF	71.85	71.94	71.39	71.9	10171900.0
2008-02-13 17:00:00	IWM	ETF	71.87	71.89	71.75	71.75	22100.0
2008-02-13 18:00:00	IWM	ETF	71.85	71.89	71.85	71.89	4500.0
2008-02-13 07:00:00	DIA	ETF	124.1	124.15	124.08	124.15	9000.0
2008-02-13 08:00:00	DIA	ETF	124.14	124.7	123.88	124.43	176300.0
2008-02-13 09:00:00	DIA	ETF	124.38	125.03	124.34	124.75	2676486.0
2008-02-13 10:00:00	DIA	ETF	124.74	125.14	124.16	124.51	3052332.0
2008-02-13 11:00:00	DIA	ETF	124.51	124.94	124.45	124.68	1029123.0
2008-02-13 12:00:00	DIA	ETF	124.68	125.02	124.64	124.88	980999.0
2008-02-13 13:00:00	DIA	ETF	124.86	125.49	124.78	125.29	1448028.0

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

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