PREVIEW / etf_1hour / 2010-01-25

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-01-25.parquet
  size:    155 KB
  rows:    4,827

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-01-25 04:00:00	SPY	ETF	110.08	110.55	110.08	110.44	39075.0
2010-01-25 05:00:00	SPY	ETF	110.54	110.7	110.53	110.62	43300.0
2010-01-25 06:00:00	SPY	ETF	110.6	110.67	110.4	110.49	57135.0
2010-01-25 07:00:00	SPY	ETF	110.49	110.54	110.15	110.25	545727.0
2010-01-25 08:00:00	SPY	ETF	110.22	110.41	110.06	110.25	2637909.0
2010-01-25 09:00:00	SPY	ETF	110.24	110.46	110.02	110.17	29562130.0
2010-01-25 10:00:00	SPY	ETF	110.16	110.37	109.64	109.96	43297638.0
2010-01-25 11:00:00	SPY	ETF	109.96	110.01	109.41	109.825	30966499.0
2010-01-25 12:00:00	SPY	ETF	109.8	110.2	109.8	110.1	13237963.0
2010-01-25 13:00:00	SPY	ETF	110.1	110.23	109.89	110.02	10957303.0
2010-01-25 14:00:00	SPY	ETF	110.0199	110.39	109.87	110.365	12950332.0
2010-01-25 15:00:00	SPY	ETF	110.38	110.41	109.73	109.75	31603845.0
2010-01-25 16:00:00	SPY	ETF	109.77	110.38	109.1445	109.81	9151410.0
2010-01-25 17:00:00	SPY	ETF	109.8	109.81	109.5	109.75	706790.0
2010-01-25 18:00:00	SPY	ETF	109.73	109.77	109.64	109.7	49814.0
2010-01-25 19:00:00	SPY	ETF	109.73	109.91	109.72	109.86	136287.0
2010-01-25 04:00:00	QQQ	ETF	44.48	44.5	44.46	44.5	1776.0
2010-01-25 05:00:00	QQQ	ETF	44.52	44.57	44.52	44.57	300.0
2010-01-25 06:00:00	QQQ	ETF	44.54	44.58	44.47	44.47	10298.0
2010-01-25 07:00:00	QQQ	ETF	44.49	44.51	44.37	44.38	200800.0
2010-01-25 08:00:00	QQQ	ETF	44.4	44.5	44.16	44.42	1216151.0
2010-01-25 09:00:00	QQQ	ETF	44.42	44.53	44.35	44.47	14788306.0
2010-01-25 10:00:00	QQQ	ETF	44.47	44.6	44.35	44.48	35791244.0
2010-01-25 11:00:00	QQQ	ETF	44.48	44.4914	44.12	44.24	18690064.0
2010-01-25 12:00:00	QQQ	ETF	44.2401	44.44	44.23	44.4	8232797.0
2010-01-25 13:00:00	QQQ	ETF	44.4006	44.55	44.3215	44.39	6164806.0
2010-01-25 14:00:00	QQQ	ETF	44.39	44.55	44.39	44.54	8052668.0
2010-01-25 15:00:00	QQQ	ETF	44.54	44.55	44.3	44.3	16562566.0
2010-01-25 16:00:00	QQQ	ETF	44.3	44.89	43.9	44.38	35713753.0
2010-01-25 17:00:00	QQQ	ETF	44.37	44.5	44.15	44.43	3819327.0
2010-01-25 18:00:00	QQQ	ETF	44.39	44.42	44.36	44.39	320603.0
2010-01-25 19:00:00	QQQ	ETF	44.39	44.44	44.38	44.44	48638.0
2010-01-25 06:00:00	IWM	ETF	62.0	62.35	62.0	62.33	3200.0
2010-01-25 07:00:00	IWM	ETF	62.27	62.37	62.11	62.13	49500.0
2010-01-25 08:00:00	IWM	ETF	62.16	62.37	61.73	62.1	759151.0
2010-01-25 09:00:00	IWM	ETF	62.09	62.29	61.64	61.84	10279870.0
2010-01-25 10:00:00	IWM	ETF	61.83	62.05	61.6154	61.82	13759121.0
2010-01-25 11:00:00	IWM	ETF	61.82	61.84	61.33	61.57	8075303.0
2010-01-25 12:00:00	IWM	ETF	61.56	61.9	61.55	61.83	3918654.0
2010-01-25 13:00:00	IWM	ETF	61.835	61.95	61.7	61.85	2883360.0
2010-01-25 14:00:00	IWM	ETF	61.85	62.01	61.81	62.01	3051945.0
2010-01-25 15:00:00	IWM	ETF	62.01	62.02	61.69	61.76	6990885.0
2010-01-25 16:00:00	IWM	ETF	61.76	62.0237	61.67	61.94	4760031.0
2010-01-25 17:00:00	IWM	ETF	61.94	61.95	61.6946	61.88	1147989.0
2010-01-25 18:00:00	IWM	ETF	61.78	61.81	61.78	61.8	1684.0
2010-01-25 19:00:00	IWM	ETF	61.87	61.9	61.86	61.86	950.0
2010-01-25 06:00:00	DIA	ETF	102.63	102.63	102.63	102.63	500.0
2010-01-25 07:00:00	DIA	ETF	102.58	102.75	102.42	102.43	5400.0
2010-01-25 08:00:00	DIA	ETF	102.53	102.6	102.32	102.4	29980.0
2010-01-25 09:00:00	DIA	ETF	102.42	102.59	102.22	102.385	2187742.0

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

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