PREVIEW / etf_1hour / 2010-08-03

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-08-03.parquet
  size:    158 KB
  rows:    4,892

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-03 04:00:00	SPY	ETF	112.52	112.52	112.37	112.47	24400.0
2010-08-03 05:00:00	SPY	ETF	112.5	112.6	112.5	112.5	2556.0
2010-08-03 06:00:00	SPY	ETF	112.62	112.72	112.52	112.52	14475.0
2010-08-03 07:00:00	SPY	ETF	112.52	112.59	112.31	112.51	552067.0
2010-08-03 08:00:00	SPY	ETF	112.52	112.64	112.32	112.59	1491750.0
2010-08-03 09:00:00	SPY	ETF	112.59	112.59	112.07	112.17	19595503.0
2010-08-03 10:00:00	SPY	ETF	112.2	112.53	111.85	112.48	31699898.0
2010-08-03 11:00:00	SPY	ETF	112.48	112.77	112.34	112.57	18596076.0
2010-08-03 12:00:00	SPY	ETF	112.56	112.58	112.14	112.33	13226405.0
2010-08-03 13:00:00	SPY	ETF	112.33	112.44	112.12	112.33	11324205.0
2010-08-03 14:00:00	SPY	ETF	112.33	112.51	112.26	112.4	12774825.0
2010-08-03 15:00:00	SPY	ETF	112.4	112.44	111.97	112.2	27961097.0
2010-08-03 16:00:00	SPY	ETF	112.2	112.595	111.975	112.39	7307769.0
2010-08-03 17:00:00	SPY	ETF	112.39	112.42	112.33	112.39	149897.0
2010-08-03 18:00:00	SPY	ETF	112.39	112.4	112.22	112.33	169429.0
2010-08-03 19:00:00	SPY	ETF	112.33	112.38	112.3	112.38	17799.0
2010-08-03 04:00:00	QQQ	ETF	46.59	46.59	46.59	46.59	400.0
2010-08-03 05:00:00	QQQ	ETF	46.58	46.58	46.58	46.58	200.0
2010-08-03 06:00:00	QQQ	ETF	46.65	46.66	46.65	46.66	10000.0
2010-08-03 07:00:00	QQQ	ETF	46.61	46.61	46.52	46.59	17128.0
2010-08-03 08:00:00	QQQ	ETF	46.59	46.66	46.53	46.65	167155.0
2010-08-03 09:00:00	QQQ	ETF	46.64	46.7	46.32	46.38	7838806.0
2010-08-03 10:00:00	QQQ	ETF	46.37	46.57	46.25	46.56	10892643.0
2010-08-03 11:00:00	QQQ	ETF	46.565	46.7	46.49	46.635	8939517.0
2010-08-03 12:00:00	QQQ	ETF	46.63	46.635	46.37	46.46	8885080.0
2010-08-03 13:00:00	QQQ	ETF	46.4699	46.55	46.3815	46.48	5505837.0
2010-08-03 14:00:00	QQQ	ETF	46.49	46.56	46.45	46.53	3521834.0
2010-08-03 15:00:00	QQQ	ETF	46.535	46.56	46.36	46.4899	10666034.0
2010-08-03 16:00:00	QQQ	ETF	46.49	46.7	46.41	46.62	2659498.0
2010-08-03 17:00:00	QQQ	ETF	46.62	46.62	46.58	46.58	8244.0
2010-08-03 18:00:00	QQQ	ETF	46.6	46.62	46.6	46.62	2900.0
2010-08-03 19:00:00	QQQ	ETF	46.61	46.61	46.56	46.56	5850.0
2010-08-03 06:00:00	IWM	ETF	66.1	66.1	66.03	66.03	300.0
2010-08-03 07:00:00	IWM	ETF	66.04	66.04	65.87	65.95	10500.0
2010-08-03 08:00:00	IWM	ETF	65.95	66.06	65.82	66.02	202809.0
2010-08-03 09:00:00	IWM	ETF	66.02	66.03	65.305	65.42	5802411.0
2010-08-03 10:00:00	IWM	ETF	65.43	65.99	65.09	65.97	7079188.0
2010-08-03 11:00:00	IWM	ETF	65.98	66.53	65.88	66.35	8656870.0
2010-08-03 12:00:00	IWM	ETF	66.35	66.35	65.97	66.21	5510165.0
2010-08-03 13:00:00	IWM	ETF	66.22	66.26	65.93	66.04	4365494.0
2010-08-03 14:00:00	IWM	ETF	66.04	66.31	65.99	66.14	3399092.0
2010-08-03 15:00:00	IWM	ETF	66.13	66.14	65.2921	65.63	10063492.0
2010-08-03 16:00:00	IWM	ETF	65.63	66.187	65.61	65.73	1682066.0
2010-08-03 17:00:00	IWM	ETF	65.77	65.8	65.75	65.8	1600.0
2010-08-03 18:00:00	IWM	ETF	65.82	65.82	65.73	65.73	21645.0
2010-08-03 19:00:00	IWM	ETF	65.74	65.75	65.73	65.73	1800.0
2010-08-03 05:00:00	DIA	ETF	106.55	106.55	106.55	106.55	300.0
2010-08-03 06:00:00	DIA	ETF	106.6	106.6	106.6	106.6	500.0
2010-08-03 07:00:00	DIA	ETF	106.62	106.67	106.43	106.52	8000.0
2010-08-03 08:00:00	DIA	ETF	106.55	106.62	106.33	106.6	28125.0

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

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