PREVIEW / etf_1hour / 2010-10-06

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-10-06.parquet
  size:    167 KB
  rows:    5,173

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-10-06 04:00:00	SPY	ETF	116.2	116.34	116.2	116.32	1888.0
2010-10-06 05:00:00	SPY	ETF	116.4	116.6	116.37	116.37	2951.0
2010-10-06 06:00:00	SPY	ETF	116.43	116.45	116.18	116.23	49400.0
2010-10-06 07:00:00	SPY	ETF	116.23	116.39	116.02	116.39	479975.0
2010-10-06 08:00:00	SPY	ETF	116.39	116.45	115.78	115.92	4008274.0
2010-10-06 09:00:00	SPY	ETF	115.91	116.29	115.91	116.14	24913446.0
2010-10-06 10:00:00	SPY	ETF	116.14	116.33	115.88	116.03	24941665.0
2010-10-06 11:00:00	SPY	ETF	116.03	116.26	115.86	116.13	17382218.0
2010-10-06 12:00:00	SPY	ETF	116.135	116.22	115.76	115.82	13569031.0
2010-10-06 13:00:00	SPY	ETF	115.82	116.04	115.56	115.83	13737230.0
2010-10-06 14:00:00	SPY	ETF	115.84	115.94	115.6238	115.88	16973781.0
2010-10-06 15:00:00	SPY	ETF	115.885	116.05	115.69	116.04	22326447.0
2010-10-06 16:00:00	SPY	ETF	116.04	116.255	115.97	116.12	4778174.0
2010-10-06 17:00:00	SPY	ETF	116.11	116.13	115.89	115.97	147790.0
2010-10-06 18:00:00	SPY	ETF	115.96	116.06	115.93	115.93	91248.0
2010-10-06 19:00:00	SPY	ETF	115.97	116.01	115.93	115.98	26221.0
2010-10-06 04:00:00	QQQ	ETF	49.7	49.73	49.7	49.73	400.0
2010-10-06 05:00:00	QQQ	ETF	49.73	49.73	49.73	49.73	200.0
2010-10-06 06:00:00	QQQ	ETF	49.76	49.76	49.68	49.68	16200.0
2010-10-06 07:00:00	QQQ	ETF	49.7	49.73	49.59	49.73	46346.0
2010-10-06 08:00:00	QQQ	ETF	49.73	49.75	49.49	49.54	772985.0
2010-10-06 09:00:00	QQQ	ETF	49.54	49.71	49.48	49.53	8668140.0
2010-10-06 10:00:00	QQQ	ETF	49.54	49.67	49.18	49.28	12205675.0
2010-10-06 11:00:00	QQQ	ETF	49.285	49.46	49.19	49.34	6833775.0
2010-10-06 12:00:00	QQQ	ETF	49.33	49.41	49.12	49.15	6380760.0
2010-10-06 13:00:00	QQQ	ETF	49.15	49.15	48.91	49.125	14389898.0
2010-10-06 14:00:00	QQQ	ETF	49.13	49.21	48.98	49.15	9729296.0
2010-10-06 15:00:00	QQQ	ETF	49.14	49.26	49.02	49.2487	10403237.0
2010-10-06 16:00:00	QQQ	ETF	49.24	49.32	49.1604	49.32	2261558.0
2010-10-06 17:00:00	QQQ	ETF	49.32	49.33	49.25	49.26	234519.0
2010-10-06 18:00:00	QQQ	ETF	49.27	49.3	49.27	49.28	121950.0
2010-10-06 19:00:00	QQQ	ETF	49.31	49.32	49.24	49.26	18166.0
2010-10-06 05:00:00	IWM	ETF	69.11	69.11	69.11	69.11	300.0
2010-10-06 06:00:00	IWM	ETF	69.17	69.18	69.01	69.01	3700.0
2010-10-06 07:00:00	IWM	ETF	68.96	69.15	68.83	69.15	28410.0
2010-10-06 08:00:00	IWM	ETF	69.1	69.15	68.72	68.77	331590.0
2010-10-06 09:00:00	IWM	ETF	68.77	69.06	68.71	68.8	5519377.0
2010-10-06 10:00:00	IWM	ETF	68.79	69.0	68.64	68.75	8137964.0
2010-10-06 11:00:00	IWM	ETF	68.75	69.0	68.63	68.82	4138402.0
2010-10-06 12:00:00	IWM	ETF	68.81	68.89	68.54	68.63	2874929.0
2010-10-06 13:00:00	IWM	ETF	68.62	68.62	68.26	68.46	5227908.0
2010-10-06 14:00:00	IWM	ETF	68.46	68.53	68.3	68.44	3813334.0
2010-10-06 15:00:00	IWM	ETF	68.44	68.63	68.22	68.6	8750805.0
2010-10-06 16:00:00	IWM	ETF	68.59	68.74	68.3198	68.72	687870.0
2010-10-06 17:00:00	IWM	ETF	68.7	68.7	68.6	68.65	41100.0
2010-10-06 18:00:00	IWM	ETF	68.6	68.6	68.53	68.59	13027.0
2010-10-06 19:00:00	IWM	ETF	68.55	68.57	68.55	68.57	5050.0
2010-10-06 05:00:00	DIA	ETF	109.75	109.79	109.75	109.79	1600.0
2010-10-06 07:00:00	DIA	ETF	109.58	109.69	109.45	109.69	13200.0
2010-10-06 08:00:00	DIA	ETF	109.72	109.78	109.26	109.32	35240.0

> showing 50 of 5,173 rows — these rows as CSV

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