PREVIEW / etf_1hour / 2008-08-07

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-08-07.parquet
  size:    108 KB
  rows:    3,477

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-08-07 04:00:00	SPY	ETF	128.75	128.86	128.75	128.86	600.0
2008-08-07 05:00:00	SPY	ETF	128.77	128.77	128.76	128.76	5000.0
2008-08-07 06:00:00	SPY	ETF	128.64	128.83	128.54	128.56	158500.0
2008-08-07 07:00:00	SPY	ETF	128.55	128.73	128.24	128.41	1347881.0
2008-08-07 08:00:00	SPY	ETF	128.41	128.51	127.89	128.1	8007903.0
2008-08-07 09:00:00	SPY	ETF	128.07	128.93	127.33	127.92	28143214.0
2008-08-07 10:00:00	SPY	ETF	127.91	128.41	127.84	128.21	39242363.0
2008-08-07 11:00:00	SPY	ETF	128.21	129.0549	127.58	127.88	21123905.0
2008-08-07 12:00:00	SPY	ETF	127.89	128.44	127.72	128.31	21870469.0
2008-08-07 13:00:00	SPY	ETF	128.311	128.39	127.96	127.97	21065129.0
2008-08-07 14:00:00	SPY	ETF	127.98	128.11	127.43	127.43	28911721.0
2008-08-07 15:00:00	SPY	ETF	127.44	128.12	126.54	126.88	59889815.0
2008-08-07 16:00:00	SPY	ETF	126.91	129.055	126.79	127.05	10724353.0
2008-08-07 17:00:00	SPY	ETF	127.05	127.09	127.02	127.05	83728.0
2008-08-07 18:00:00	SPY	ETF	127.03	127.03	126.97	126.98	95230.0
2008-08-07 19:00:00	SPY	ETF	127.01	127.01	126.94	126.95	25787.0
2008-08-07 06:00:00	QQQ	ETF	46.54	46.54	46.54	46.54	200.0
2008-08-07 07:00:00	QQQ	ETF	46.54	46.54	46.42	46.49	78380.0
2008-08-07 08:00:00	QQQ	ETF	46.48	46.48	46.25	46.3	4073889.0
2008-08-07 09:00:00	QQQ	ETF	46.3	46.44	46.08	46.41	22415735.0
2008-08-07 10:00:00	QQQ	ETF	46.4	46.59	46.32	46.51	22186261.0
2008-08-07 11:00:00	QQQ	ETF	46.52	46.64	46.38	46.538	11274680.0
2008-08-07 12:00:00	QQQ	ETF	46.53	46.85	46.45	46.8	14421397.0
2008-08-07 13:00:00	QQQ	ETF	46.81	46.82	46.57	46.57	11942483.0
2008-08-07 14:00:00	QQQ	ETF	46.58	46.71	46.33	46.35	17594453.0
2008-08-07 15:00:00	QQQ	ETF	46.35	46.41	46.12	46.27	32866641.0
2008-08-07 16:00:00	QQQ	ETF	46.26	46.6168	46.2245	46.4	13357979.0
2008-08-07 17:00:00	QQQ	ETF	46.4	46.4	46.34	46.39	172091.0
2008-08-07 18:00:00	QQQ	ETF	46.37	46.39	46.36	46.36	36919.0
2008-08-07 19:00:00	QQQ	ETF	46.39	46.39	46.27	46.38	40549.0
2008-08-07 06:00:00	IWM	ETF	72.21	72.21	72.21	72.21	3000.0
2008-08-07 07:00:00	IWM	ETF	72.22	72.22	72.05	72.06	90047.0
2008-08-07 08:00:00	IWM	ETF	72.09	72.12	71.72	71.74	1342390.0
2008-08-07 09:00:00	IWM	ETF	71.75	71.91	71.43	71.7	11956432.0
2008-08-07 10:00:00	IWM	ETF	71.72	72.14	71.6	72.04	14440557.0
2008-08-07 11:00:00	IWM	ETF	72.04	72.09	71.69	71.8	7604231.0
2008-08-07 12:00:00	IWM	ETF	71.81	72.34	71.72	72.21	9007816.0
2008-08-07 13:00:00	IWM	ETF	72.22	72.27	71.98	71.99	5927021.0
2008-08-07 14:00:00	IWM	ETF	71.99	72.04	71.58	71.59	8722422.0
2008-08-07 15:00:00	IWM	ETF	71.59	71.67	70.97	71.24	20278472.0
2008-08-07 16:00:00	IWM	ETF	71.26	71.71	71.17	71.49	8172535.0
2008-08-07 17:00:00	IWM	ETF	71.5	71.5	71.44	71.5	1737.0
2008-08-07 18:00:00	IWM	ETF	71.44	71.44	71.39	71.39	1732.0
2008-08-07 19:00:00	IWM	ETF	71.41	71.41	71.41	71.41	4000.0
2008-08-07 06:00:00	DIA	ETF	116.22	116.26	116.08	116.08	600.0
2008-08-07 07:00:00	DIA	ETF	115.98	115.98	115.83	115.9	23393.0
2008-08-07 08:00:00	DIA	ETF	115.89	115.89	115.47	115.58	168661.0
2008-08-07 09:00:00	DIA	ETF	115.6	115.61	114.92	115.28	2351394.0
2008-08-07 10:00:00	DIA	ETF	115.29	115.9	115.24	115.63	2936272.0
2008-08-07 11:00:00	DIA	ETF	115.63	115.74	115.23	115.28	1546873.0

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

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