PREVIEW / etf_1hour / 2010-11-29

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-11-29.parquet
  size:    173 KB
  rows:    5,280

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-29 04:00:00	SPY	ETF	119.55	119.78	119.3	119.46	43425.0
2010-11-29 05:00:00	SPY	ETF	119.35	119.35	118.91	119.07	8200.0
2010-11-29 06:00:00	SPY	ETF	119.03	119.3	118.88	119.21	139300.0
2010-11-29 07:00:00	SPY	ETF	119.22	119.24	118.48	118.71	909876.0
2010-11-29 08:00:00	SPY	ETF	118.72	119.68	118.54	118.55	2790693.0
2010-11-29 09:00:00	SPY	ETF	118.55	118.81	117.85	118.02	29787966.0
2010-11-29 10:00:00	SPY	ETF	118.02	118.5	117.74	118.15	45117536.0
2010-11-29 11:00:00	SPY	ETF	118.15	118.43	117.89	118.08	27577138.0
2010-11-29 12:00:00	SPY	ETF	118.05	118.45	118.03	118.38	20141350.0
2010-11-29 13:00:00	SPY	ETF	118.38	118.39	118.05	118.25	19573898.0
2010-11-29 14:00:00	SPY	ETF	118.25	119.3513	118.22	119.1074	31640809.0
2010-11-29 15:00:00	SPY	ETF	119.11	119.48	119.1	119.17	30629849.0
2010-11-29 16:00:00	SPY	ETF	119.17	119.3513	118.1	119.22	11602236.0
2010-11-29 17:00:00	SPY	ETF	119.23	119.24	119.15	119.21	1153461.0
2010-11-29 18:00:00	SPY	ETF	119.2	119.22	119.1	119.1	85484.0
2010-11-29 19:00:00	SPY	ETF	119.1	119.27	119.07	119.21	115016.0
2010-11-29 04:00:00	QQQ	ETF	52.91	53.08	52.91	52.95	5500.0
2010-11-29 05:00:00	QQQ	ETF	52.83	52.89	52.8	52.8	4300.0
2010-11-29 06:00:00	QQQ	ETF	52.79	52.89	52.74	52.88	5200.0
2010-11-29 07:00:00	QQQ	ETF	52.84	52.84	52.57	52.62	132110.0
2010-11-29 08:00:00	QQQ	ETF	52.65	52.76	52.62	52.71	878146.0
2010-11-29 09:00:00	QQQ	ETF	52.7	52.8	52.19	52.2601	11629438.0
2010-11-29 10:00:00	QQQ	ETF	52.27	52.45	52.1	52.23	11493220.0
2010-11-29 11:00:00	QQQ	ETF	52.24	52.3864	52.13	52.17	8440243.0
2010-11-29 12:00:00	QQQ	ETF	52.17	52.365	52.15	52.3099	5419959.0
2010-11-29 13:00:00	QQQ	ETF	52.31	52.31	52.175	52.2562	4299227.0
2010-11-29 14:00:00	QQQ	ETF	52.25	52.73	52.245	52.71	10941031.0
2010-11-29 15:00:00	QQQ	ETF	52.71	52.9	52.68	52.74	12972812.0
2010-11-29 16:00:00	QQQ	ETF	52.73	52.9655	52.605	52.76	10847066.0
2010-11-29 17:00:00	QQQ	ETF	52.76	52.77	52.73	52.77	33063.0
2010-11-29 18:00:00	QQQ	ETF	52.75	52.76	52.73	52.73	20641.0
2010-11-29 19:00:00	QQQ	ETF	52.74	52.8	52.71	52.8	25556.0
2010-11-29 07:00:00	IWM	ETF	73.24	73.24	72.85	72.97	117753.0
2010-11-29 08:00:00	IWM	ETF	72.98	73.07	72.89	72.89	741181.0
2010-11-29 09:00:00	IWM	ETF	72.88	73.26	72.13	72.31	8944415.0
2010-11-29 10:00:00	IWM	ETF	72.32	72.64	72.03	72.42	7572663.0
2010-11-29 11:00:00	IWM	ETF	72.42	72.72	72.29	72.37	4819623.0
2010-11-29 12:00:00	IWM	ETF	72.38	72.84	72.37	72.73	5258729.0
2010-11-29 13:00:00	IWM	ETF	72.73	72.73	72.47	72.63	2425614.0
2010-11-29 14:00:00	IWM	ETF	72.631	73.26	72.631	73.23	5144915.0
2010-11-29 15:00:00	IWM	ETF	73.22	73.51	73.2	73.31	8506266.0
2010-11-29 16:00:00	IWM	ETF	73.31	73.3702	73.19	73.28	964452.0
2010-11-29 17:00:00	IWM	ETF	73.26	73.28	73.26	73.26	3389.0
2010-11-29 18:00:00	IWM	ETF	73.25	73.25	73.25	73.25	100.0
2010-11-29 19:00:00	IWM	ETF	73.29	73.3	73.27	73.3	1410.0
2010-11-29 04:00:00	DIA	ETF	111.13	111.13	111.13	111.13	100.0
2010-11-29 07:00:00	DIA	ETF	110.6	110.62	110.41	110.5	1135.0
2010-11-29 08:00:00	DIA	ETF	110.54	110.58	110.36	110.36	49943.0
2010-11-29 09:00:00	DIA	ETF	110.34	110.34	109.57	109.69	1550379.0
2010-11-29 10:00:00	DIA	ETF	109.68	109.98	109.4	109.71	1304109.0

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

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