PREVIEW / etf_1hour / 2008-09-12

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-09-12.parquet
  size:    109 KB
  rows:    3,513

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-09-12 04:00:00	SPY	ETF	125.48	125.48	125.48	125.48	100.0
2008-09-12 05:00:00	SPY	ETF	125.74	125.74	125.55	125.61	2400.0
2008-09-12 06:00:00	SPY	ETF	125.48	125.48	125.12	125.46	73000.0
2008-09-12 07:00:00	SPY	ETF	125.51	125.51	124.97	125.02	799090.0
2008-09-12 08:00:00	SPY	ETF	125.02	125.71	124.47	124.53	6596524.0
2008-09-12 09:00:00	SPY	ETF	124.53	125.2	123.83	124.18	41289726.0
2008-09-12 10:00:00	SPY	ETF	124.18	125.1	123.97	125.05	43781808.0
2008-09-12 11:00:00	SPY	ETF	125.06	125.98	124.91	125.36	42492282.0
2008-09-12 12:00:00	SPY	ETF	125.37	125.64	124.58	124.61	26783904.0
2008-09-12 13:00:00	SPY	ETF	124.6	125.43	124.45	125.4299	33977636.0
2008-09-12 14:00:00	SPY	ETF	125.42	125.95	124.79	125.85	30800303.0
2008-09-12 15:00:00	SPY	ETF	125.85	125.98	124.97	125.75	46846129.0
2008-09-12 16:00:00	SPY	ETF	125.76	126.26	125.387	126.25	14884462.0
2008-09-12 17:00:00	SPY	ETF	126.27	126.27	125.4	125.51	5023371.0
2008-09-12 18:00:00	SPY	ETF	125.51	125.85	125.39	125.75	208009.0
2008-09-12 19:00:00	SPY	ETF	125.77	125.95	125.7	125.92	81834.0
2008-09-12 06:00:00	QQQ	ETF	43.6	43.6	43.52	43.52	1000.0
2008-09-12 07:00:00	QQQ	ETF	43.56	43.71	43.56	43.62	1383381.0
2008-09-12 08:00:00	QQQ	ETF	43.61	43.67	43.32	43.35	2076786.0
2008-09-12 09:00:00	QQQ	ETF	43.34	43.36	42.91	42.97	32403323.0
2008-09-12 10:00:00	QQQ	ETF	42.97	43.27	42.9	43.12	28840965.0
2008-09-12 11:00:00	QQQ	ETF	43.13	43.71	43.05	43.42	32095124.0
2008-09-12 12:00:00	QQQ	ETF	43.42	43.52	43.06	43.11	14900207.0
2008-09-12 13:00:00	QQQ	ETF	43.1	43.38	43.02	43.35	14208903.0
2008-09-12 14:00:00	QQQ	ETF	43.36	43.6112	43.14	43.59	16214369.0
2008-09-12 15:00:00	QQQ	ETF	43.59	43.65	43.3	43.51	22758649.0
2008-09-12 16:00:00	QQQ	ETF	43.51	43.67	43.2837	43.61	5908536.0
2008-09-12 17:00:00	QQQ	ETF	43.64	43.67	43.49	43.52	36685.0
2008-09-12 18:00:00	QQQ	ETF	43.52	43.56	43.42	43.49	26450.0
2008-09-12 19:00:00	QQQ	ETF	43.49	43.55	43.47	43.52	13998.0
2008-09-12 07:00:00	IWM	ETF	72.15	72.15	71.92	71.92	67982.0
2008-09-12 08:00:00	IWM	ETF	71.92	71.92	71.46	71.53	1045571.0
2008-09-12 09:00:00	IWM	ETF	71.52	71.55	71.04	71.24	12689199.0
2008-09-12 10:00:00	IWM	ETF	71.25	71.85	71.11	71.84	21110532.0
2008-09-12 11:00:00	IWM	ETF	71.85	72.39	71.53	71.76	20002365.0
2008-09-12 12:00:00	IWM	ETF	71.76	72.06	71.5	71.54	11509867.0
2008-09-12 13:00:00	IWM	ETF	71.55	71.81	71.41	71.75	9641871.0
2008-09-12 14:00:00	IWM	ETF	71.74	72.21	71.37	72.08	13439966.0
2008-09-12 15:00:00	IWM	ETF	72.08	72.11	71.65	71.91	20090985.0
2008-09-12 16:00:00	IWM	ETF	71.94	72.51	71.75	72.38	3893524.0
2008-09-12 17:00:00	IWM	ETF	72.27	72.35	72.25	72.3	15220.0
2008-09-12 18:00:00	IWM	ETF	72.26	72.4	72.25	72.4	2500.0
2008-09-12 19:00:00	IWM	ETF	72.33	72.33	72.25	72.25	1600.0
2008-09-12 06:00:00	DIA	ETF	114.48	114.61	114.48	114.61	600.0
2008-09-12 07:00:00	DIA	ETF	114.59	114.59	114.35	114.35	9193.0
2008-09-12 08:00:00	DIA	ETF	114.32	114.36	113.76	113.76	146877.0
2008-09-12 09:00:00	DIA	ETF	113.79	113.85	113.01	113.25	2963583.0
2008-09-12 10:00:00	DIA	ETF	113.26	114.01	113.08	113.94	5694643.0
2008-09-12 11:00:00	DIA	ETF	113.94	114.84	113.9	114.3	3796279.0
2008-09-12 12:00:00	DIA	ETF	114.31	114.51	113.51	113.53	2389683.0

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

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