PREVIEW / etf_1hour / 2008-07-28

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-07-28.parquet
  size:    107 KB
  rows:    3,402

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-07-28 04:00:00	SPY	ETF	125.34	125.45	125.3	125.45	1100.0
2008-07-28 05:00:00	SPY	ETF	125.35	125.38	125.11	125.11	2200.0
2008-07-28 06:00:00	SPY	ETF	125.11	125.21	125.1	125.18	11630.0
2008-07-28 07:00:00	SPY	ETF	125.24	125.6	125.13	125.6	651669.0
2008-07-28 08:00:00	SPY	ETF	125.59	125.64	125.3	125.44	865268.0
2008-07-28 09:00:00	SPY	ETF	125.43	125.98	125.37	125.68	20353711.0
2008-07-28 10:00:00	SPY	ETF	125.68	126.06	125.42	125.51	26187661.0
2008-07-28 11:00:00	SPY	ETF	125.5	125.53	124.76	124.95	28013693.0
2008-07-28 12:00:00	SPY	ETF	124.95	125.13	124.25	124.35	22261524.0
2008-07-28 13:00:00	SPY	ETF	124.36	125.53	124.11	124.3	20999570.0
2008-07-28 14:00:00	SPY	ETF	124.3	124.56	123.86	123.92	29422764.0
2008-07-28 15:00:00	SPY	ETF	123.92	124.29	123.42	123.57	37797730.0
2008-07-28 16:00:00	SPY	ETF	123.58	125.7881	123.47	123.53	12867915.0
2008-07-28 17:00:00	SPY	ETF	123.55	123.59	123.2	123.58	356344.0
2008-07-28 18:00:00	SPY	ETF	123.52	123.81	123.51	123.79	190266.0
2008-07-28 19:00:00	SPY	ETF	123.77	123.77	123.62	123.68	46767.0
2008-07-28 07:00:00	QQQ	ETF	45.13	45.31	45.07	45.31	51600.0
2008-07-28 08:00:00	QQQ	ETF	45.32	45.32	45.2	45.25	192649.0
2008-07-28 09:00:00	QQQ	ETF	45.23	45.52	45.14	45.19	20025078.0
2008-07-28 10:00:00	QQQ	ETF	45.19	45.36	45.14	45.18	16619076.0
2008-07-28 11:00:00	QQQ	ETF	45.171	45.19	44.79	44.93	16633052.0
2008-07-28 12:00:00	QQQ	ETF	44.92	44.95	44.59	44.64	11302050.0
2008-07-28 13:00:00	QQQ	ETF	44.63	44.78	44.57	44.6999	9331349.0
2008-07-28 14:00:00	QQQ	ETF	44.7	44.74	44.35	44.36	16931782.0
2008-07-28 15:00:00	QQQ	ETF	44.36	44.58	44.21	44.4	20123531.0
2008-07-28 16:00:00	QQQ	ETF	44.4	45.4045	44.33	44.51	7653854.0
2008-07-28 17:00:00	QQQ	ETF	44.49	44.5	44.4	44.4	19850.0
2008-07-28 18:00:00	QQQ	ETF	44.44	44.55	44.44	44.53	131285.0
2008-07-28 19:00:00	QQQ	ETF	44.55	44.56	44.5	44.54	8808.0
2008-07-28 07:00:00	IWM	ETF	70.48	70.71	70.48	70.71	139800.0
2008-07-28 08:00:00	IWM	ETF	70.65	70.71	70.57	70.65	367365.0
2008-07-28 09:00:00	IWM	ETF	70.65	70.84	70.41	70.47	6504750.0
2008-07-28 10:00:00	IWM	ETF	70.47	70.68	70.15	70.25	8750639.0
2008-07-28 11:00:00	IWM	ETF	70.25	70.26	69.74	70.03	12622025.0
2008-07-28 12:00:00	IWM	ETF	70.03	70.16	69.69	69.74	7675694.0
2008-07-28 13:00:00	IWM	ETF	69.74	69.86	69.57	69.65	7133211.0
2008-07-28 14:00:00	IWM	ETF	69.66	69.78	69.27	69.37	12243395.0
2008-07-28 15:00:00	IWM	ETF	69.37	69.63	69.22	69.43	19947304.0
2008-07-28 16:00:00	IWM	ETF	69.43	69.77	69.41	69.46	4322811.0
2008-07-28 17:00:00	IWM	ETF	69.48	69.48	69.35	69.4	37102.0
2008-07-28 18:00:00	IWM	ETF	69.4	69.55	69.4	69.55	8100.0
2008-07-28 19:00:00	IWM	ETF	69.43	69.52	69.43	69.52	1655.0
2008-07-28 07:00:00	DIA	ETF	113.09	113.33	113.03	113.33	5600.0
2008-07-28 08:00:00	DIA	ETF	113.3	113.36	113.2	113.28	46490.0
2008-07-28 09:00:00	DIA	ETF	113.29	113.46	113.1	113.24	1730175.0
2008-07-28 10:00:00	DIA	ETF	113.24	113.52	112.75	112.81	2320524.0
2008-07-28 11:00:00	DIA	ETF	112.82	112.84	112.2	112.33	2607230.0
2008-07-28 12:00:00	DIA	ETF	112.31	112.46	111.74	111.78	2109538.0
2008-07-28 13:00:00	DIA	ETF	111.78	112.01	111.62	111.81	1640139.0
2008-07-28 14:00:00	DIA	ETF	111.82	112.05	111.53	111.59	1917627.0

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

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