PREVIEW / etf_1hour / 2008-01-09

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-01-09.parquet
  size:    101 KB
  rows:    3,357

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-01-09 04:00:00	SPY	ETF	139.36	139.36	139.1	139.2	6200.0
2008-01-09 05:00:00	SPY	ETF	139.25	139.46	139.23	139.3	102300.0
2008-01-09 06:00:00	SPY	ETF	139.35	139.73	139.35	139.54	130100.0
2008-01-09 07:00:00	SPY	ETF	139.55	139.64	138.93	139.09	1250800.0
2008-01-09 08:00:00	SPY	ETF	139.615	139.615	138.64	138.71	4338929.0
2008-01-09 09:00:00	SPY	ETF	138.73	139.6	138.55	139.33	38346160.0
2008-01-09 10:00:00	SPY	ETF	139.35	139.89	139.01	139.55	44814860.0
2008-01-09 11:00:00	SPY	ETF	139.52	139.67	138.0	138.67	30192845.0
2008-01-09 12:00:00	SPY	ETF	138.66	139.38	138.51	139.11	20123384.0
2008-01-09 13:00:00	SPY	ETF	139.11	139.62	138.0	138.21	27809742.0
2008-01-09 14:00:00	SPY	ETF	138.21	139.36	137.7	139.16	49350952.0
2008-01-09 15:00:00	SPY	ETF	139.16	140.79	139.08	140.78	74214680.0
2008-01-09 16:00:00	SPY	ETF	140.77	140.8	138.8	140.58	7470800.0
2008-01-09 17:00:00	SPY	ETF	140.58	140.84	137.8	140.79	892300.0
2008-01-09 18:00:00	SPY	ETF	140.75	140.75	140.68	140.68	54900.0
2008-01-09 19:00:00	SPY	ETF	140.6	140.72	140.45	140.48	30600.0
2008-01-09 04:00:00	QQQ	ETF	47.06	47.06	47.06	47.06	100.0
2008-01-09 05:00:00	QQQ	ETF	47.21	47.21	47.21	47.21	100.0
2008-01-09 06:00:00	QQQ	ETF	47.2	47.33	47.2	47.25	127230.0
2008-01-09 07:00:00	QQQ	ETF	47.25	47.25	47.09	47.16	550443.0
2008-01-09 08:00:00	QQQ	ETF	47.13	47.21	46.98	47.0	1625349.0
2008-01-09 09:00:00	QQQ	ETF	47.01	47.48	46.86	47.32	31134580.0
2008-01-09 10:00:00	QQQ	ETF	47.32	47.58	47.03	47.38	50911288.0
2008-01-09 11:00:00	QQQ	ETF	47.38	47.45	46.77	46.99	23884246.0
2008-01-09 12:00:00	QQQ	ETF	46.99	47.24	46.92	47.1	19952713.0
2008-01-09 13:00:00	QQQ	ETF	47.1	47.17	46.65	46.78	24483630.0
2008-01-09 14:00:00	QQQ	ETF	46.78	47.39	46.46	47.34	42370064.0
2008-01-09 15:00:00	QQQ	ETF	47.34	47.96	47.31	47.94	54024511.0
2008-01-09 16:00:00	QQQ	ETF	47.94	47.94	46.75	47.86	5255462.0
2008-01-09 17:00:00	QQQ	ETF	47.86	47.92	47.86	47.88	586346.0
2008-01-09 18:00:00	QQQ	ETF	47.89	47.93	47.88	47.88	201657.0
2008-01-09 19:00:00	QQQ	ETF	47.88	47.9	47.86	47.87	78523.0
2008-01-09 07:00:00	IWM	ETF	70.1	70.2	69.81	70.05	85100.0
2008-01-09 08:00:00	IWM	ETF	70.01	70.21	69.84	69.85	416900.0
2008-01-09 09:00:00	IWM	ETF	69.88	70.55	69.69	70.18	12976566.0
2008-01-09 10:00:00	IWM	ETF	70.19	70.51	69.88	70.25	17876984.0
2008-01-09 11:00:00	IWM	ETF	70.26	70.38	69.43	69.6	14991406.0
2008-01-09 12:00:00	IWM	ETF	69.61	69.92	69.44	69.74	7820685.0
2008-01-09 13:00:00	IWM	ETF	69.74	69.85	68.97	69.06	9708596.0
2008-01-09 14:00:00	IWM	ETF	69.07	69.96	68.62	69.86	24911752.0
2008-01-09 15:00:00	IWM	ETF	69.87	70.97	69.77	70.95	37807758.0
2008-01-09 16:00:00	IWM	ETF	70.95	71.02	70.0	70.74	14587300.0
2008-01-09 17:00:00	IWM	ETF	70.75	70.99	69.72	69.72	2032400.0
2008-01-09 18:00:00	IWM	ETF	69.7	70.83	69.7	70.81	26700.0
2008-01-09 19:00:00	IWM	ETF	70.75	70.75	70.74	70.75	3000.0
2008-01-09 07:00:00	DIA	ETF	126.48	126.5	126.08	126.11	17400.0
2008-01-09 08:00:00	DIA	ETF	126.03	126.28	125.82	125.85	55800.0
2008-01-09 09:00:00	DIA	ETF	125.83	126.71	125.73	126.47	2684689.0
2008-01-09 10:00:00	DIA	ETF	126.5	126.85	126.14	126.59	2879291.0
2008-01-09 11:00:00	DIA	ETF	126.59	126.7	125.6	125.84	2950041.0

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

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