PREVIEW / etf_1hour / 2008-07-23

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-07-23.parquet
  size:    113 KB
  rows:    3,602

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-23 04:00:00	SPY	ETF	127.97	128.25	127.97	128.25	148100.0
2008-07-23 05:00:00	SPY	ETF	128.13	128.15	128.13	128.15	8000.0
2008-07-23 06:00:00	SPY	ETF	128.2	128.25	128.04	128.08	157700.0
2008-07-23 07:00:00	SPY	ETF	127.99	128.18	127.88	128.1	1174848.0
2008-07-23 08:00:00	SPY	ETF	128.07	128.28	127.94	128.02	3099061.0
2008-07-23 09:00:00	SPY	ETF	128.03	128.25	127.55	127.88	36408072.0
2008-07-23 10:00:00	SPY	ETF	127.88	129.15	127.75	128.57	69716438.0
2008-07-23 11:00:00	SPY	ETF	128.57	128.71	128.02	128.1	42124444.0
2008-07-23 12:00:00	SPY	ETF	128.1	128.3	127.7	128.2	37627495.0
2008-07-23 13:00:00	SPY	ETF	128.2	128.5	127.65	127.9	28428071.0
2008-07-23 14:00:00	SPY	ETF	127.9	128.68	127.83	128.18	39179738.0
2008-07-23 15:00:00	SPY	ETF	128.17	129.06	127.86	128.22	36953859.0
2008-07-23 16:00:00	SPY	ETF	128.25	128.4847	127.6987	128.1	10557915.0
2008-07-23 17:00:00	SPY	ETF	128.1	128.24	128.07	128.22	3636519.0
2008-07-23 18:00:00	SPY	ETF	128.19	128.34	128.17	128.34	36939.0
2008-07-23 19:00:00	SPY	ETF	128.31	128.35	128.2	128.25	24279.0
2008-07-23 04:00:00	QQQ	ETF	44.72	45.13	44.72	45.11	3300.0
2008-07-23 05:00:00	QQQ	ETF	45.03	45.1	45.03	45.05	3000.0
2008-07-23 06:00:00	QQQ	ETF	45.06	45.08	45.02	45.03	5000.0
2008-07-23 07:00:00	QQQ	ETF	45.01	45.04	44.94	45.03	789950.0
2008-07-23 08:00:00	QQQ	ETF	45.02	45.06	44.93	44.94	1607009.0
2008-07-23 09:00:00	QQQ	ETF	44.94	45.07	44.72	45.01	20959082.0
2008-07-23 10:00:00	QQQ	ETF	45.01	45.89	44.94	45.51	46913306.0
2008-07-23 11:00:00	QQQ	ETF	45.51	45.55	45.1305	45.16	17767826.0
2008-07-23 12:00:00	QQQ	ETF	45.1619	45.28	44.84	45.08	16592044.0
2008-07-23 13:00:00	QQQ	ETF	45.08	45.5	44.93	45.03	15463395.0
2008-07-23 14:00:00	QQQ	ETF	45.02	45.35	45.01	45.2299	17681552.0
2008-07-23 15:00:00	QQQ	ETF	45.23	45.41	45.12	45.37	16985218.0
2008-07-23 16:00:00	QQQ	ETF	45.37	45.52	44.78	45.42	9787664.0
2008-07-23 17:00:00	QQQ	ETF	45.43	45.6	45.39	45.54	538390.0
2008-07-23 18:00:00	QQQ	ETF	45.54	45.62	45.53	45.62	209420.0
2008-07-23 19:00:00	QQQ	ETF	45.6	45.68	45.58	45.62	37462.0
2008-07-23 04:00:00	IWM	ETF	71.7	71.77	71.7	71.77	500.0
2008-07-23 07:00:00	IWM	ETF	71.57	71.72	71.52	71.64	232832.0
2008-07-23 08:00:00	IWM	ETF	71.63	71.69	71.49	71.49	642788.0
2008-07-23 09:00:00	IWM	ETF	71.49	71.95	71.18	71.56	10576754.0
2008-07-23 10:00:00	IWM	ETF	71.55	72.49	71.48	71.99	24016429.0
2008-07-23 11:00:00	IWM	ETF	71.99	72.07	71.55	71.64	13768063.0
2008-07-23 12:00:00	IWM	ETF	71.62	71.74	71.21	71.69	14171357.0
2008-07-23 13:00:00	IWM	ETF	71.7	71.87	71.28	71.35	11038512.0
2008-07-23 14:00:00	IWM	ETF	71.36	72.02	71.32	71.73	17021352.0
2008-07-23 15:00:00	IWM	ETF	71.73	71.86	71.48	71.73	20264798.0
2008-07-23 16:00:00	IWM	ETF	71.72	72.06	71.48	71.85	3086267.0
2008-07-23 17:00:00	IWM	ETF	71.81	71.9	71.76	71.9	80324.0
2008-07-23 18:00:00	IWM	ETF	71.88	71.98	71.88	71.98	65300.0
2008-07-23 19:00:00	IWM	ETF	72.03	72.03	72.01	72.02	300.0
2008-07-23 07:00:00	DIA	ETF	116.28	116.33	116.08	116.23	11300.0
2008-07-23 08:00:00	DIA	ETF	116.21	116.34	116.04	116.07	130072.0
2008-07-23 09:00:00	DIA	ETF	116.1	116.13	115.49	115.74	2403518.0
2008-07-23 10:00:00	DIA	ETF	115.72	116.88	115.63	116.28	6174936.0

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

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