PREVIEW / etf_1hour / 2010-08-09

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-08-09.parquet
  size:    155 KB
  rows:    4,831

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-09 04:00:00	SPY	ETF	112.71	112.9	112.71	112.9	2900.0
2010-08-09 05:00:00	SPY	ETF	112.91	112.91	112.91	112.91	600.0
2010-08-09 06:00:00	SPY	ETF	112.88	112.89	112.83	112.89	26425.0
2010-08-09 07:00:00	SPY	ETF	112.87	113.01	112.8	112.97	665742.0
2010-08-09 08:00:00	SPY	ETF	112.97	113.05	112.91	112.93	900393.0
2010-08-09 09:00:00	SPY	ETF	112.94	112.98	112.32	112.47	18734501.0
2010-08-09 10:00:00	SPY	ETF	112.47	112.75	112.4	112.71	16425315.0
2010-08-09 11:00:00	SPY	ETF	112.72	112.96	112.66	112.82	13891606.0
2010-08-09 12:00:00	SPY	ETF	112.81	112.92	112.72	112.78	5949377.0
2010-08-09 13:00:00	SPY	ETF	112.79	112.92	112.72	112.84	6492977.0
2010-08-09 14:00:00	SPY	ETF	112.83	113.18	112.83	113.18	11086346.0
2010-08-09 15:00:00	SPY	ETF	113.18	113.18	112.89	112.9801	21822432.0
2010-08-09 16:00:00	SPY	ETF	112.99	113.09	112.325	113.04	5671922.0
2010-08-09 17:00:00	SPY	ETF	113.04	113.1	113.0	113.04	372090.0
2010-08-09 18:00:00	SPY	ETF	113.05	113.08	113.01	113.08	51925.0
2010-08-09 19:00:00	SPY	ETF	113.08	113.09	113.0	113.0	36893.0
2010-08-09 04:00:00	QQQ	ETF	46.94	46.94	46.93	46.93	3000.0
2010-08-09 05:00:00	QQQ	ETF	46.97	46.97	46.97	46.97	100.0
2010-08-09 06:00:00	QQQ	ETF	46.96	46.97	46.96	46.97	600.0
2010-08-09 07:00:00	QQQ	ETF	46.95	47.0	46.94	47.0	47592.0
2010-08-09 08:00:00	QQQ	ETF	47.0	47.0	46.96	46.97	142852.0
2010-08-09 09:00:00	QQQ	ETF	46.97	47.08	46.79	46.8772	5979046.0
2010-08-09 10:00:00	QQQ	ETF	46.88	47.03	46.86	46.95	3571836.0
2010-08-09 11:00:00	QQQ	ETF	46.95	47.05	46.91	46.97	2970831.0
2010-08-09 12:00:00	QQQ	ETF	46.96	47.03	46.9399	46.98	1477859.0
2010-08-09 13:00:00	QQQ	ETF	46.9704	47.04	46.95	47.01	1765068.0
2010-08-09 14:00:00	QQQ	ETF	47.02	47.19	47.02	47.18	2509161.0
2010-08-09 15:00:00	QQQ	ETF	47.18	47.19	47.06	47.0799	5542125.0
2010-08-09 16:00:00	QQQ	ETF	47.08	47.1678	46.9028	47.07	1713650.0
2010-08-09 17:00:00	QQQ	ETF	47.08	47.09	47.06	47.07	5693.0
2010-08-09 18:00:00	QQQ	ETF	47.07	47.08	47.06	47.07	2700.0
2010-08-09 19:00:00	QQQ	ETF	47.08	47.08	47.05	47.05	8167.0
2010-08-09 04:00:00	IWM	ETF	65.54	65.54	65.54	65.54	146.0
2010-08-09 07:00:00	IWM	ETF	65.53	65.59	65.46	65.58	37800.0
2010-08-09 08:00:00	IWM	ETF	65.55	65.62	65.53	65.54	188522.0
2010-08-09 09:00:00	IWM	ETF	65.54	65.67	65.17	65.26	6459755.0
2010-08-09 10:00:00	IWM	ETF	65.255	65.5	65.15	65.48	3530053.0
2010-08-09 11:00:00	IWM	ETF	65.48	65.75	65.43	65.69	3146085.0
2010-08-09 12:00:00	IWM	ETF	65.69	65.81	65.55	65.68	2345376.0
2010-08-09 13:00:00	IWM	ETF	65.68	65.79	65.58	65.7	2560714.0
2010-08-09 14:00:00	IWM	ETF	65.71	66.11	65.69	66.1	4089913.0
2010-08-09 15:00:00	IWM	ETF	66.1	66.1	65.82	65.86	6902931.0
2010-08-09 16:00:00	IWM	ETF	65.86	66.01	65.86	65.95	3139911.0
2010-08-09 17:00:00	IWM	ETF	65.93	65.95	65.91	65.94	52600.0
2010-08-09 18:00:00	IWM	ETF	65.92	65.92	65.91	65.91	700.0
2010-08-09 19:00:00	IWM	ETF	65.92	65.93	65.9	65.93	2000.0
2010-08-09 07:00:00	DIA	ETF	107.03	107.11	107.03	107.08	3300.0
2010-08-09 08:00:00	DIA	ETF	107.08	107.18	107.07	107.1	105562.0
2010-08-09 09:00:00	DIA	ETF	107.1	107.13	106.64	106.75	702311.0
2010-08-09 10:00:00	DIA	ETF	106.75	107.05	106.75	107.04	414561.0

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

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