PREVIEW / etf_1hour / 2010-09-22

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-09-22.parquet
  size:    167 KB
  rows:    5,081

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-09-22 04:00:00	SPY	ETF	113.67	113.67	113.48	113.5	8500.0
2010-09-22 05:00:00	SPY	ETF	113.6	113.75	113.55	113.63	3200.0
2010-09-22 06:00:00	SPY	ETF	113.72	113.92	113.65	113.67	75500.0
2010-09-22 07:00:00	SPY	ETF	113.71	113.71	113.47	113.65	521170.0
2010-09-22 08:00:00	SPY	ETF	113.66	113.89	113.51	113.66	4235482.0
2010-09-22 09:00:00	SPY	ETF	113.65	114.44	113.65	114.12	24738803.0
2010-09-22 10:00:00	SPY	ETF	114.12	114.135	113.5	113.75	36841720.0
2010-09-22 11:00:00	SPY	ETF	113.75	113.82	113.12	113.437	26117861.0
2010-09-22 12:00:00	SPY	ETF	113.4379	113.58	113.3	113.32	13418221.0
2010-09-22 13:00:00	SPY	ETF	113.32	113.56	113.1	113.44	15252950.0
2010-09-22 14:00:00	SPY	ETF	113.44	113.73	113.26	113.67	22920860.0
2010-09-22 15:00:00	SPY	ETF	113.67	113.71	113.28	113.43	35495569.0
2010-09-22 16:00:00	SPY	ETF	113.44	114.115	113.1848	113.61	7543667.0
2010-09-22 17:00:00	SPY	ETF	113.6	113.65	113.54	113.63	57899.0
2010-09-22 18:00:00	SPY	ETF	113.63	113.71	113.43	113.63	131417.0
2010-09-22 19:00:00	SPY	ETF	113.63	113.65	113.57	113.62	36552.0
2010-09-22 04:00:00	QQQ	ETF	48.61	48.61	48.61	48.61	366.0
2010-09-22 05:00:00	QQQ	ETF	48.72	48.72	48.72	48.72	23400.0
2010-09-22 06:00:00	QQQ	ETF	48.72	48.77	48.69	48.71	14579.0
2010-09-22 07:00:00	QQQ	ETF	48.64	48.67	48.56	48.62	338965.0
2010-09-22 08:00:00	QQQ	ETF	48.62	48.7	48.53	48.54	2514125.0
2010-09-22 09:00:00	QQQ	ETF	48.54	49.021	48.53	48.84	17584010.0
2010-09-22 10:00:00	QQQ	ETF	48.84	48.84	48.54	48.68	12104616.0
2010-09-22 11:00:00	QQQ	ETF	48.68	48.71	48.44	48.59	6167188.0
2010-09-22 12:00:00	QQQ	ETF	48.59	48.65	48.49	48.5	5983451.0
2010-09-22 13:00:00	QQQ	ETF	48.5	48.61	48.42	48.56	5178124.0
2010-09-22 14:00:00	QQQ	ETF	48.56	48.7	48.48	48.69	5433085.0
2010-09-22 15:00:00	QQQ	ETF	48.69	48.7	48.54	48.67	12562898.0
2010-09-22 16:00:00	QQQ	ETF	48.68	48.75	48.5891	48.75	1613997.0
2010-09-22 17:00:00	QQQ	ETF	48.74	48.77	48.72	48.74	46730.0
2010-09-22 18:00:00	QQQ	ETF	48.75	48.78	48.75	48.76	6900.0
2010-09-22 19:00:00	QQQ	ETF	48.75	48.76	48.71	48.72	8360.0
2010-09-22 06:00:00	IWM	ETF	66.47	66.47	66.31	66.31	5210.0
2010-09-22 07:00:00	IWM	ETF	66.23	66.37	66.18	66.37	12400.0
2010-09-22 08:00:00	IWM	ETF	66.33	67.0	66.22	66.27	1345837.0
2010-09-22 09:00:00	IWM	ETF	66.27	66.9	66.27	66.75	7541786.0
2010-09-22 10:00:00	IWM	ETF	66.76	66.76	65.99	66.19	12638127.0
2010-09-22 11:00:00	IWM	ETF	66.19	66.27	65.61	65.92	6997968.0
2010-09-22 12:00:00	IWM	ETF	65.92	65.99	65.49	65.56	4764102.0
2010-09-22 13:00:00	IWM	ETF	65.56	65.81	65.33	65.7226	4985718.0
2010-09-22 14:00:00	IWM	ETF	65.72	65.9	65.56	65.78	3591785.0
2010-09-22 15:00:00	IWM	ETF	65.78	65.85	65.57	65.81	9686676.0
2010-09-22 16:00:00	IWM	ETF	65.81	66.5857	65.55	66.0	2891700.0
2010-09-22 17:00:00	IWM	ETF	65.84	66.01	65.62	65.99	25955.0
2010-09-22 18:00:00	IWM	ETF	66.0	66.01	65.94	65.94	7100.0
2010-09-22 19:00:00	IWM	ETF	65.92	66.03	65.92	66.0	4650.0
2010-09-22 07:00:00	DIA	ETF	107.42	107.43	107.25	107.43	1750.0
2010-09-22 08:00:00	DIA	ETF	107.4	107.55	107.35	107.41	26900.0
2010-09-22 09:00:00	DIA	ETF	107.45	108.04	107.43	107.82	997012.0
2010-09-22 10:00:00	DIA	ETF	107.82	107.87	107.37	107.64	1661673.0

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

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