PREVIEW / etf_1hour / 2008-07-17

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-07-17.parquet
  size:    116 KB
  rows:    3,679

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-17 04:00:00	SPY	ETF	124.02	124.02	123.98	123.98	300.0
2008-07-17 05:00:00	SPY	ETF	123.93	124.29	123.93	124.29	8100.0
2008-07-17 06:00:00	SPY	ETF	124.25	124.92	124.12	124.79	574100.0
2008-07-17 07:00:00	SPY	ETF	124.9	125.41	124.9	125.11	1762447.0
2008-07-17 08:00:00	SPY	ETF	123.73	125.39	123.73	125.18	6681862.0
2008-07-17 09:00:00	SPY	ETF	125.18	125.86	124.96	125.13	45890977.0
2008-07-17 10:00:00	SPY	ETF	125.13	125.53	124.52	124.728	63882598.0
2008-07-17 11:00:00	SPY	ETF	124.72	125.22	124.09	125.04	50367682.0
2008-07-17 12:00:00	SPY	ETF	125.04	125.06	124.52	124.9398	19316161.0
2008-07-17 13:00:00	SPY	ETF	124.93	126.19	124.8	125.955	55217200.0
2008-07-17 14:00:00	SPY	ETF	125.96	126.26	125.2	125.39	47214151.0
2008-07-17 15:00:00	SPY	ETF	125.4	125.94	124.87	125.91	53869340.0
2008-07-17 16:00:00	SPY	ETF	126.03	126.06	124.5	124.7	22160401.0
2008-07-17 17:00:00	SPY	ETF	124.71	125.3751	124.32	124.41	4113842.0
2008-07-17 18:00:00	SPY	ETF	124.44	124.61	124.42	124.53	72487.0
2008-07-17 19:00:00	SPY	ETF	124.5	124.58	124.44	124.46	20331.0
2008-07-17 05:00:00	QQQ	ETF	45.18	45.31	45.17	45.31	1100.0
2008-07-17 06:00:00	QQQ	ETF	45.33	45.6	45.24	45.6	50200.0
2008-07-17 07:00:00	QQQ	ETF	45.62	45.77	45.62	45.64	606256.0
2008-07-17 08:00:00	QQQ	ETF	45.64	45.76	45.55	45.67	2750687.0
2008-07-17 09:00:00	QQQ	ETF	45.66	45.78	45.36	45.38	30744656.0
2008-07-17 10:00:00	QQQ	ETF	45.37	45.48	45.16	45.23	34838056.0
2008-07-17 11:00:00	QQQ	ETF	45.23	45.42	44.9799	45.3	23175286.0
2008-07-17 12:00:00	QQQ	ETF	45.3	45.35	45.06	45.27	12137980.0
2008-07-17 13:00:00	QQQ	ETF	45.27	45.8	45.21	45.7	25720181.0
2008-07-17 14:00:00	QQQ	ETF	45.709	45.82	45.55	45.62	20784597.0
2008-07-17 15:00:00	QQQ	ETF	45.62	45.75	45.41	45.59	23732091.0
2008-07-17 16:00:00	QQQ	ETF	45.59	45.77	44.63	44.86	12626083.0
2008-07-17 17:00:00	QQQ	ETF	44.85	44.86	44.75	44.83	425420.0
2008-07-17 18:00:00	QQQ	ETF	44.83	45.3417	44.8	44.84	2267141.0
2008-07-17 19:00:00	QQQ	ETF	44.83	44.87	44.83	44.85	32807.0
2008-07-17 05:00:00	IWM	ETF	68.09	68.09	68.09	68.09	200.0
2008-07-17 07:00:00	IWM	ETF	68.72	68.99	68.72	68.84	210909.0
2008-07-17 08:00:00	IWM	ETF	68.83	69.04	68.55	68.95	1938092.0
2008-07-17 09:00:00	IWM	ETF	68.92	69.43	68.68	68.73	12781880.0
2008-07-17 10:00:00	IWM	ETF	68.73	68.92	68.38	68.55	21394134.0
2008-07-17 11:00:00	IWM	ETF	68.55	68.76	68.08	68.6	13883724.0
2008-07-17 12:00:00	IWM	ETF	68.6	68.61	68.25	68.45	5461959.0
2008-07-17 13:00:00	IWM	ETF	68.45	69.33	68.33	69.19	16879160.0
2008-07-17 14:00:00	IWM	ETF	69.19	69.53	68.96	69.1	14314267.0
2008-07-17 15:00:00	IWM	ETF	69.1	69.49	68.9	69.47	15570969.0
2008-07-17 16:00:00	IWM	ETF	69.47	69.56	67.96	68.41	10941268.0
2008-07-17 17:00:00	IWM	ETF	68.4	68.46	68.3	68.42	34775.0
2008-07-17 18:00:00	IWM	ETF	68.4	68.59	68.4	68.59	40910.0
2008-07-17 19:00:00	IWM	ETF	68.54	68.57	68.48	68.48	1620.0
2008-07-17 06:00:00	DIA	ETF	112.88	112.88	112.88	112.88	200.0
2008-07-17 07:00:00	DIA	ETF	113.1	113.35	113.1	113.13	21759.0
2008-07-17 08:00:00	DIA	ETF	113.12	113.36	112.87	113.2	408905.0
2008-07-17 09:00:00	DIA	ETF	113.17	113.57	112.93	113.06	4369631.0
2008-07-17 10:00:00	DIA	ETF	113.06	113.18	112.45	112.67	6047508.0

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

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