PREVIEW / etf_1hour / 2010-12-01

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-12-01.parquet
  size:    176 KB
  rows:    5,401

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-01 04:00:00	SPY	ETF	119.19	119.39	119.14	119.39	10250.0
2010-12-01 05:00:00	SPY	ETF	119.37	119.62	119.35	119.56	5920.0
2010-12-01 06:00:00	SPY	ETF	119.61	119.93	119.58	119.83	162538.0
2010-12-01 07:00:00	SPY	ETF	119.83	119.99	119.63	119.88	1802685.0
2010-12-01 08:00:00	SPY	ETF	119.85	120.15	119.63	120.13	4580037.0
2010-12-01 09:00:00	SPY	ETF	120.13	120.71	118.49	120.65	31233677.0
2010-12-01 10:00:00	SPY	ETF	120.65	120.8	120.31	120.4801	27925884.0
2010-12-01 11:00:00	SPY	ETF	120.48	121.13	120.41	121.058	23933527.0
2010-12-01 12:00:00	SPY	ETF	121.07	121.24	120.93	121.0	19747806.0
2010-12-01 13:00:00	SPY	ETF	121.0	121.19	120.845	120.98	29565962.0
2010-12-01 14:00:00	SPY	ETF	120.995	121.21	120.87	121.1526	16064392.0
2010-12-01 15:00:00	SPY	ETF	121.16	121.16	120.88	121.01	32831514.0
2010-12-01 16:00:00	SPY	ETF	121.01	121.05	118.49	120.91	18627916.0
2010-12-01 17:00:00	SPY	ETF	120.9	120.98	120.89	120.94	5212316.0
2010-12-01 18:00:00	SPY	ETF	120.95	121.09	120.95	121.09	146243.0
2010-12-01 19:00:00	SPY	ETF	121.09	121.13	120.92	121.1	87353.0
2010-12-01 04:00:00	QQQ	ETF	52.3	52.41	52.3	52.4	2000.0
2010-12-01 05:00:00	QQQ	ETF	52.37	52.52	52.37	52.52	2800.0
2010-12-01 06:00:00	QQQ	ETF	52.55	52.62	52.53	52.62	5988.0
2010-12-01 07:00:00	QQQ	ETF	52.59	52.69	52.5	52.63	439937.0
2010-12-01 08:00:00	QQQ	ETF	52.61	52.83	52.6	52.82	2818605.0
2010-12-01 09:00:00	QQQ	ETF	52.83	53.28	52.77	53.26	14596806.0
2010-12-01 10:00:00	QQQ	ETF	53.25	53.3	53.0899	53.23	10084971.0
2010-12-01 11:00:00	QQQ	ETF	53.23	53.43	53.18	53.4	7999834.0
2010-12-01 12:00:00	QQQ	ETF	53.4	53.46	53.32	53.38	8681228.0
2010-12-01 13:00:00	QQQ	ETF	53.38	53.44	53.27	53.31	6688809.0
2010-12-01 14:00:00	QQQ	ETF	53.31	53.37	53.24	53.33	4946760.0
2010-12-01 15:00:00	QQQ	ETF	53.33	53.34	53.15	53.18	11525905.0
2010-12-01 16:00:00	QQQ	ETF	53.17	53.2501	53.05	53.1	3484574.0
2010-12-01 17:00:00	QQQ	ETF	53.1	53.1927	53.1	53.11	4019583.0
2010-12-01 18:00:00	QQQ	ETF	53.11	53.16	53.11	53.16	12865.0
2010-12-01 19:00:00	QQQ	ETF	53.16	53.19	53.09	53.12	52125.0
2010-12-01 04:00:00	IWM	ETF	73.33	73.33	73.33	73.33	100.0
2010-12-01 06:00:00	IWM	ETF	73.63	73.7	73.63	73.69	5800.0
2010-12-01 07:00:00	IWM	ETF	73.7	73.79	73.58	73.75	239620.0
2010-12-01 08:00:00	IWM	ETF	73.75	74.0	73.54	74.0	2042879.0
2010-12-01 09:00:00	IWM	ETF	74.01	74.36	73.95	74.25	6360281.0
2010-12-01 10:00:00	IWM	ETF	74.25	74.4	74.12	74.32	8237054.0
2010-12-01 11:00:00	IWM	ETF	74.32	74.56	74.26	74.47	5761082.0
2010-12-01 12:00:00	IWM	ETF	74.47	74.57	74.41	74.49	4291452.0
2010-12-01 13:00:00	IWM	ETF	74.49	74.54	74.32	74.4	5341063.0
2010-12-01 14:00:00	IWM	ETF	74.4	74.51	74.33	74.5	4396895.0
2010-12-01 15:00:00	IWM	ETF	74.5	74.5	74.34	74.38	8321534.0
2010-12-01 16:00:00	IWM	ETF	74.38	74.45	74.19	74.34	2063147.0
2010-12-01 17:00:00	IWM	ETF	74.36	74.38	74.33	74.37	6200.0
2010-12-01 18:00:00	IWM	ETF	74.42	74.42	74.42	74.42	100.0
2010-12-01 19:00:00	IWM	ETF	74.37	74.37	74.33	74.33	1800.0
2010-12-01 04:00:00	DIA	ETF	110.87	110.87	110.87	110.87	100.0
2010-12-01 07:00:00	DIA	ETF	111.34	111.47	111.22	111.47	19600.0
2010-12-01 08:00:00	DIA	ETF	111.37	111.64	111.35	111.61	108474.0

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

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