PREVIEW / etf_1hour / 2010-11-08

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-11-08.parquet
  size:    172 KB
  rows:    5,285

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-11-08 04:00:00	SPY	ETF	122.48	122.51	122.22	122.27	3150.0
2010-11-08 05:00:00	SPY	ETF	122.37	122.42	122.15	122.25	15888.0
2010-11-08 06:00:00	SPY	ETF	122.21	122.32	122.21	122.3	6188.0
2010-11-08 07:00:00	SPY	ETF	122.3	122.45	122.28	122.31	327743.0
2010-11-08 08:00:00	SPY	ETF	122.31	122.43	122.27	122.32	2309519.0
2010-11-08 09:00:00	SPY	ETF	122.31	122.48	122.05	122.11	19822456.0
2010-11-08 10:00:00	SPY	ETF	122.11	122.38	122.0	122.08	24346954.0
2010-11-08 11:00:00	SPY	ETF	122.07	122.43	121.94	122.37	17862493.0
2010-11-08 12:00:00	SPY	ETF	122.37	122.55	122.2901	122.39	10414037.0
2010-11-08 13:00:00	SPY	ETF	122.4	122.58	122.3	122.41	15764853.0
2010-11-08 14:00:00	SPY	ETF	122.41	122.62	122.35	122.37	13458910.0
2010-11-08 15:00:00	SPY	ETF	122.37	122.69	122.31	122.54	28229969.0
2010-11-08 16:00:00	SPY	ETF	122.53	122.7833	122.135	122.33	15581164.0
2010-11-08 17:00:00	SPY	ETF	122.33	122.34	122.24	122.3	2109752.0
2010-11-08 18:00:00	SPY	ETF	122.3	122.54	122.13	122.18	234932.0
2010-11-08 19:00:00	SPY	ETF	122.18	122.18	122.02	122.05	117894.0
2010-11-08 04:00:00	QQQ	ETF	53.63	53.63	53.61	53.61	300.0
2010-11-08 05:00:00	QQQ	ETF	53.52	53.54	53.52	53.54	4500.0
2010-11-08 06:00:00	QQQ	ETF	53.55	53.55	53.5	53.5	10000.0
2010-11-08 07:00:00	QQQ	ETF	53.59	53.63	53.55	53.56	35000.0
2010-11-08 08:00:00	QQQ	ETF	53.56	53.61	53.56	53.58	201242.0
2010-11-08 09:00:00	QQQ	ETF	53.57	53.67	53.4499	53.52	7011210.0
2010-11-08 10:00:00	QQQ	ETF	53.52	53.79	53.4601	53.68	7313025.0
2010-11-08 11:00:00	QQQ	ETF	53.68	53.78	53.62	53.7501	5405096.0
2010-11-08 12:00:00	QQQ	ETF	53.76	53.83	53.7248	53.77	2524306.0
2010-11-08 13:00:00	QQQ	ETF	53.765	53.82	53.68	53.72	2430020.0
2010-11-08 14:00:00	QQQ	ETF	53.715	53.81	53.68	53.68	3830703.0
2010-11-08 15:00:00	QQQ	ETF	53.68	53.8	53.66	53.74	7212368.0
2010-11-08 16:00:00	QQQ	ETF	53.74	53.7753	53.61	53.68	2046408.0
2010-11-08 17:00:00	QQQ	ETF	53.65	53.65	53.62	53.65	27550.0
2010-11-08 18:00:00	QQQ	ETF	53.67	53.67	53.58	53.58	30211.0
2010-11-08 19:00:00	QQQ	ETF	53.57	53.59	53.54	53.57	51082.0
2010-11-08 06:00:00	IWM	ETF	73.4	73.4	73.4	73.4	250.0
2010-11-08 07:00:00	IWM	ETF	73.51	73.57	73.44	73.44	21720.0
2010-11-08 08:00:00	IWM	ETF	73.46	73.54	73.45	73.48	51540.0
2010-11-08 09:00:00	IWM	ETF	73.47	73.66	73.33	73.43	4072239.0
2010-11-08 10:00:00	IWM	ETF	73.42	73.76	73.3	73.35	7135837.0
2010-11-08 11:00:00	IWM	ETF	73.35	73.57	73.12	73.52	3154039.0
2010-11-08 12:00:00	IWM	ETF	73.53	73.7	73.48	73.64	1977790.0
2010-11-08 13:00:00	IWM	ETF	73.64	73.91	73.55	73.57	3411118.0
2010-11-08 14:00:00	IWM	ETF	73.56	73.72	73.56	73.6	2658302.0
2010-11-08 15:00:00	IWM	ETF	73.6	73.81	73.6	73.73	5563361.0
2010-11-08 16:00:00	IWM	ETF	73.72	73.7526	73.52	73.56	2114871.0
2010-11-08 17:00:00	IWM	ETF	73.53	73.57	73.53	73.54	800.0
2010-11-08 18:00:00	IWM	ETF	73.72	73.72	73.55	73.55	9633.0
2010-11-08 19:00:00	IWM	ETF	73.54	73.54	73.36	73.43	19500.0
2010-11-08 04:00:00	DIA	ETF	114.29	114.29	114.29	114.29	300.0
2010-11-08 05:00:00	DIA	ETF	114.05	114.05	113.99	113.99	3500.0
2010-11-08 06:00:00	DIA	ETF	114.07	114.07	114.07	114.07	500.0
2010-11-08 07:00:00	DIA	ETF	114.2	114.2	114.2	114.2	500.0

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

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