PREVIEW / etf_1hour / 2010-07-27

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-07-27.parquet
  size:    159 KB
  rows:    4,930

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-07-27 04:00:00	SPY	ETF	111.58	111.93	111.58	111.82	2570.0
2010-07-27 05:00:00	SPY	ETF	111.78	111.92	111.78	111.92	3590.0
2010-07-27 06:00:00	SPY	ETF	111.91	112.05	111.91	112.02	63495.0
2010-07-27 07:00:00	SPY	ETF	112.03	112.16	111.94	112.14	713826.0
2010-07-27 08:00:00	SPY	ETF	112.15	112.2	111.98	112.14	1612944.0
2010-07-27 09:00:00	SPY	ETF	112.14	112.37	107.3588	111.77	30313377.0
2010-07-27 10:00:00	SPY	ETF	111.76	112.29	111.46	111.58	47456046.0
2010-07-27 11:00:00	SPY	ETF	111.59	111.62	111.11	111.525	28947789.0
2010-07-27 12:00:00	SPY	ETF	111.53	111.7899	111.415	111.46	17499484.0
2010-07-27 13:00:00	SPY	ETF	111.46	111.63	111.22	111.49	17702604.0
2010-07-27 14:00:00	SPY	ETF	111.48	111.78	111.3	111.44	18190763.0
2010-07-27 15:00:00	SPY	ETF	111.44	111.81	111.43	111.52	29328736.0
2010-07-27 16:00:00	SPY	ETF	111.5	112.155	111.315	111.57	10053780.0
2010-07-27 17:00:00	SPY	ETF	111.57	111.6	111.53	111.55	95335.0
2010-07-27 18:00:00	SPY	ETF	111.55	111.57	111.51	111.53	66104.0
2010-07-27 19:00:00	SPY	ETF	111.54	111.58	111.53	111.55	24470.0
2010-07-27 04:00:00	QQQ	ETF	46.47	46.62	46.47	46.62	617.0
2010-07-27 05:00:00	QQQ	ETF	46.61	46.61	46.59	46.59	50300.0
2010-07-27 06:00:00	QQQ	ETF	46.6	46.68	46.6	46.68	4800.0
2010-07-27 07:00:00	QQQ	ETF	46.67	46.7	46.6	46.68	120164.0
2010-07-27 08:00:00	QQQ	ETF	46.68	46.73	46.44	46.7	420055.0
2010-07-27 09:00:00	QQQ	ETF	46.71	46.77	46.51	46.51	9594209.0
2010-07-27 10:00:00	QQQ	ETF	46.51	46.71	46.35	46.39	14360817.0
2010-07-27 11:00:00	QQQ	ETF	46.39	46.4	46.21	46.3701	6182612.0
2010-07-27 12:00:00	QQQ	ETF	46.38	46.49	46.29	46.34	6505833.0
2010-07-27 13:00:00	QQQ	ETF	46.35	46.4	46.21	46.35	5733442.0
2010-07-27 14:00:00	QQQ	ETF	46.35	46.52	46.31	46.38	5706953.0
2010-07-27 15:00:00	QQQ	ETF	46.38	46.54	46.38	46.41	10792210.0
2010-07-27 16:00:00	QQQ	ETF	46.412	46.4882	46.3837	46.43	983604.0
2010-07-27 17:00:00	QQQ	ETF	46.43	46.43	46.42	46.42	40795.0
2010-07-27 18:00:00	QQQ	ETF	46.42	46.42	46.4	46.41	10700.0
2010-07-27 19:00:00	QQQ	ETF	46.42	46.43	46.39	46.43	15260.0
2010-07-27 06:00:00	IWM	ETF	66.94	66.98	66.94	66.98	11900.0
2010-07-27 07:00:00	IWM	ETF	66.97	67.01	66.88	67.01	135273.0
2010-07-27 08:00:00	IWM	ETF	67.01	67.07	66.93	67.06	446501.0
2010-07-27 09:00:00	IWM	ETF	67.07	67.23	66.81	66.96	13961399.0
2010-07-27 10:00:00	IWM	ETF	66.96	67.27	66.48	66.6	14850725.0
2010-07-27 11:00:00	IWM	ETF	66.61	66.6364	66.18	66.38	7942813.0
2010-07-27 12:00:00	IWM	ETF	66.38	66.62	66.265	66.35	6940230.0
2010-07-27 13:00:00	IWM	ETF	66.36	66.44	65.98	66.15	5259401.0
2010-07-27 14:00:00	IWM	ETF	66.16	66.45	66.09	66.355	7407683.0
2010-07-27 15:00:00	IWM	ETF	66.35	66.51	66.14	66.21	15198041.0
2010-07-27 16:00:00	IWM	ETF	66.21	66.65	66.1824	66.21	3103344.0
2010-07-27 17:00:00	IWM	ETF	66.25	66.28	66.2	66.24	30403.0
2010-07-27 18:00:00	IWM	ETF	66.24	66.24	66.2	66.2	400.0
2010-07-27 19:00:00	IWM	ETF	66.13	66.22	66.13	66.2	4800.0
2010-07-27 07:00:00	DIA	ETF	105.63	105.77	105.63	105.77	6650.0
2010-07-27 08:00:00	DIA	ETF	105.74	105.77	105.65	105.65	70400.0
2010-07-27 09:00:00	DIA	ETF	105.74	105.85	105.37	105.37	1017435.0
2010-07-27 10:00:00	DIA	ETF	105.37	105.82	105.22	105.38	2027742.0

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

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