PREVIEW / etf_1hour / 2010-09-13

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-09-13.parquet
  size:    165 KB
  rows:    5,067

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-09-13 04:00:00	SPY	ETF	111.87	112.61	111.87	112.61	5430.0
2010-09-13 05:00:00	SPY	ETF	112.6	112.73	112.53	112.61	44796.0
2010-09-13 06:00:00	SPY	ETF	112.54	112.6	112.47	112.49	37665.0
2010-09-13 07:00:00	SPY	ETF	112.53	112.59	112.43	112.46	741350.0
2010-09-13 08:00:00	SPY	ETF	112.44	112.53	112.32	112.37	1541854.0
2010-09-13 09:00:00	SPY	ETF	112.36	112.78	112.35	112.5	20748684.0
2010-09-13 10:00:00	SPY	ETF	112.49	112.95	112.49	112.8	20663384.0
2010-09-13 11:00:00	SPY	ETF	112.8	112.83	112.52	112.64	17326592.0
2010-09-13 12:00:00	SPY	ETF	112.65	112.66	112.13	112.34	15829112.0
2010-09-13 13:00:00	SPY	ETF	112.34	112.53	112.26	112.36	21056433.0
2010-09-13 14:00:00	SPY	ETF	112.37	112.58	112.21	112.53	19056102.0
2010-09-13 15:00:00	SPY	ETF	112.53	112.86	112.41	112.74	29616829.0
2010-09-13 16:00:00	SPY	ETF	112.74	112.845	111.4971	112.82	29755867.0
2010-09-13 17:00:00	SPY	ETF	112.8	113.0	112.8	112.86	328509.0
2010-09-13 18:00:00	SPY	ETF	112.88	112.98	112.72	112.84	329480.0
2010-09-13 19:00:00	SPY	ETF	112.86	112.88	112.76	112.76	314674.0
2010-09-13 04:00:00	QQQ	ETF	46.75	47.0	46.75	46.98	1200.0
2010-09-13 05:00:00	QQQ	ETF	47.04	47.04	47.04	47.04	300.0
2010-09-13 06:00:00	QQQ	ETF	46.94	46.97	46.94	46.96	7801.0
2010-09-13 07:00:00	QQQ	ETF	46.94	46.97	46.9	46.92	57290.0
2010-09-13 08:00:00	QQQ	ETF	46.92	46.93	46.84	46.85	283752.0
2010-09-13 09:00:00	QQQ	ETF	46.85	47.23	46.85	47.07	9201248.0
2010-09-13 10:00:00	QQQ	ETF	47.08	47.33	47.08	47.27	8385925.0
2010-09-13 11:00:00	QQQ	ETF	47.27	47.31	47.18	47.2301	7507007.0
2010-09-13 12:00:00	QQQ	ETF	47.23	47.23	47.04	47.1	5240863.0
2010-09-13 13:00:00	QQQ	ETF	47.1	47.2	47.07	47.145	7237554.0
2010-09-13 14:00:00	QQQ	ETF	47.145	47.24	47.07	47.21	6114407.0
2010-09-13 15:00:00	QQQ	ETF	47.21	47.37	47.14	47.26	11310671.0
2010-09-13 16:00:00	QQQ	ETF	47.26	47.3627	47.1068	47.23	2438711.0
2010-09-13 17:00:00	QQQ	ETF	47.25	47.33	47.25	47.27	77015.0
2010-09-13 18:00:00	QQQ	ETF	47.27	47.3	47.27	47.29	33291.0
2010-09-13 19:00:00	QQQ	ETF	47.28	47.3	47.25	47.25	60971.0
2010-09-13 04:00:00	IWM	ETF	64.21	64.25	64.21	64.25	700.0
2010-09-13 06:00:00	IWM	ETF	64.38	64.4	64.38	64.4	1490.0
2010-09-13 07:00:00	IWM	ETF	64.38	64.43	64.34	64.34	101700.0
2010-09-13 08:00:00	IWM	ETF	64.37	64.46	64.29	64.3	110603.0
2010-09-13 09:00:00	IWM	ETF	64.31	64.71	64.31	64.52	6461766.0
2010-09-13 10:00:00	IWM	ETF	64.52	65.28	64.52	65.16	9835099.0
2010-09-13 11:00:00	IWM	ETF	65.13	65.25	65.01	65.12	5382024.0
2010-09-13 12:00:00	IWM	ETF	65.12	65.14	64.87	65.03	3839770.0
2010-09-13 13:00:00	IWM	ETF	65.03	65.22	65.021	65.04	2842230.0
2010-09-13 14:00:00	IWM	ETF	65.04	65.19	64.9	65.16	6430292.0
2010-09-13 15:00:00	IWM	ETF	65.17	65.48	65.08	65.28	15118082.0
2010-09-13 16:00:00	IWM	ETF	65.29	65.413	63.7449	65.28	5384205.0
2010-09-13 17:00:00	IWM	ETF	65.28	65.43	63.7502	65.4	1012381.0
2010-09-13 18:00:00	IWM	ETF	65.38	65.38	65.3	65.3	3800.0
2010-09-13 19:00:00	IWM	ETF	65.32	65.34	65.27	65.33	6972.0
2010-09-13 04:00:00	DIA	ETF	105.0	105.5	105.0	105.5	200.0
2010-09-13 06:00:00	DIA	ETF	105.68	105.68	105.67	105.67	3600.0
2010-09-13 07:00:00	DIA	ETF	105.67	105.67	105.6	105.65	9700.0

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

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