PREVIEW / etf_1hour / 2010-12-06

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-12-06.parquet
  size:    174 KB
  rows:    5,346

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-12-06 04:00:00	SPY	ETF	122.45	122.47	122.33	122.46	19750.0
2010-12-06 05:00:00	SPY	ETF	122.49	122.54	122.19	122.19	16100.0
2010-12-06 06:00:00	SPY	ETF	122.19	122.46	122.19	122.38	59090.0
2010-12-06 07:00:00	SPY	ETF	122.38	122.6	122.38	122.51	200275.0
2010-12-06 08:00:00	SPY	ETF	122.55	122.57	122.25	122.49	1828803.0
2010-12-06 09:00:00	SPY	ETF	122.49	122.86	122.44	122.595	13879109.0
2010-12-06 10:00:00	SPY	ETF	122.6	122.9	122.585	122.68	16645435.0
2010-12-06 11:00:00	SPY	ETF	122.685	122.83	122.51	122.64	14151183.0
2010-12-06 12:00:00	SPY	ETF	122.65	122.73	122.53	122.72	10186523.0
2010-12-06 13:00:00	SPY	ETF	122.72	122.89	122.67	122.84	7829070.0
2010-12-06 14:00:00	SPY	ETF	122.84	122.96	122.77	122.9	8767772.0
2010-12-06 15:00:00	SPY	ETF	122.9	123.04	122.73	122.73	20387194.0
2010-12-06 16:00:00	SPY	ETF	122.74	122.89	122.515	122.62	6143299.0
2010-12-06 17:00:00	SPY	ETF	122.64	122.64	122.4	122.61	755473.0
2010-12-06 18:00:00	SPY	ETF	122.61	122.8	122.48	122.72	618131.0
2010-12-06 19:00:00	SPY	ETF	122.75	122.9	122.72	122.87	215825.0
2010-12-06 04:00:00	QQQ	ETF	53.7	53.7	53.6	53.65	5500.0
2010-12-06 05:00:00	QQQ	ETF	53.68	53.68	53.55	53.55	1000.0
2010-12-06 06:00:00	QQQ	ETF	53.56	53.68	53.55	53.66	10700.0
2010-12-06 07:00:00	QQQ	ETF	53.72	53.75	53.68	53.71	37099.0
2010-12-06 08:00:00	QQQ	ETF	53.72	53.78	53.66	53.76	167410.0
2010-12-06 09:00:00	QQQ	ETF	53.76	53.94	53.72	53.79	7382013.0
2010-12-06 10:00:00	QQQ	ETF	53.8	53.94	53.77	53.8001	6250954.0
2010-12-06 11:00:00	QQQ	ETF	53.81	53.87	53.68	53.755	5563856.0
2010-12-06 12:00:00	QQQ	ETF	53.7575	53.79	53.705	53.769	3161963.0
2010-12-06 13:00:00	QQQ	ETF	53.76	53.86	53.7499	53.8338	2522398.0
2010-12-06 14:00:00	QQQ	ETF	53.8399	53.9	53.78	53.853	2084174.0
2010-12-06 15:00:00	QQQ	ETF	53.85	53.95	53.81	53.855	6726593.0
2010-12-06 16:00:00	QQQ	ETF	53.855	53.895	53.8	53.85	1792172.0
2010-12-06 17:00:00	QQQ	ETF	53.82	53.83	53.65	53.77	175658.0
2010-12-06 18:00:00	QQQ	ETF	53.77	53.91	53.77	53.89	164895.0
2010-12-06 19:00:00	QQQ	ETF	53.89	53.94	53.89	53.93	45397.0
2010-12-06 04:00:00	IWM	ETF	75.26	75.31	75.26	75.31	300.0
2010-12-06 05:00:00	IWM	ETF	75.36	75.36	75.15	75.15	1200.0
2010-12-06 06:00:00	IWM	ETF	75.16	75.36	75.16	75.36	2200.0
2010-12-06 07:00:00	IWM	ETF	75.31	75.46	75.31	75.46	8300.0
2010-12-06 08:00:00	IWM	ETF	75.47	75.48	75.33	75.45	169278.0
2010-12-06 09:00:00	IWM	ETF	75.43	75.78	75.42	75.61	3724057.0
2010-12-06 10:00:00	IWM	ETF	75.6	75.86	75.6	75.78	4609838.0
2010-12-06 11:00:00	IWM	ETF	75.78	75.86	75.7	75.82	5548395.0
2010-12-06 12:00:00	IWM	ETF	75.82	75.92	75.78	75.89	2919150.0
2010-12-06 13:00:00	IWM	ETF	75.9	76.14	75.88	76.07	5242255.0
2010-12-06 14:00:00	IWM	ETF	76.07	76.26	76.02	76.2499	3012331.0
2010-12-06 15:00:00	IWM	ETF	76.24	76.35	76.1	76.139	7606270.0
2010-12-06 16:00:00	IWM	ETF	76.13	76.348	75.7457	76.1	2246665.0
2010-12-06 17:00:00	IWM	ETF	76.08	76.11	75.98	76.11	138590.0
2010-12-06 18:00:00	IWM	ETF	76.11	76.31	76.06	76.2	67186.0
2010-12-06 19:00:00	IWM	ETF	76.26	76.42	76.26	76.37	19100.0
2010-12-06 04:00:00	DIA	ETF	113.66	113.66	113.64	113.64	200.0
2010-12-06 05:00:00	DIA	ETF	113.5	113.5	113.5	113.5	200.0

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

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