PREVIEW / etf_1hour / 2010-08-26

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-08-26.parquet
  size:    162 KB
  rows:    4,975

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
2010-08-26 04:00:00	SPY	ETF	106.25	106.35	106.04	106.19	14300.0
2010-08-26 05:00:00	SPY	ETF	106.13	106.13	106.13	106.13	200.0
2010-08-26 06:00:00	SPY	ETF	106.38	106.41	106.14	106.16	44050.0
2010-08-26 07:00:00	SPY	ETF	106.24	106.24	106.04	106.04	281674.0
2010-08-26 08:00:00	SPY	ETF	106.04	106.74	105.91	106.57	6269532.0
2010-08-26 09:00:00	SPY	ETF	106.57	106.57	105.9	106.2	28955150.0
2010-08-26 10:00:00	SPY	ETF	106.2	106.58	106.17	106.29	33176059.0
2010-08-26 11:00:00	SPY	ETF	106.2918	106.32	105.61	105.99	27622667.0
2010-08-26 12:00:00	SPY	ETF	105.99	106.01	105.57	105.84	17709048.0
2010-08-26 13:00:00	SPY	ETF	105.84	105.89	105.55	105.57	9147633.0
2010-08-26 14:00:00	SPY	ETF	105.56	105.67	104.88	104.99	29691232.0
2010-08-26 15:00:00	SPY	ETF	104.98	105.68	104.96	105.2	52855635.0
2010-08-26 16:00:00	SPY	ETF	105.22	106.32	104.82	104.91	13905221.0
2010-08-26 17:00:00	SPY	ETF	104.94	105.9262	104.75	104.82	1325709.0
2010-08-26 18:00:00	SPY	ETF	104.82	105.23	104.82	104.97	165282.0
2010-08-26 19:00:00	SPY	ETF	104.96	105.0	104.86	104.98	109324.0
2010-08-26 04:00:00	QQQ	ETF	44.17	44.2	44.16	44.17	19300.0
2010-08-26 05:00:00	QQQ	ETF	44.13	44.13	44.13	44.13	1000.0
2010-08-26 06:00:00	QQQ	ETF	44.18	44.18	44.18	44.18	202.0
2010-08-26 07:00:00	QQQ	ETF	44.11	44.12	44.03	44.03	73400.0
2010-08-26 08:00:00	QQQ	ETF	44.04	44.37	43.98	44.3	4057606.0
2010-08-26 09:00:00	QQQ	ETF	44.3	44.33	44.01	44.19	13432181.0
2010-08-26 10:00:00	QQQ	ETF	44.19	44.32	44.0	44.06	12256394.0
2010-08-26 11:00:00	QQQ	ETF	44.06	44.07	43.79	43.97	11586616.0
2010-08-26 12:00:00	QQQ	ETF	43.97	43.98	43.78	43.89	4380465.0
2010-08-26 13:00:00	QQQ	ETF	43.89	43.93	43.75	43.7699	4046986.0
2010-08-26 14:00:00	QQQ	ETF	43.76	43.81	43.5	43.55	8591909.0
2010-08-26 15:00:00	QQQ	ETF	43.54	43.81	43.5	43.54	13430380.0
2010-08-26 16:00:00	QQQ	ETF	43.55	44.0673	43.4	43.46	5779752.0
2010-08-26 17:00:00	QQQ	ETF	43.46	43.47	43.37	43.42	22335.0
2010-08-26 18:00:00	QQQ	ETF	43.43	43.45	43.43	43.43	19227.0
2010-08-26 19:00:00	QQQ	ETF	43.43	43.46	43.42	43.46	20432.0
2010-08-26 06:00:00	IWM	ETF	60.76	60.76	60.7	60.7	1700.0
2010-08-26 07:00:00	IWM	ETF	60.53	60.65	60.48	60.48	27797.0
2010-08-26 08:00:00	IWM	ETF	60.5	61.08	60.36	60.95	1708020.0
2010-08-26 09:00:00	IWM	ETF	60.93	61.16	60.64	61.03	11749646.0
2010-08-26 10:00:00	IWM	ETF	61.01	61.28	60.8	60.891	10067344.0
2010-08-26 11:00:00	IWM	ETF	60.91	60.93	60.43	60.75	9447108.0
2010-08-26 12:00:00	IWM	ETF	60.75	60.81	60.51	60.67	3983158.0
2010-08-26 13:00:00	IWM	ETF	60.67	60.73	60.39	60.42	4105069.0
2010-08-26 14:00:00	IWM	ETF	60.42	60.48	59.88	59.99	6639326.0
2010-08-26 15:00:00	IWM	ETF	60.0	60.7975	59.86	60.08	12279399.0
2010-08-26 16:00:00	IWM	ETF	60.09	60.543	59.97	60.03	5564984.0
2010-08-26 17:00:00	IWM	ETF	60.0	60.02	59.89	59.91	41528.0
2010-08-26 18:00:00	IWM	ETF	59.91	59.94	59.89	59.9	7759.0
2010-08-26 19:00:00	IWM	ETF	59.96	59.96	59.86	59.9	2000.0
2010-08-26 07:00:00	DIA	ETF	100.64	100.81	100.64	100.81	13400.0
2010-08-26 08:00:00	DIA	ETF	100.64	101.26	100.58	101.05	26783.0
2010-08-26 09:00:00	DIA	ETF	101.08	101.08	100.44	100.7	1023711.0
2010-08-26 10:00:00	DIA	ETF	100.69	101.06	100.67	100.8	1034134.0

> showing 50 of 4,975 rows — these rows as CSV

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