PREVIEW / etf_1hour / 2010-08-27

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-08-27.parquet
  size:    164 KB
  rows:    5,002

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-27 04:00:00	SPY	ETF	105.14	105.21	105.12	105.13	2000.0
2010-08-27 05:00:00	SPY	ETF	105.12	105.3	105.07	105.27	8417.0
2010-08-27 06:00:00	SPY	ETF	105.34	105.47	105.19	105.47	7000.0
2010-08-27 07:00:00	SPY	ETF	105.4	105.49	105.3	105.31	656202.0
2010-08-27 08:00:00	SPY	ETF	105.3	106.0	105.28	105.83	5579941.0
2010-08-27 09:00:00	SPY	ETF	105.82	105.98	105.0	105.05	27811502.0
2010-08-27 10:00:00	SPY	ETF	105.05	105.92	104.31	105.59	75249001.0
2010-08-27 11:00:00	SPY	ETF	105.6	106.47	105.58	106.22	30427248.0
2010-08-27 12:00:00	SPY	ETF	106.21	106.5	106.0	106.06	15642659.0
2010-08-27 13:00:00	SPY	ETF	106.0501	106.63	105.98	106.63	19874324.0
2010-08-27 14:00:00	SPY	ETF	106.62	106.84	106.35	106.63	26994079.0
2010-08-27 15:00:00	SPY	ETF	106.64	106.97	106.45	106.86	42485752.0
2010-08-27 16:00:00	SPY	ETF	106.86	106.99	104.835	106.95	16739073.0
2010-08-27 17:00:00	SPY	ETF	106.95	107.18	106.82	107.16	775820.0
2010-08-27 18:00:00	SPY	ETF	107.13	107.13	106.82	106.98	357813.0
2010-08-27 19:00:00	SPY	ETF	107.01	107.13	106.99	107.05	38030.0
2010-08-27 04:00:00	QQQ	ETF	43.52	43.52	43.49	43.49	18250.0
2010-08-27 05:00:00	QQQ	ETF	43.56	43.56	43.56	43.56	100.0
2010-08-27 06:00:00	QQQ	ETF	43.64	43.69	43.64	43.68	30500.0
2010-08-27 07:00:00	QQQ	ETF	43.67	43.72	43.65	43.65	24940.0
2010-08-27 08:00:00	QQQ	ETF	43.64	43.95	43.61	43.87	1142522.0
2010-08-27 09:00:00	QQQ	ETF	43.87	43.93	43.3	43.33	11585201.0
2010-08-27 10:00:00	QQQ	ETF	43.32	43.8	42.97	43.56	52734473.0
2010-08-27 11:00:00	QQQ	ETF	43.55	43.99	43.545	43.84	8110571.0
2010-08-27 12:00:00	QQQ	ETF	43.84	44.01	43.76	43.79	4254812.0
2010-08-27 13:00:00	QQQ	ETF	43.79	44.05	43.75	44.05	7437337.0
2010-08-27 14:00:00	QQQ	ETF	44.05	44.16	43.93	44.055	6141176.0
2010-08-27 15:00:00	QQQ	ETF	44.06	44.15	43.97	44.09	11914274.0
2010-08-27 16:00:00	QQQ	ETF	44.1	44.14	43.9382	44.11	2005875.0
2010-08-27 17:00:00	QQQ	ETF	44.09	44.14	44.09	44.14	6558.0
2010-08-27 18:00:00	QQQ	ETF	44.14	44.14	44.1	44.1	14492.0
2010-08-27 19:00:00	QQQ	ETF	44.09	44.19	44.09	44.15	13090.0
2010-08-27 04:00:00	IWM	ETF	60.11	60.11	60.11	60.11	100.0
2010-08-27 05:00:00	IWM	ETF	60.09	60.26	60.09	60.26	400.0
2010-08-27 06:00:00	IWM	ETF	60.36	60.36	60.35	60.35	300.0
2010-08-27 07:00:00	IWM	ETF	60.36	60.4	60.29	60.29	6250.0
2010-08-27 08:00:00	IWM	ETF	59.98	60.89	59.98	60.76	1859209.0
2010-08-27 09:00:00	IWM	ETF	60.76	60.82	59.85	59.89	5841173.0
2010-08-27 10:00:00	IWM	ETF	59.89	60.8	59.56	60.41	23213579.0
2010-08-27 11:00:00	IWM	ETF	60.42	61.17	60.4	60.94	7466015.0
2010-08-27 12:00:00	IWM	ETF	60.94	61.15	60.76	60.79	3628555.0
2010-08-27 13:00:00	IWM	ETF	60.8	61.27	60.75	61.26	4543651.0
2010-08-27 14:00:00	IWM	ETF	61.27	61.5	61.05	61.37	6029766.0
2010-08-27 15:00:00	IWM	ETF	61.38	61.8	61.28	61.7	11264117.0
2010-08-27 16:00:00	IWM	ETF	61.7	61.89	61.3628	61.82	2619616.0
2010-08-27 17:00:00	IWM	ETF	61.8	61.83	61.77	61.82	3332.0
2010-08-27 18:00:00	IWM	ETF	61.83	61.87	61.81	61.84	700.0
2010-08-27 19:00:00	IWM	ETF	61.85	61.85	61.81	61.81	700.0
2010-08-27 05:00:00	DIA	ETF	99.95	99.95	99.95	99.95	100.0
2010-08-27 07:00:00	DIA	ETF	100.08	100.12	100.08	100.12	500.0

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

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