PREVIEW / etf_1hour / 2008-04-17

all etf 1-hour files

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

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-17 04:00:00	SPY	ETF	136.39	136.39	136.39	136.39	200.0
2008-04-17 05:00:00	SPY	ETF	136.34	136.36	136.34	136.36	1000.0
2008-04-17 06:00:00	SPY	ETF	136.33	136.76	136.26	136.51	180076.0
2008-04-17 07:00:00	SPY	ETF	136.51	136.58	136.18	136.26	760447.0
2008-04-17 08:00:00	SPY	ETF	136.26	136.36	135.86	135.97	2964992.0
2008-04-17 09:00:00	SPY	ETF	135.98	136.5	135.86	136.138	17823693.0
2008-04-17 10:00:00	SPY	ETF	136.12	136.65	135.75	136.27	35268728.0
2008-04-17 11:00:00	SPY	ETF	136.27	136.45	135.66	135.79	20990297.0
2008-04-17 12:00:00	SPY	ETF	135.8	136.14	135.68	136.1	13528650.0
2008-04-17 13:00:00	SPY	ETF	136.11	136.52	136.05	136.2	19727887.0
2008-04-17 14:00:00	SPY	ETF	136.2	136.5	136.0	136.22	17521864.0
2008-04-17 15:00:00	SPY	ETF	136.22	136.82	136.11	136.48	39101778.0
2008-04-17 16:00:00	SPY	ETF	136.44	137.41	136.29	137.22	6984670.0
2008-04-17 17:00:00	SPY	ETF	137.24	137.35	137.19	137.29	878701.0
2008-04-17 18:00:00	SPY	ETF	137.34	137.35	137.22	137.28	45135.0
2008-04-17 19:00:00	SPY	ETF	137.29	137.29	137.19	137.2	18497.0
2008-04-17 04:00:00	QQQ	ETF	45.52	45.52	45.52	45.52	200.0
2008-04-17 05:00:00	QQQ	ETF	45.6	45.6	45.6	45.6	500.0
2008-04-17 06:00:00	QQQ	ETF	45.56	45.65	45.46	45.58	145059.0
2008-04-17 07:00:00	QQQ	ETF	45.58	45.62	45.47	45.53	650998.0
2008-04-17 08:00:00	QQQ	ETF	45.51	45.53	45.38	45.41	2421661.0
2008-04-17 09:00:00	QQQ	ETF	45.41	45.47	45.2	45.3	16337823.0
2008-04-17 10:00:00	QQQ	ETF	45.3	45.39	45.14	45.2475	15654745.0
2008-04-17 11:00:00	QQQ	ETF	45.24	45.27	45.0	45.07	11932831.0
2008-04-17 12:00:00	QQQ	ETF	45.08	45.25	44.98	45.21	11101651.0
2008-04-17 13:00:00	QQQ	ETF	45.218	45.26	45.12	45.1401	8943681.0
2008-04-17 14:00:00	QQQ	ETF	45.14	45.24	45.06	45.12	8977324.0
2008-04-17 15:00:00	QQQ	ETF	45.12	45.43	45.1	45.278	20731405.0
2008-04-17 16:00:00	QQQ	ETF	45.27	46.04	45.25	45.98	24135716.0
2008-04-17 17:00:00	QQQ	ETF	45.98	46.04	45.93	46.0	901587.0
2008-04-17 18:00:00	QQQ	ETF	45.98	45.99	45.94	45.97	160979.0
2008-04-17 19:00:00	QQQ	ETF	45.96	45.99	45.95	45.96	66303.0
2008-04-17 06:00:00	IWM	ETF	71.18	71.21	71.13	71.13	500.0
2008-04-17 07:00:00	IWM	ETF	71.1	71.1	70.95	70.96	158143.0
2008-04-17 08:00:00	IWM	ETF	70.96	70.99	70.81	70.83	660483.0
2008-04-17 09:00:00	IWM	ETF	70.81	70.94	70.47	70.66	5304191.0
2008-04-17 10:00:00	IWM	ETF	70.66	70.83	70.3	70.57	10210090.0
2008-04-17 11:00:00	IWM	ETF	70.56	70.57	70.15	70.26	5350019.0
2008-04-17 12:00:00	IWM	ETF	70.27	70.55	70.23	70.46	3348690.0
2008-04-17 13:00:00	IWM	ETF	70.47	70.72	70.39	70.57	4707046.0
2008-04-17 14:00:00	IWM	ETF	70.57	70.66	70.39	70.43	2595014.0
2008-04-17 15:00:00	IWM	ETF	70.43	70.81	70.4	70.54	7180401.0
2008-04-17 16:00:00	IWM	ETF	70.51	71.14	70.33	71.06	3593290.0
2008-04-17 17:00:00	IWM	ETF	71.08	71.14	71.05	71.06	25768.0
2008-04-17 18:00:00	IWM	ETF	71.16	71.21	71.16	71.21	2764.0
2008-04-17 19:00:00	IWM	ETF	71.2	71.23	71.15	71.18	5033.0
2008-04-17 06:00:00	DIA	ETF	126.4	126.4	126.4	126.4	100.0
2008-04-17 07:00:00	DIA	ETF	126.2	126.22	126.11	126.22	2923.0
2008-04-17 08:00:00	DIA	ETF	126.15	126.23	125.75	125.81	155000.0
2008-04-17 09:00:00	DIA	ETF	125.79	126.13	125.74	126.01	1214354.0

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

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