PREVIEW / etf_1hour / 2010-08-18

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-08-18.parquet
  size:    160 KB
  rows:    4,907

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-08-18 04:00:00	SPY	ETF	109.15	109.26	109.08	109.08	14350.0
2010-08-18 05:00:00	SPY	ETF	109.41	109.51	109.39	109.49	10600.0
2010-08-18 06:00:00	SPY	ETF	109.48	109.48	109.3	109.36	11200.0
2010-08-18 07:00:00	SPY	ETF	109.32	109.62	109.29	109.48	174547.0
2010-08-18 08:00:00	SPY	ETF	109.49	109.82	109.24	109.78	928571.0
2010-08-18 09:00:00	SPY	ETF	109.77	109.82	108.91	109.21	26078901.0
2010-08-18 10:00:00	SPY	ETF	109.22	109.51	108.99	109.26	27676568.0
2010-08-18 11:00:00	SPY	ETF	109.27	109.74	109.19	109.62	23597007.0
2010-08-18 12:00:00	SPY	ETF	109.62	110.01	109.5	109.95	14247598.0
2010-08-18 13:00:00	SPY	ETF	109.95	110.33	109.94	110.28	16471164.0
2010-08-18 14:00:00	SPY	ETF	110.28	110.38	110.06	110.13	15889546.0
2010-08-18 15:00:00	SPY	ETF	110.13	110.21	109.78	109.78	39417995.0
2010-08-18 16:00:00	SPY	ETF	109.78	110.0757	108.985	109.37	11378563.0
2010-08-18 17:00:00	SPY	ETF	109.37	109.38	109.25	109.32	307881.0
2010-08-18 18:00:00	SPY	ETF	109.31	109.31	109.19	109.28	303809.0
2010-08-18 19:00:00	SPY	ETF	109.29	109.31	109.11	109.19	99221.0
2010-08-18 04:00:00	QQQ	ETF	45.35	45.35	45.11	45.12	1073.0
2010-08-18 05:00:00	QQQ	ETF	45.2	45.24	45.2	45.24	300.0
2010-08-18 06:00:00	QQQ	ETF	45.19	45.21	45.18	45.21	1056.0
2010-08-18 07:00:00	QQQ	ETF	45.19	45.3	45.16	45.25	73440.0
2010-08-18 08:00:00	QQQ	ETF	45.25	45.39	45.24	45.37	509051.0
2010-08-18 09:00:00	QQQ	ETF	45.37	45.39	45.11	45.325	8402372.0
2010-08-18 10:00:00	QQQ	ETF	45.325	45.49	45.24	45.355	10975833.0
2010-08-18 11:00:00	QQQ	ETF	45.36	45.61	45.33	45.56	6657563.0
2010-08-18 12:00:00	QQQ	ETF	45.57	45.72	45.52	45.68	4011226.0
2010-08-18 13:00:00	QQQ	ETF	45.685	45.82	45.67	45.78	5528805.0
2010-08-18 14:00:00	QQQ	ETF	45.78	45.82	45.65	45.68	5448307.0
2010-08-18 15:00:00	QQQ	ETF	45.68	45.71	45.5	45.53	10580545.0
2010-08-18 16:00:00	QQQ	ETF	45.54	45.775	45.17	45.29	7637158.0
2010-08-18 17:00:00	QQQ	ETF	45.29	45.29	45.23	45.27	25916.0
2010-08-18 18:00:00	QQQ	ETF	45.24	45.26	45.19	45.26	98386.0
2010-08-18 19:00:00	QQQ	ETF	45.26	45.26	45.18	45.18	74556.0
2010-08-18 06:00:00	IWM	ETF	62.5	62.51	62.5	62.51	300.0
2010-08-18 07:00:00	IWM	ETF	62.43	62.69	62.43	62.68	7200.0
2010-08-18 08:00:00	IWM	ETF	62.42	62.8	62.42	62.77	135632.0
2010-08-18 09:00:00	IWM	ETF	62.76	62.82	61.94	62.35	7232725.0
2010-08-18 10:00:00	IWM	ETF	62.35	62.66	62.13	62.48	9724795.0
2010-08-18 11:00:00	IWM	ETF	62.48	62.96	62.4319	62.83	5913864.0
2010-08-18 12:00:00	IWM	ETF	62.8392	63.23	62.67	63.16	4077451.0
2010-08-18 13:00:00	IWM	ETF	63.16	63.43	63.1	63.26	4032127.0
2010-08-18 14:00:00	IWM	ETF	63.26	63.34	62.6766	63.1	4794147.0
2010-08-18 15:00:00	IWM	ETF	63.1	63.16	62.6757	62.82	9266068.0
2010-08-18 16:00:00	IWM	ETF	62.83	62.85	62.25	62.42	5800108.0
2010-08-18 17:00:00	IWM	ETF	62.39	62.8053	62.34	62.36	6006139.0
2010-08-18 18:00:00	IWM	ETF	62.41	62.48	62.34	62.43	54013.0
2010-08-18 19:00:00	IWM	ETF	62.44	62.45	62.3	62.35	6400.0
2010-08-18 07:00:00	DIA	ETF	104.13	104.28	104.13	104.28	4700.0
2010-08-18 08:00:00	DIA	ETF	104.28	104.49	104.28	104.44	9600.0
2010-08-18 09:00:00	DIA	ETF	104.45	104.47	103.68	103.93	900646.0
2010-08-18 10:00:00	DIA	ETF	103.94	104.17	103.76	104.01	1054956.0

> showing 50 of 4,907 rows — these rows as CSV

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