PREVIEW / etf_1hour / 2010-12-17

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-12-17.parquet
  size:    172 KB
  rows:    5,230

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-17 04:00:00	SPY	ETF	124.74	124.74	124.2	124.27	15865.0
2010-12-17 05:00:00	SPY	ETF	124.28	124.28	124.05	124.08	2599.0
2010-12-17 06:00:00	SPY	ETF	124.12	124.17	124.05	124.1	24800.0
2010-12-17 07:00:00	SPY	ETF	124.07	124.23	123.95	124.14	249540.0
2010-12-17 08:00:00	SPY	ETF	124.16	124.22	124.03	124.16	1275192.0
2010-12-17 09:00:00	SPY	ETF	124.16	124.82	123.91	124.025	17872115.0
2010-12-17 10:00:00	SPY	ETF	124.03	124.13	123.82	124.0	22548795.0
2010-12-17 11:00:00	SPY	ETF	124.005	124.15	123.94	124.07	16296230.0
2010-12-17 12:00:00	SPY	ETF	124.08	124.17	124.06	124.15	5999739.0
2010-12-17 13:00:00	SPY	ETF	124.15	124.46	124.15	124.38	13028599.0
2010-12-17 14:00:00	SPY	ETF	124.38	124.455	124.33	124.4	8443459.0
2010-12-17 15:00:00	SPY	ETF	124.4	124.44	124.12	124.34	28345513.0
2010-12-17 16:00:00	SPY	ETF	124.32	124.3893	123.995	124.23	23550376.0
2010-12-17 17:00:00	SPY	ETF	124.23	124.3	123.8	123.8	455687.0
2010-12-17 18:00:00	SPY	ETF	123.9	124.38	123.9	124.14	127245.0
2010-12-17 19:00:00	SPY	ETF	124.17	124.19	124.11	124.17	12515.0
2010-12-17 04:00:00	QQQ	ETF	54.54	54.54	54.33	54.33	10311.0
2010-12-17 05:00:00	QQQ	ETF	54.33	54.43	54.21	54.3	3722.0
2010-12-17 06:00:00	QQQ	ETF	54.25	54.29	54.25	54.29	5165.0
2010-12-17 07:00:00	QQQ	ETF	54.21	54.41	54.21	54.38	420115.0
2010-12-17 08:00:00	QQQ	ETF	54.44	54.51	54.42	54.5	305733.0
2010-12-17 09:00:00	QQQ	ETF	54.5	54.56	54.44	54.5	6032536.0
2010-12-17 10:00:00	QQQ	ETF	54.49	54.55	54.41	54.5001	6704910.0
2010-12-17 11:00:00	QQQ	ETF	54.51	54.61	54.49	54.5699	4535755.0
2010-12-17 12:00:00	QQQ	ETF	54.57	54.6	54.55	54.59	3318995.0
2010-12-17 13:00:00	QQQ	ETF	54.58	54.68	54.58	54.655	2547657.0
2010-12-17 14:00:00	QQQ	ETF	54.655	54.66	54.52	54.61	2131039.0
2010-12-17 15:00:00	QQQ	ETF	54.605	54.6275	54.46	54.51	7546420.0
2010-12-17 16:00:00	QQQ	ETF	54.52	54.52	54.34	54.45	2125395.0
2010-12-17 17:00:00	QQQ	ETF	54.45	54.47	54.4	54.4	20985.0
2010-12-17 18:00:00	QQQ	ETF	54.4	54.48	54.29	54.47	27908.0
2010-12-17 19:00:00	QQQ	ETF	54.47	54.47	54.45	54.46	2814.0
2010-12-17 05:00:00	IWM	ETF	77.66	77.66	77.66	77.66	1000.0
2010-12-17 07:00:00	IWM	ETF	77.67	77.76	77.58	77.76	75560.0
2010-12-17 08:00:00	IWM	ETF	77.75	77.86	77.66	77.8	134820.0
2010-12-17 09:00:00	IWM	ETF	77.84	77.94	77.29	77.53	4982983.0
2010-12-17 10:00:00	IWM	ETF	77.52	77.72	77.32	77.6	5679669.0
2010-12-17 11:00:00	IWM	ETF	77.59	77.83	77.59	77.6959	3102547.0
2010-12-17 12:00:00	IWM	ETF	77.7	77.76	77.65	77.715	2260588.0
2010-12-17 13:00:00	IWM	ETF	77.72	78.17	77.71	78.09	6089828.0
2010-12-17 14:00:00	IWM	ETF	78.09	78.12	77.99	78.07	2859602.0
2010-12-17 15:00:00	IWM	ETF	78.08	78.14	77.85	78.01	11536697.0
2010-12-17 16:00:00	IWM	ETF	78.02	78.0879	77.88	78.05	3179347.0
2010-12-17 17:00:00	IWM	ETF	78.05	78.05	77.98	78.04	4913.0
2010-12-17 18:00:00	IWM	ETF	78.03	78.05	78.0	78.0	650.0
2010-12-17 19:00:00	IWM	ETF	78.0	78.01	78.0	78.01	200.0
2010-12-17 05:00:00	DIA	ETF	114.88	114.88	114.88	114.88	200.0
2010-12-17 07:00:00	DIA	ETF	114.8	114.8	114.8	114.8	500.0
2010-12-17 08:00:00	DIA	ETF	114.91	114.99	114.84	114.95	26500.0
2010-12-17 09:00:00	DIA	ETF	114.95	115.0	114.64	114.72	838072.0

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

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