PREVIEW / etf_1hour / 2010-10-08

all etf 1-hour files

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

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-08 04:00:00	SPY	ETF	115.98	116.06	115.78	115.78	1000.0
2010-10-08 05:00:00	SPY	ETF	115.8	115.89	115.8	115.81	1700.0
2010-10-08 06:00:00	SPY	ETF	115.71	115.71	115.6	115.6	372470.0
2010-10-08 07:00:00	SPY	ETF	115.6	115.72	115.5	115.62	1806550.0
2010-10-08 08:00:00	SPY	ETF	115.62	116.34	115.02	115.69	10944004.0
2010-10-08 09:00:00	SPY	ETF	115.69	116.21	115.53	116.09	26082874.0
2010-10-08 10:00:00	SPY	ETF	116.09	116.18	115.61	116.0999	27519074.0
2010-10-08 11:00:00	SPY	ETF	116.1	116.62	116.095	116.51	22841353.0
2010-10-08 12:00:00	SPY	ETF	116.5062	116.71	116.35	116.62	11341361.0
2010-10-08 13:00:00	SPY	ETF	116.63	116.65	116.29	116.38	13771428.0
2010-10-08 14:00:00	SPY	ETF	116.39	116.64	116.23	116.46	15645655.0
2010-10-08 15:00:00	SPY	ETF	116.46	116.86	116.45	116.55	32267915.0
2010-10-08 16:00:00	SPY	ETF	116.55	116.7534	115.755	116.56	12663968.0
2010-10-08 17:00:00	SPY	ETF	116.56	116.58	116.42	116.48	535688.0
2010-10-08 18:00:00	SPY	ETF	116.48	116.56	116.46	116.49	101239.0
2010-10-08 19:00:00	SPY	ETF	116.49	116.57	116.49	116.53	32201.0
2010-10-08 05:00:00	QQQ	ETF	49.3	49.3	49.3	49.3	5000.0
2010-10-08 06:00:00	QQQ	ETF	49.32	49.36	49.3	49.36	500.0
2010-10-08 07:00:00	QQQ	ETF	49.31	49.35	49.26	49.32	13628.0
2010-10-08 08:00:00	QQQ	ETF	49.32	49.62	48.74	49.26	5929710.0
2010-10-08 09:00:00	QQQ	ETF	49.25	49.492	49.2	49.4	8955034.0
2010-10-08 10:00:00	QQQ	ETF	49.4001	49.44	49.08	49.32	11134114.0
2010-10-08 11:00:00	QQQ	ETF	49.32	49.77	49.32	49.72	10987587.0
2010-10-08 12:00:00	QQQ	ETF	49.72	49.87	49.59	49.7696	8488943.0
2010-10-08 13:00:00	QQQ	ETF	49.77	49.8	49.6	49.65	4028656.0
2010-10-08 14:00:00	QQQ	ETF	49.655	49.78	49.56	49.72	5642195.0
2010-10-08 15:00:00	QQQ	ETF	49.72	49.87	49.71	49.74	13230705.0
2010-10-08 16:00:00	QQQ	ETF	49.75	49.857	49.145	49.78	4777717.0
2010-10-08 17:00:00	QQQ	ETF	49.76	49.77	49.71	49.74	47580.0
2010-10-08 18:00:00	QQQ	ETF	49.75	49.76	49.73	49.74	13500.0
2010-10-08 19:00:00	QQQ	ETF	49.75	49.76	49.75	49.76	8348.0
2010-10-08 05:00:00	IWM	ETF	68.4	68.4	68.35	68.35	2026.0
2010-10-08 06:00:00	IWM	ETF	68.31	68.31	68.21	68.21	2000.0
2010-10-08 07:00:00	IWM	ETF	68.19	68.28	68.18	68.28	25874.0
2010-10-08 08:00:00	IWM	ETF	68.27	68.7	67.77	68.21	2289535.0
2010-10-08 09:00:00	IWM	ETF	68.18	68.8	68.07	68.66	5117148.0
2010-10-08 10:00:00	IWM	ETF	68.66	68.75	68.145	68.37	9402756.0
2010-10-08 11:00:00	IWM	ETF	68.37	69.0	68.35	68.88	5378683.0
2010-10-08 12:00:00	IWM	ETF	68.89	69.09	68.7	69.01	2347138.0
2010-10-08 13:00:00	IWM	ETF	69.02	69.26	69.0	69.09	5423633.0
2010-10-08 14:00:00	IWM	ETF	69.0977	69.5	68.97	69.36	7847233.0
2010-10-08 15:00:00	IWM	ETF	69.36	69.66	68.6	69.312	12540061.0
2010-10-08 16:00:00	IWM	ETF	69.29	69.5036	68.4263	69.33	2431079.0
2010-10-08 17:00:00	IWM	ETF	69.33	69.34	69.31	69.31	4300.0
2010-10-08 18:00:00	IWM	ETF	69.29	69.43	69.29	69.43	37964.0
2010-10-08 19:00:00	IWM	ETF	69.36	69.36	69.32	69.33	2650.0
2010-10-08 07:00:00	DIA	ETF	109.36	109.39	109.32	109.39	1800.0
2010-10-08 08:00:00	DIA	ETF	109.4	109.86	108.8	109.37	44213.0
2010-10-08 09:00:00	DIA	ETF	109.51	109.95	109.49	109.78	497612.0
2010-10-08 10:00:00	DIA	ETF	109.7736	109.8596	109.3799	109.84	858344.0

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

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