PREVIEW / etf_1hour / 2010-01-15

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-01-15.parquet
  size:    150 KB
  rows:    4,719

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-01-15 04:00:00	SPY	ETF	114.98	114.98	114.98	114.98	300.0
2010-01-15 05:00:00	SPY	ETF	114.75	114.8	114.75	114.8	4000.0
2010-01-15 06:00:00	SPY	ETF	114.66	114.82	114.65	114.75	46900.0
2010-01-15 07:00:00	SPY	ETF	114.6	114.66	114.21	114.4	2637684.0
2010-01-15 08:00:00	SPY	ETF	114.38	114.68	114.32	114.52	2756086.0
2010-01-15 09:00:00	SPY	ETF	114.5	114.84	114.1	114.21	26643807.0
2010-01-15 10:00:00	SPY	ETF	114.21	114.23	113.57	113.76	43843605.0
2010-01-15 11:00:00	SPY	ETF	113.76	113.92	113.49	113.54	23920952.0
2010-01-15 12:00:00	SPY	ETF	113.53	113.69	113.2	113.37	27850348.0
2010-01-15 13:00:00	SPY	ETF	113.37	113.52	113.29	113.45	14937987.0
2010-01-15 14:00:00	SPY	ETF	113.45	113.53	113.3	113.39	18266281.0
2010-01-15 15:00:00	SPY	ETF	113.39	113.78	113.39	113.66	37099054.0
2010-01-15 16:00:00	SPY	ETF	113.66	114.9202	113.37	113.51	13113719.0
2010-01-15 17:00:00	SPY	ETF	113.5	113.61	113.49	113.56	405736.0
2010-01-15 18:00:00	SPY	ETF	113.56	113.57	113.53	113.54	14616.0
2010-01-15 19:00:00	SPY	ETF	113.56	113.56	113.5	113.55	15712.0
2010-01-15 04:00:00	QQQ	ETF	46.45	46.47	46.45	46.45	1100.0
2010-01-15 05:00:00	QQQ	ETF	46.41	46.41	46.41	46.41	200.0
2010-01-15 06:00:00	QQQ	ETF	46.35	46.38	46.31	46.31	21960.0
2010-01-15 07:00:00	QQQ	ETF	46.3	46.3	46.18	46.25	765379.0
2010-01-15 08:00:00	QQQ	ETF	46.28	46.41	46.26	46.36	673823.0
2010-01-15 09:00:00	QQQ	ETF	46.36	46.55	46.14	46.21	23609144.0
2010-01-15 10:00:00	QQQ	ETF	46.21	46.23	45.94	46.07	24172188.0
2010-01-15 11:00:00	QQQ	ETF	46.07	46.08	45.82	45.86	10822779.0
2010-01-15 12:00:00	QQQ	ETF	45.85	45.93	45.65	45.77	12379395.0
2010-01-15 13:00:00	QQQ	ETF	45.76	45.82	45.68	45.7801	8065970.0
2010-01-15 14:00:00	QQQ	ETF	45.79	45.85	45.75	45.81	9211717.0
2010-01-15 15:00:00	QQQ	ETF	45.805	45.95	45.8	45.869	18017268.0
2010-01-15 16:00:00	QQQ	ETF	45.869	46.4	45.7708	45.8	14028114.0
2010-01-15 17:00:00	QQQ	ETF	45.79	45.82	45.78	45.79	129525.0
2010-01-15 18:00:00	QQQ	ETF	45.79	45.82	45.79	45.8	11250.0
2010-01-15 19:00:00	QQQ	ETF	45.8	45.82	45.79	45.81	8369.0
2010-01-15 06:00:00	IWM	ETF	64.56	64.64	64.56	64.64	8000.0
2010-01-15 07:00:00	IWM	ETF	64.48	64.48	64.25	64.29	126106.0
2010-01-15 08:00:00	IWM	ETF	64.46	64.55	64.33	64.47	329778.0
2010-01-15 09:00:00	IWM	ETF	64.46	64.8001	63.91	64.02	9758130.0
2010-01-15 10:00:00	IWM	ETF	64.02	64.02	63.48	63.74	16157211.0
2010-01-15 11:00:00	IWM	ETF	63.74	63.75	63.358	63.4	6604071.0
2010-01-15 12:00:00	IWM	ETF	63.4	63.58	63.27	63.4304	5930086.0
2010-01-15 13:00:00	IWM	ETF	63.4304	63.58	63.36	63.525	3538773.0
2010-01-15 14:00:00	IWM	ETF	63.53	63.58	63.37	63.48	3294785.0
2010-01-15 15:00:00	IWM	ETF	63.48	63.85	63.48	63.69	12894504.0
2010-01-15 16:00:00	IWM	ETF	63.69	64.617	63.4812	63.75	3148267.0
2010-01-15 17:00:00	IWM	ETF	63.76	63.77	63.7	63.71	29596.0
2010-01-15 18:00:00	IWM	ETF	63.71	63.71	63.65	63.65	2312.0
2010-01-15 19:00:00	IWM	ETF	63.66	63.71	63.66	63.71	1700.0
2010-01-15 07:00:00	DIA	ETF	106.7	106.95	106.6	106.65	2300.0
2010-01-15 08:00:00	DIA	ETF	106.75	106.87	106.73	106.77	4373.0
2010-01-15 09:00:00	DIA	ETF	106.77	106.98	106.325	106.44	3652319.0
2010-01-15 10:00:00	DIA	ETF	106.44	106.55	105.85	105.98	3127411.0

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

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