PREVIEW / etf_1hour / 2011-03-31

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-03-31.parquet
  size:    178 KB
  rows:    5,507

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-31 04:00:00	SPY	ETF	132.72	132.95	132.72	132.95	1200.0
2011-03-31 05:00:00	SPY	ETF	132.95	132.95	132.85	132.87	11900.0
2011-03-31 06:00:00	SPY	ETF	132.84	132.84	132.66	132.75	36257.0
2011-03-31 07:00:00	SPY	ETF	132.75	132.88	132.6	132.72	645866.0
2011-03-31 08:00:00	SPY	ETF	132.72	132.96	132.51	132.64	1396075.0
2011-03-31 09:00:00	SPY	ETF	132.64	132.94	132.48	132.67	17650295.0
2011-03-31 10:00:00	SPY	ETF	132.67	132.96	132.49	132.87	18318349.0
2011-03-31 11:00:00	SPY	ETF	132.87	132.895	132.45	132.61	14858928.0
2011-03-31 12:00:00	SPY	ETF	132.6	132.92	132.58	132.89	11545682.0
2011-03-31 13:00:00	SPY	ETF	132.89	132.95	132.82	132.829	7310049.0
2011-03-31 14:00:00	SPY	ETF	132.83	132.96	132.73	132.88	10013139.0
2011-03-31 15:00:00	SPY	ETF	132.88	132.88	132.54	132.57	33645366.0
2011-03-31 16:00:00	SPY	ETF	132.57	132.8872	132.44	132.58	13270742.0
2011-03-31 17:00:00	SPY	ETF	132.57	132.61	132.5	132.58	267319.0
2011-03-31 18:00:00	SPY	ETF	132.58	132.64	132.5	132.59	94372.0
2011-03-31 19:00:00	SPY	ETF	132.61	132.82	132.51	132.7	123746.0
2011-03-31 05:00:00	QQQ	ETF	57.41	57.41	57.41	57.41	204.0
2011-03-31 06:00:00	QQQ	ETF	57.4	57.4	57.29	57.3	12087.0
2011-03-31 07:00:00	QQQ	ETF	57.28	57.32	57.28	57.29	97217.0
2011-03-31 08:00:00	QQQ	ETF	57.34	57.42	57.11	57.29	310995.0
2011-03-31 09:00:00	QQQ	ETF	57.28	57.45	57.21	57.28	6509841.0
2011-03-31 10:00:00	QQQ	ETF	57.275	57.43	57.15	57.41	7595024.0
2011-03-31 11:00:00	QQQ	ETF	57.41	57.43	57.16	57.21	3900620.0
2011-03-31 12:00:00	QQQ	ETF	57.21	57.36	57.205	57.34	1877964.0
2011-03-31 13:00:00	QQQ	ETF	57.34	57.42	57.335	57.35	2008567.0
2011-03-31 14:00:00	QQQ	ETF	57.3499	57.46	57.34	57.425	3678605.0
2011-03-31 15:00:00	QQQ	ETF	57.42	57.48	57.35	57.42	7132454.0
2011-03-31 16:00:00	QQQ	ETF	57.42	57.5	57.35	57.42	4534200.0
2011-03-31 17:00:00	QQQ	ETF	57.4	57.42	57.36	57.36	116738.0
2011-03-31 18:00:00	QQQ	ETF	57.4	57.44	57.4	57.42	11583.0
2011-03-31 19:00:00	QQQ	ETF	57.4	57.59	57.39	57.59	129038.0
2011-03-31 05:00:00	IWM	ETF	83.98	83.98	83.98	83.98	300.0
2011-03-31 06:00:00	IWM	ETF	83.91	83.91	83.79	83.8	1000.0
2011-03-31 07:00:00	IWM	ETF	83.8	83.83	83.72	83.8	50100.0
2011-03-31 08:00:00	IWM	ETF	83.81	83.93	83.67	83.77	263030.0
2011-03-31 09:00:00	IWM	ETF	83.76	84.05	83.66	83.8671	4894200.0
2011-03-31 10:00:00	IWM	ETF	83.86	84.1	83.7	84.04	5740294.0
2011-03-31 11:00:00	IWM	ETF	84.04	84.06	83.72	83.85	3530864.0
2011-03-31 12:00:00	IWM	ETF	83.8481	84.04	83.83	84.01	2178187.0
2011-03-31 13:00:00	IWM	ETF	84.02	84.12	83.99	84.0799	2067969.0
2011-03-31 14:00:00	IWM	ETF	84.0701	84.22	84.05	84.1999	3772773.0
2011-03-31 15:00:00	IWM	ETF	84.19	84.29	84.06	84.15	9851952.0
2011-03-31 16:00:00	IWM	ETF	84.15	84.35	84.15	84.28	2595613.0
2011-03-31 17:00:00	IWM	ETF	84.28	84.28	84.24	84.24	33601.0
2011-03-31 18:00:00	IWM	ETF	84.26	84.29	84.24	84.29	2400.0
2011-03-31 19:00:00	IWM	ETF	84.29	84.39	84.25	84.38	7400.0
2011-03-31 07:00:00	DIA	ETF	123.32	123.36	123.21	123.21	16000.0
2011-03-31 08:00:00	DIA	ETF	123.28	123.28	123.1	123.22	100131.0
2011-03-31 09:00:00	DIA	ETF	123.18	123.48	123.11	123.2901	584980.0
2011-03-31 10:00:00	DIA	ETF	123.29	123.56	123.17	123.44	630105.0

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

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