PREVIEW / etf_1hour / 2010-11-16

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-11-16.parquet
  size:    180 KB
  rows:    5,489

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-11-16 04:00:00	SPY	ETF	119.64	119.64	119.41	119.46	5950.0
2010-11-16 05:00:00	SPY	ETF	119.49	119.65	119.35	119.41	10200.0
2010-11-16 06:00:00	SPY	ETF	119.39	119.4	119.16	119.18	181550.0
2010-11-16 07:00:00	SPY	ETF	119.18	119.56	119.18	119.4	1029662.0
2010-11-16 08:00:00	SPY	ETF	119.4	119.69	119.21	119.41	4233287.0
2010-11-16 09:00:00	SPY	ETF	119.41	119.55	118.94	119.125	32355280.0
2010-11-16 10:00:00	SPY	ETF	119.13	119.42	118.55	118.73	42209130.0
2010-11-16 11:00:00	SPY	ETF	118.735	118.75	117.75	118.06	52233511.0
2010-11-16 12:00:00	SPY	ETF	118.07	118.25	117.76	118.13	38072876.0
2010-11-16 13:00:00	SPY	ETF	118.13	118.42	117.86	118.33	25688368.0
2010-11-16 14:00:00	SPY	ETF	118.33	118.36	117.7	118.01	26025564.0
2010-11-16 15:00:00	SPY	ETF	118.0101	118.29	117.59	118.15	51684826.0
2010-11-16 16:00:00	SPY	ETF	118.14	120.0823	117.935	118.1	12111657.0
2010-11-16 17:00:00	SPY	ETF	118.1	118.3	118.09	118.29	10443425.0
2010-11-16 18:00:00	SPY	ETF	118.29	118.33	118.22	118.29	529880.0
2010-11-16 19:00:00	SPY	ETF	118.29	118.4	118.27	118.4	170299.0
2010-11-16 04:00:00	QQQ	ETF	52.0	52.0	51.95	52.0	48754.0
2010-11-16 05:00:00	QQQ	ETF	51.99	51.99	51.98	51.98	716.0
2010-11-16 06:00:00	QQQ	ETF	51.85	51.89	51.83	51.87	5650.0
2010-11-16 07:00:00	QQQ	ETF	51.86	51.98	51.86	51.91	287120.0
2010-11-16 08:00:00	QQQ	ETF	51.92	52.07	51.89	51.96	726351.0
2010-11-16 09:00:00	QQQ	ETF	51.95	52.2462	51.87	52.0638	10210372.0
2010-11-16 10:00:00	QQQ	ETF	52.06	52.17	51.77	51.84	16509922.0
2010-11-16 11:00:00	QQQ	ETF	51.8428	51.85	51.31	51.475	19248576.0
2010-11-16 12:00:00	QQQ	ETF	51.4701	51.6	51.39	51.56	9581827.0
2010-11-16 13:00:00	QQQ	ETF	51.56	51.69	51.47	51.6538	7608162.0
2010-11-16 14:00:00	QQQ	ETF	51.66	51.68	50.85	51.5	8320771.0
2010-11-16 15:00:00	QQQ	ETF	51.5	51.545	51.23	51.4499	15925666.0
2010-11-16 16:00:00	QQQ	ETF	51.44	51.53	51.3701	51.51	4312108.0
2010-11-16 17:00:00	QQQ	ETF	51.51	52.3631	51.48	51.62	2082237.0
2010-11-16 18:00:00	QQQ	ETF	51.62	51.62	51.56	51.58	131884.0
2010-11-16 19:00:00	QQQ	ETF	51.59	51.61	51.55	51.59	34750.0
2010-11-16 05:00:00	IWM	ETF	71.68	71.68	71.68	71.68	200.0
2010-11-16 06:00:00	IWM	ETF	71.54	71.61	71.49	71.5	12000.0
2010-11-16 07:00:00	IWM	ETF	71.53	71.71	71.51	71.59	365800.0
2010-11-16 08:00:00	IWM	ETF	71.59	72.07	71.56	71.66	795153.0
2010-11-16 09:00:00	IWM	ETF	71.67	71.73	71.08	71.35	7024821.0
2010-11-16 10:00:00	IWM	ETF	71.3599	71.49	70.87	71.0399	8478050.0
2010-11-16 11:00:00	IWM	ETF	71.04	71.06	70.19	70.51	11779925.0
2010-11-16 12:00:00	IWM	ETF	70.52	70.79	70.33	70.66	6943460.0
2010-11-16 13:00:00	IWM	ETF	70.6657	70.72	70.4599	70.63	4237264.0
2010-11-16 14:00:00	IWM	ETF	70.62	70.67	70.15	70.46	6094388.0
2010-11-16 15:00:00	IWM	ETF	70.44	70.69	70.15	70.64	10803060.0
2010-11-16 16:00:00	IWM	ETF	70.64	70.76	70.2721	70.7	4068302.0
2010-11-16 17:00:00	IWM	ETF	70.69	70.77	70.69	70.77	75070.0
2010-11-16 18:00:00	IWM	ETF	70.63	70.86	70.63	70.82	19907.0
2010-11-16 19:00:00	IWM	ETF	70.86	70.88	70.77	70.78	24500.0
2010-11-16 06:00:00	DIA	ETF	111.51	111.51	111.47	111.47	1000.0
2010-11-16 07:00:00	DIA	ETF	111.59	111.74	111.59	111.68	5400.0
2010-11-16 08:00:00	DIA	ETF	111.65	111.83	111.65	111.73	16888.0

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

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