PREVIEW / etf_1hour / 2010-12-20

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-12-20.parquet
  size:    171 KB
  rows:    5,239

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-20 04:00:00	SPY	ETF	124.19	124.26	124.18	124.19	9500.0
2010-12-20 05:00:00	SPY	ETF	124.19	124.28	124.18	124.28	8900.0
2010-12-20 06:00:00	SPY	ETF	124.35	124.54	124.35	124.54	17250.0
2010-12-20 07:00:00	SPY	ETF	124.55	124.77	124.53	124.64	353108.0
2010-12-20 08:00:00	SPY	ETF	124.65	124.72	124.61	124.63	796221.0
2010-12-20 09:00:00	SPY	ETF	124.63	124.7	124.47	124.53	11402368.0
2010-12-20 10:00:00	SPY	ETF	124.54	124.54	124.07	124.07	21077078.0
2010-12-20 11:00:00	SPY	ETF	124.07	124.36	123.98	124.33	12790504.0
2010-12-20 12:00:00	SPY	ETF	124.32	124.6	124.27	124.6	13248688.0
2010-12-20 13:00:00	SPY	ETF	124.6	124.64	124.57	124.595	6535568.0
2010-12-20 14:00:00	SPY	ETF	124.59	124.9	124.59	124.73	14511772.0
2010-12-20 15:00:00	SPY	ETF	124.7338	124.78	124.53	124.5701	18901827.0
2010-12-20 16:00:00	SPY	ETF	124.57	124.6226	124.015	124.5	9083111.0
2010-12-20 17:00:00	SPY	ETF	124.5	124.6	124.48	124.58	358272.0
2010-12-20 18:00:00	SPY	ETF	124.56	124.6	124.47	124.48	105279.0
2010-12-20 19:00:00	SPY	ETF	124.48	124.49	124.45	124.46	32712.0
2010-12-20 04:00:00	QQQ	ETF	54.39	54.39	54.39	54.39	200.0
2010-12-20 06:00:00	QQQ	ETF	54.51	54.53	54.51	54.53	2200.0
2010-12-20 07:00:00	QQQ	ETF	54.58	54.65	54.56	54.6	81022.0
2010-12-20 08:00:00	QQQ	ETF	54.6	54.63	54.58	54.58	113845.0
2010-12-20 09:00:00	QQQ	ETF	54.58	54.63	54.46	54.48	5240998.0
2010-12-20 10:00:00	QQQ	ETF	54.48	54.48	54.16	54.23	9164320.0
2010-12-20 11:00:00	QQQ	ETF	54.22	54.44	54.175	54.415	5470260.0
2010-12-20 12:00:00	QQQ	ETF	54.41	54.54	54.32	54.54	3941574.0
2010-12-20 13:00:00	QQQ	ETF	54.54	54.62	54.53	54.565	2209995.0
2010-12-20 14:00:00	QQQ	ETF	54.56	54.76	54.56	54.67	5167145.0
2010-12-20 15:00:00	QQQ	ETF	54.6719	54.69	54.54	54.56	6701811.0
2010-12-20 16:00:00	QQQ	ETF	54.56	54.6565	54.51	54.51	896780.0
2010-12-20 17:00:00	QQQ	ETF	54.53	54.54	54.52	54.54	22764.0
2010-12-20 18:00:00	QQQ	ETF	54.52	54.57	54.52	54.52	36190.0
2010-12-20 19:00:00	QQQ	ETF	54.51	54.53	54.51	54.51	12839.0
2010-12-20 05:00:00	IWM	ETF	78.08	78.08	78.08	78.08	300.0
2010-12-20 06:00:00	IWM	ETF	78.17	78.2	78.17	78.2	2673.0
2010-12-20 07:00:00	IWM	ETF	78.25	78.35	78.24	78.33	75500.0
2010-12-20 08:00:00	IWM	ETF	78.31	78.36	78.28	78.3	146911.0
2010-12-20 09:00:00	IWM	ETF	78.3	78.59	78.24	78.41	4560600.0
2010-12-20 10:00:00	IWM	ETF	78.41	78.43	77.93	78.04	6541814.0
2010-12-20 11:00:00	IWM	ETF	78.04	78.36	78.02	78.3392	4335376.0
2010-12-20 12:00:00	IWM	ETF	78.34	78.56	78.27	78.56	3180829.0
2010-12-20 13:00:00	IWM	ETF	78.55	78.57	78.45	78.5	1818578.0
2010-12-20 14:00:00	IWM	ETF	78.495	78.81	78.49	78.592	4941654.0
2010-12-20 15:00:00	IWM	ETF	78.59	78.64	78.31	78.34	6228684.0
2010-12-20 16:00:00	IWM	ETF	78.35	78.5153	78.2	78.24	8134003.0
2010-12-20 17:00:00	IWM	ETF	78.24	78.25	78.21	78.25	2827.0
2010-12-20 18:00:00	IWM	ETF	78.26	78.29	78.26	78.28	3800.0
2010-12-20 19:00:00	IWM	ETF	78.28	78.28	78.25	78.25	3599.0
2010-12-20 07:00:00	DIA	ETF	115.22	115.33	115.22	115.26	12550.0
2010-12-20 08:00:00	DIA	ETF	115.19	115.25	115.17	115.21	6290.0
2010-12-20 09:00:00	DIA	ETF	115.18	115.19	114.93	115.01	624498.0
2010-12-20 10:00:00	DIA	ETF	115.02	115.02	114.49	114.49	1120575.0

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

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