PREVIEW / etf_1hour / 2010-08-25

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-08-25.parquet
  size:    169 KB
  rows:    5,104

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-25 04:00:00	SPY	ETF	106.0	106.0	105.92	105.92	1470.0
2010-08-25 05:00:00	SPY	ETF	105.7	105.7	105.43	105.43	900.0
2010-08-25 06:00:00	SPY	ETF	105.5	105.57	105.36	105.48	22800.0
2010-08-25 07:00:00	SPY	ETF	105.54	105.54	105.18	105.38	679743.0
2010-08-25 08:00:00	SPY	ETF	105.38	105.38	104.66	104.84	4440415.0
2010-08-25 09:00:00	SPY	ETF	104.84	105.56	104.49	104.71	39770197.0
2010-08-25 10:00:00	SPY	ETF	104.71	105.16	104.29	105.11	43517550.0
2010-08-25 11:00:00	SPY	ETF	105.11	105.44	104.91	105.268	31426188.0
2010-08-25 12:00:00	SPY	ETF	105.26	105.38	104.92	105.01	14269165.0
2010-08-25 13:00:00	SPY	ETF	105.01	105.44	104.94	105.33	22216344.0
2010-08-25 14:00:00	SPY	ETF	105.33	106.02	105.2125	105.98	33081946.0
2010-08-25 15:00:00	SPY	ETF	105.98	106.34	105.63	105.93	51857520.0
2010-08-25 16:00:00	SPY	ETF	105.93	106.285	104.805	106.06	26707688.0
2010-08-25 17:00:00	SPY	ETF	106.08	106.11	106.01	106.03	71984.0
2010-08-25 18:00:00	SPY	ETF	106.03	106.06	105.88	106.06	74465.0
2010-08-25 19:00:00	SPY	ETF	106.06	106.2	106.06	106.2	87083.0
2010-08-25 06:00:00	QQQ	ETF	43.53	43.54	43.53	43.54	10200.0
2010-08-25 07:00:00	QQQ	ETF	43.59	43.59	43.46	43.52	99350.0
2010-08-25 08:00:00	QQQ	ETF	43.53	43.54	43.25	43.29	1208980.0
2010-08-25 09:00:00	QQQ	ETF	43.29	43.62	43.23	43.43	12303961.0
2010-08-25 10:00:00	QQQ	ETF	43.44	43.67	43.27	43.65	14144678.0
2010-08-25 11:00:00	QQQ	ETF	43.64	43.82	43.53	43.74	19063326.0
2010-08-25 12:00:00	QQQ	ETF	43.7491	43.8	43.58	43.6475	3129345.0
2010-08-25 13:00:00	QQQ	ETF	43.64	43.79	43.6	43.73	4866094.0
2010-08-25 14:00:00	QQQ	ETF	43.73	44.07	43.72	44.05	9716726.0
2010-08-25 15:00:00	QQQ	ETF	44.05	44.26	43.93	44.07	14991906.0
2010-08-25 16:00:00	QQQ	ETF	44.06	44.5	43.43	44.08	4062536.0
2010-08-25 17:00:00	QQQ	ETF	44.08	44.09	44.07	44.07	23862.0
2010-08-25 18:00:00	QQQ	ETF	44.05	44.08	44.05	44.08	10895.0
2010-08-25 19:00:00	QQQ	ETF	44.08	44.12	44.08	44.12	65808.0
2010-08-25 06:00:00	IWM	ETF	59.42	59.42	59.42	59.42	400.0
2010-08-25 07:00:00	IWM	ETF	59.42	59.44	59.35	59.4	56900.0
2010-08-25 08:00:00	IWM	ETF	59.38	59.44	58.94	59.11	873027.0
2010-08-25 09:00:00	IWM	ETF	59.11	59.52	58.93	59.14	7979755.0
2010-08-25 10:00:00	IWM	ETF	59.14	59.56	58.89	59.49	12458367.0
2010-08-25 11:00:00	IWM	ETF	59.495	59.89	59.38	59.72	7415126.0
2010-08-25 12:00:00	IWM	ETF	59.73	59.82	59.41	59.47	3738639.0
2010-08-25 13:00:00	IWM	ETF	59.47	59.79	59.4	59.68	5447922.0
2010-08-25 14:00:00	IWM	ETF	59.69	60.3	59.685	60.3	8235265.0
2010-08-25 15:00:00	IWM	ETF	60.3	60.68	60.015	60.53	13090983.0
2010-08-25 16:00:00	IWM	ETF	60.53	60.61	59.5931	60.57	2880186.0
2010-08-25 17:00:00	IWM	ETF	60.56	60.59	60.55	60.59	10815.0
2010-08-25 18:00:00	IWM	ETF	60.56	60.56	60.45	60.53	2966.0
2010-08-25 19:00:00	IWM	ETF	60.59	60.64	60.54	60.63	15285.0
2010-08-25 07:00:00	DIA	ETF	100.32	100.32	100.15	100.18	3300.0
2010-08-25 08:00:00	DIA	ETF	100.18	100.22	99.71	99.87	40336.0
2010-08-25 09:00:00	DIA	ETF	99.9	100.29	99.56	99.72	1390079.0
2010-08-25 10:00:00	DIA	ETF	99.73	100.2195	99.37	100.16	2220521.0
2010-08-25 11:00:00	DIA	ETF	100.16	100.4	100.04	100.25	1830570.0
2010-08-25 12:00:00	DIA	ETF	100.26	100.33	99.8901	99.97	643708.0

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

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