PREVIEW / etf_1hour / 2011-07-25

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-07-25.parquet
  size:    181 KB
  rows:    5,632

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-07-25 04:00:00	SPY	ETF	133.74	133.74	133.38	133.7	11130.0
2011-07-25 05:00:00	SPY	ETF	133.69	133.69	133.55	133.61	2250.0
2011-07-25 06:00:00	SPY	ETF	133.67	133.67	133.28	133.51	46415.0
2011-07-25 07:00:00	SPY	ETF	133.51	133.68	133.49	133.56	1100910.0
2011-07-25 08:00:00	SPY	ETF	133.56	134.61	133.2	133.5	2010275.0
2011-07-25 09:00:00	SPY	ETF	133.51	134.59	133.16	133.68	20695605.0
2011-07-25 10:00:00	SPY	ETF	133.68	134.15	133.65	133.91	26659549.0
2011-07-25 11:00:00	SPY	ETF	133.915	134.24	133.81	134.1	14489148.0
2011-07-25 12:00:00	SPY	ETF	134.11	134.43	134.06	134.32	9505809.0
2011-07-25 13:00:00	SPY	ETF	134.32	134.49	134.21	134.2275	10462299.0
2011-07-25 14:00:00	SPY	ETF	134.23	134.44	134.05	134.11	14155420.0
2011-07-25 15:00:00	SPY	ETF	134.11	134.13	133.77	133.84	27273630.0
2011-07-25 16:00:00	SPY	ETF	133.85	134.17	133.72	133.82	8842593.0
2011-07-25 17:00:00	SPY	ETF	133.83	133.9	133.74	133.88	119486.0
2011-07-25 18:00:00	SPY	ETF	133.82	133.87	133.58	133.63	440542.0
2011-07-25 19:00:00	SPY	ETF	133.63	133.7	133.6	133.69	79799.0
2011-07-25 04:00:00	QQQ	ETF	59.32	59.32	59.3	59.3	400.0
2011-07-25 05:00:00	QQQ	ETF	59.38	59.38	59.3	59.3	3300.0
2011-07-25 06:00:00	QQQ	ETF	59.28	59.29	59.23	59.29	2600.0
2011-07-25 07:00:00	QQQ	ETF	59.29	59.4	59.27	59.29	75383.0
2011-07-25 08:00:00	QQQ	ETF	59.3	59.35	59.24	59.25	250923.0
2011-07-25 09:00:00	QQQ	ETF	59.26	59.38	59.02	59.36	8649504.0
2011-07-25 10:00:00	QQQ	ETF	59.35	59.57	59.305	59.4297	12351763.0
2011-07-25 11:00:00	QQQ	ETF	59.42	59.66	59.3801	59.59	4575847.0
2011-07-25 12:00:00	QQQ	ETF	59.59	59.81	59.57	59.76	4215831.0
2011-07-25 13:00:00	QQQ	ETF	59.76	59.8	59.64	59.66	2975875.0
2011-07-25 14:00:00	QQQ	ETF	59.66	59.7787	59.6	59.601	3548893.0
2011-07-25 15:00:00	QQQ	ETF	59.61	59.61	59.415	59.48	9472572.0
2011-07-25 16:00:00	QQQ	ETF	59.49	59.65	59.48	59.59	1021734.0
2011-07-25 17:00:00	QQQ	ETF	59.58	59.63	59.53	59.53	77542.0
2011-07-25 18:00:00	QQQ	ETF	59.54	59.57	59.47	59.48	27038.0
2011-07-25 19:00:00	QQQ	ETF	59.47	59.58	59.47	59.58	22792.0
2011-07-25 04:00:00	IWM	ETF	83.2	83.21	83.05	83.05	2407.0
2011-07-25 05:00:00	IWM	ETF	83.22	83.25	83.14	83.14	350.0
2011-07-25 06:00:00	IWM	ETF	83.09	83.09	83.09	83.09	300.0
2011-07-25 07:00:00	IWM	ETF	83.27	83.27	83.17	83.17	34200.0
2011-07-25 08:00:00	IWM	ETF	83.18	83.3	83.17	83.23	287987.0
2011-07-25 09:00:00	IWM	ETF	83.21	83.5	82.75	83.46	10644157.0
2011-07-25 10:00:00	IWM	ETF	83.46	83.759	83.3	83.47	10903855.0
2011-07-25 11:00:00	IWM	ETF	83.47	83.71	83.43	83.56	3177504.0
2011-07-25 12:00:00	IWM	ETF	83.56	83.72	83.52	83.67	2388929.0
2011-07-25 13:00:00	IWM	ETF	83.67	83.74	83.55	83.57	1912837.0
2011-07-25 14:00:00	IWM	ETF	83.57	83.7	83.4	83.41	3060424.0
2011-07-25 15:00:00	IWM	ETF	83.4121	83.43	83.02	83.05	10579926.0
2011-07-25 16:00:00	IWM	ETF	83.06	84.1	83.06	83.13	2195927.0
2011-07-25 17:00:00	IWM	ETF	83.18	83.26	83.18	83.24	8434.0
2011-07-25 18:00:00	IWM	ETF	83.21	83.24	83.12	83.16	14459.0
2011-07-25 19:00:00	IWM	ETF	83.09	83.15	83.09	83.15	2300.0
2011-07-25 04:00:00	DIA	ETF	125.7	125.7	125.45	125.45	307.0
2011-07-25 05:00:00	DIA	ETF	125.59	125.59	125.59	125.59	100.0

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

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