PREVIEW / etf_1hour / 2010-01-19

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-01-19.parquet
  size:    153 KB
  rows:    4,806

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-19 04:00:00	SPY	ETF	113.69	113.69	113.49	113.52	5534.0
2010-01-19 05:00:00	SPY	ETF	113.64	113.66	113.55	113.55	17290.0
2010-01-19 06:00:00	SPY	ETF	113.55	113.57	113.35	113.36	23825.0
2010-01-19 07:00:00	SPY	ETF	113.54	113.54	113.36	113.38	410817.0
2010-01-19 08:00:00	SPY	ETF	113.38	113.72	113.08	113.52	5672939.0
2010-01-19 09:00:00	SPY	ETF	113.52	114.33	113.5	114.2	24868900.0
2010-01-19 10:00:00	SPY	ETF	114.2	114.72	114.0	114.61	25555722.0
2010-01-19 11:00:00	SPY	ETF	114.61	114.62	114.48	114.53	13135838.0
2010-01-19 12:00:00	SPY	ETF	114.53	114.95	114.52	114.84	12195597.0
2010-01-19 13:00:00	SPY	ETF	114.84	114.9	114.74	114.86	8218364.0
2010-01-19 14:00:00	SPY	ETF	114.86	114.94	114.8	114.859	11635396.0
2010-01-19 15:00:00	SPY	ETF	114.86	115.13	114.76	115.06	25575003.0
2010-01-19 16:00:00	SPY	ETF	115.07	115.1088	113.677	114.88	7632364.0
2010-01-19 17:00:00	SPY	ETF	114.89	114.95	114.86	114.88	140828.0
2010-01-19 18:00:00	SPY	ETF	114.89	114.92	114.83	114.88	205585.0
2010-01-19 19:00:00	SPY	ETF	114.88	115.14	114.85	115.1	292660.0
2010-01-19 20:00:00	SPY	ETF	115.13	115.13	115.13	115.13	2500.0
2010-01-19 04:00:00	QQQ	ETF	45.98	46.0	45.85	45.88	6083.0
2010-01-19 05:00:00	QQQ	ETF	45.92	45.94	45.9	45.9	21600.0
2010-01-19 06:00:00	QQQ	ETF	45.89	45.9	45.81	45.82	25100.0
2010-01-19 07:00:00	QQQ	ETF	45.83	45.87	45.81	45.82	134407.0
2010-01-19 08:00:00	QQQ	ETF	45.8	46.02	45.71	45.91	1807557.0
2010-01-19 09:00:00	QQQ	ETF	45.9	46.32	45.9	46.25	14718406.0
2010-01-19 10:00:00	QQQ	ETF	46.25	46.5	46.245	46.4599	18783734.0
2010-01-19 11:00:00	QQQ	ETF	46.45	46.48	46.38	46.41	6054816.0
2010-01-19 12:00:00	QQQ	ETF	46.41	46.6196	46.41	46.57	6698995.0
2010-01-19 13:00:00	QQQ	ETF	46.56	46.59	46.52	46.56	4264798.0
2010-01-19 14:00:00	QQQ	ETF	46.558	46.6	46.535	46.58	4166914.0
2010-01-19 15:00:00	QQQ	ETF	46.5701	46.64	46.4876	46.58	13884131.0
2010-01-19 16:00:00	QQQ	ETF	46.58	46.6025	45.843	46.45	9170244.0
2010-01-19 17:00:00	QQQ	ETF	46.44	46.51	46.44	46.48	234100.0
2010-01-19 18:00:00	QQQ	ETF	46.48	46.49	46.45	46.48	92675.0
2010-01-19 19:00:00	QQQ	ETF	46.48	46.56	46.47	46.55	92022.0
2010-01-19 04:00:00	IWM	ETF	63.88	63.88	63.88	63.88	200.0
2010-01-19 07:00:00	IWM	ETF	64.01	64.01	63.8	63.8	79551.0
2010-01-19 08:00:00	IWM	ETF	63.8	64.27	63.7	63.88	567485.0
2010-01-19 09:00:00	IWM	ETF	63.88	64.54	63.86	64.34	9200561.0
2010-01-19 10:00:00	IWM	ETF	64.35	64.67	64.33	64.63	8346791.0
2010-01-19 11:00:00	IWM	ETF	64.62	64.64	64.32	64.36	4080913.0
2010-01-19 12:00:00	IWM	ETF	64.36	64.65	64.35	64.6	2985449.0
2010-01-19 13:00:00	IWM	ETF	64.6	64.66	64.5	64.65	2882405.0
2010-01-19 14:00:00	IWM	ETF	64.66	64.83	64.6	64.71	3555259.0
2010-01-19 15:00:00	IWM	ETF	64.71	64.87	64.55	64.83	8723903.0
2010-01-19 16:00:00	IWM	ETF	64.83	64.95	64.6	64.7	2428106.0
2010-01-19 17:00:00	IWM	ETF	64.71	64.75	63.772	64.73	1033055.0
2010-01-19 18:00:00	IWM	ETF	64.77	64.8	64.72	64.75	1123.0
2010-01-19 19:00:00	IWM	ETF	64.79	64.92	64.79	64.86	3600.0
2010-01-19 08:00:00	DIA	ETF	105.8	106.02	105.62	105.87	9446.0
2010-01-19 09:00:00	DIA	ETF	105.84	106.57	105.84	106.45	2011414.0
2010-01-19 10:00:00	DIA	ETF	106.46	106.89	106.41	106.7863	2417799.0

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

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