PREVIEW / etf_1hour / 2010-08-11

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-08-11.parquet
  size:    175 KB
  rows:    5,353

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-11 04:00:00	SPY	ETF	112.11	112.11	111.26	111.3	10303.0
2010-08-11 05:00:00	SPY	ETF	111.25	111.25	110.98	110.98	6195.0
2010-08-11 06:00:00	SPY	ETF	110.94	110.99	110.71	110.99	237013.0
2010-08-11 07:00:00	SPY	ETF	110.97	111.01	110.83	110.92	1091979.0
2010-08-11 08:00:00	SPY	ETF	110.94	112.1	110.68	110.75	2154671.0
2010-08-11 09:00:00	SPY	ETF	110.77	110.77	109.92	110.16	40230063.0
2010-08-11 10:00:00	SPY	ETF	110.16	110.32	109.73	109.76	38625320.0
2010-08-11 11:00:00	SPY	ETF	109.75	110.0577	109.38	109.64	33259433.0
2010-08-11 12:00:00	SPY	ETF	109.63	109.68	109.23	109.27	19935798.0
2010-08-11 13:00:00	SPY	ETF	109.27	109.61	109.27	109.4	17809261.0
2010-08-11 14:00:00	SPY	ETF	109.4	109.72	109.12	109.28	23773312.0
2010-08-11 15:00:00	SPY	ETF	109.28	109.58	109.14	109.2901	57666067.0
2010-08-11 16:00:00	SPY	ETF	109.29	112.407	108.68	108.68	32761972.0
2010-08-11 17:00:00	SPY	ETF	108.68	112.4069	107.88	108.24	2863383.0
2010-08-11 18:00:00	SPY	ETF	108.23	109.3	108.15	108.29	309151.0
2010-08-11 19:00:00	SPY	ETF	108.3	108.44	108.23	108.44	155662.0
2010-08-11 04:00:00	QQQ	ETF	46.2	46.2	46.1	46.17	7200.0
2010-08-11 05:00:00	QQQ	ETF	46.08	46.08	45.99	46.01	4090.0
2010-08-11 06:00:00	QQQ	ETF	45.96	45.99	45.88	45.99	25500.0
2010-08-11 07:00:00	QQQ	ETF	45.98	46.02	45.95	46.0	114739.0
2010-08-11 08:00:00	QQQ	ETF	46.3857	46.3857	45.92	45.94	760677.0
2010-08-11 09:00:00	QQQ	ETF	45.95	45.95	45.45	45.6	17376223.0
2010-08-11 10:00:00	QQQ	ETF	45.6	45.68	45.36	45.38	12210335.0
2010-08-11 11:00:00	QQQ	ETF	45.38	45.43	45.25	45.38	11130346.0
2010-08-11 12:00:00	QQQ	ETF	45.37	45.4947	45.21	45.2401	4708697.0
2010-08-11 13:00:00	QQQ	ETF	45.245	45.42	45.245	45.34	4711933.0
2010-08-11 14:00:00	QQQ	ETF	45.35	45.5	45.29	45.355	6094950.0
2010-08-11 15:00:00	QQQ	ETF	45.36	45.5	45.27	45.4	12457064.0
2010-08-11 16:00:00	QQQ	ETF	45.39	46.7053	44.85	44.92	10376389.0
2010-08-11 17:00:00	QQQ	ETF	44.92	44.92	44.61	44.69	908471.0
2010-08-11 18:00:00	QQQ	ETF	44.69	44.79	44.69	44.79	84743.0
2010-08-11 19:00:00	QQQ	ETF	44.77	44.87	44.75	44.87	69970.0
2010-08-11 04:00:00	IWM	ETF	63.93	63.93	63.89	63.89	1226.0
2010-08-11 05:00:00	IWM	ETF	63.87	63.87	63.87	63.87	196.0
2010-08-11 06:00:00	IWM	ETF	63.45	63.55	63.43	63.53	8749.0
2010-08-11 07:00:00	IWM	ETF	63.55	63.6	63.43	63.48	119432.0
2010-08-11 08:00:00	IWM	ETF	63.49	63.57	63.31	63.34	447152.0
2010-08-11 09:00:00	IWM	ETF	63.33	63.38	62.78	63.1	10271378.0
2010-08-11 10:00:00	IWM	ETF	63.09	63.26	62.55	62.59	10631109.0
2010-08-11 11:00:00	IWM	ETF	62.59	62.7727	62.32	62.54	7806764.0
2010-08-11 12:00:00	IWM	ETF	62.54	62.5701	62.15	62.235	6741335.0
2010-08-11 13:00:00	IWM	ETF	62.25	62.52	62.22	62.25	4614871.0
2010-08-11 14:00:00	IWM	ETF	62.24	62.44	62.0	62.12	6995097.0
2010-08-11 15:00:00	IWM	ETF	62.11	62.32	61.91	62.1	17114265.0
2010-08-11 16:00:00	IWM	ETF	62.11	62.21	61.66	61.66	3200824.0
2010-08-11 17:00:00	IWM	ETF	61.67	64.6567	61.2	61.24	4279126.0
2010-08-11 18:00:00	IWM	ETF	61.25	61.37	61.24	61.33	12616.0
2010-08-11 19:00:00	IWM	ETF	61.37	61.37	61.24	61.35	22897.0
2010-08-11 06:00:00	DIA	ETF	105.3	105.5	105.3	105.5	1400.0
2010-08-11 07:00:00	DIA	ETF	105.43	105.56	105.38	105.45	12100.0

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

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