PREVIEW / etf_1hour / 2011-03-09

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-03-09.parquet
  size:    171 KB
  rows:    5,244

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
2011-03-09 04:00:00	SPY	ETF	132.25	132.65	132.25	132.55	2200.0
2011-03-09 05:00:00	SPY	ETF	132.62	132.62	132.48	132.59	5600.0
2011-03-09 06:00:00	SPY	ETF	132.69	132.93	132.68	132.77	47050.0
2011-03-09 07:00:00	SPY	ETF	132.73	132.84	132.48	132.74	421195.0
2011-03-09 08:00:00	SPY	ETF	132.72	132.76	132.32	132.36	1351308.0
2011-03-09 09:00:00	SPY	ETF	132.35	132.42	131.75	132.05	20918243.0
2011-03-09 10:00:00	SPY	ETF	132.04	132.67	131.71	131.815	31998716.0
2011-03-09 11:00:00	SPY	ETF	131.8	132.53	131.6	132.43	23965423.0
2011-03-09 12:00:00	SPY	ETF	132.44	132.8	132.28	132.43	19037474.0
2011-03-09 13:00:00	SPY	ETF	132.43	132.6	132.17	132.31	12997465.0
2011-03-09 14:00:00	SPY	ETF	132.31	132.59	132.11	132.41	14650414.0
2011-03-09 15:00:00	SPY	ETF	132.4	132.59	132.22	132.39	21208210.0
2011-03-09 16:00:00	SPY	ETF	132.39	132.62	131.97	131.99	6592322.0
2011-03-09 17:00:00	SPY	ETF	132.04	132.09	131.96	131.99	347478.0
2011-03-09 18:00:00	SPY	ETF	132.0	132.42	131.93	131.96	88718.0
2011-03-09 19:00:00	SPY	ETF	131.95	132.05	131.92	132.02	74753.0
2011-03-09 04:00:00	QQQ	ETF	57.35	57.35	57.3	57.32	4700.0
2011-03-09 05:00:00	QQQ	ETF	57.29	57.29	57.26	57.26	1100.0
2011-03-09 06:00:00	QQQ	ETF	57.39	57.5	57.39	57.43	10216.0
2011-03-09 07:00:00	QQQ	ETF	57.41	57.46	57.27	57.42	77556.0
2011-03-09 08:00:00	QQQ	ETF	57.39	57.42	57.21	57.25	390001.0
2011-03-09 09:00:00	QQQ	ETF	57.22	57.26	56.72	56.96	15580789.0
2011-03-09 10:00:00	QQQ	ETF	56.96	57.27	56.8	56.85	14692603.0
2011-03-09 11:00:00	QQQ	ETF	56.84	57.145	56.75	57.1	10090168.0
2011-03-09 12:00:00	QQQ	ETF	57.11	57.24	56.98	57.05	5565791.0
2011-03-09 13:00:00	QQQ	ETF	57.05	57.1	56.8512	56.9162	4795248.0
2011-03-09 14:00:00	QQQ	ETF	56.9188	57.17	56.91	57.11	12278172.0
2011-03-09 15:00:00	QQQ	ETF	57.11	57.1899	56.96	57.03	7717004.0
2011-03-09 16:00:00	QQQ	ETF	57.02	57.06	56.8	56.84	2524405.0
2011-03-09 17:00:00	QQQ	ETF	56.84	56.86	56.83	56.86	32916.0
2011-03-09 18:00:00	QQQ	ETF	56.86	57.06	56.81	56.81	46427.0
2011-03-09 19:00:00	QQQ	ETF	56.81	56.85	56.8	56.8	30343.0
2011-03-09 04:00:00	IWM	ETF	82.6	82.6	82.35	82.35	200.0
2011-03-09 06:00:00	IWM	ETF	82.64	82.76	82.64	82.76	5400.0
2011-03-09 07:00:00	IWM	ETF	82.64	82.68	82.41	82.6	26610.0
2011-03-09 08:00:00	IWM	ETF	82.58	82.61	82.27	82.38	300040.0
2011-03-09 09:00:00	IWM	ETF	82.32	82.39	81.75	81.99	7074909.0
2011-03-09 10:00:00	IWM	ETF	82.0	82.51	81.79	81.9075	9855410.0
2011-03-09 11:00:00	IWM	ETF	81.9	82.48	81.7799	82.4	6638123.0
2011-03-09 12:00:00	IWM	ETF	82.4	82.58	82.15	82.2	4234729.0
2011-03-09 13:00:00	IWM	ETF	82.2013	82.34	82.06	82.12	2806048.0
2011-03-09 14:00:00	IWM	ETF	82.11	82.28	81.94	82.22	5380591.0
2011-03-09 15:00:00	IWM	ETF	82.22	82.35	82.035	82.07	6315271.0
2011-03-09 16:00:00	IWM	ETF	82.06	82.4139	81.79	81.81	2739976.0
2011-03-09 17:00:00	IWM	ETF	81.82	82.08	81.8	81.87	58945.0
2011-03-09 18:00:00	IWM	ETF	81.9	81.94	81.89	81.9	2495.0
2011-03-09 19:00:00	IWM	ETF	81.87	81.87	81.82	81.86	4000.0
2011-03-09 07:00:00	DIA	ETF	122.31	122.31	122.1	122.1	4200.0
2011-03-09 08:00:00	DIA	ETF	122.18	122.22	121.9	121.95	14227.0
2011-03-09 09:00:00	DIA	ETF	121.89	121.99	121.45	121.72	1223186.0

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

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