PREVIEW / etf_1hour / 2012-02-09

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-02-09.parquet
  size:    186 KB
  rows:    5,762

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
2012-02-09 04:00:00	SPY	ETF	135.12	135.33	135.02	135.04	23240.0
2012-02-09 05:00:00	SPY	ETF	135.05	135.05	134.87	134.91	15755.0
2012-02-09 06:00:00	SPY	ETF	134.97	135.0	134.79	134.82	19150.0
2012-02-09 07:00:00	SPY	ETF	134.84	135.04	134.76	135.01	265742.0
2012-02-09 08:00:00	SPY	ETF	135.01	135.71	134.93	135.3	5555877.0
2012-02-09 09:00:00	SPY	ETF	135.3	135.49	135.07	135.3	22654990.0
2012-02-09 10:00:00	SPY	ETF	135.3	135.39	134.56	134.99	36533981.0
2012-02-09 11:00:00	SPY	ETF	134.99	135.28	134.83	135.26	19447416.0
2012-02-09 12:00:00	SPY	ETF	135.27	135.45	135.21	135.419	12996048.0
2012-02-09 13:00:00	SPY	ETF	135.41	135.59	135.3	135.4603	15150263.0
2012-02-09 14:00:00	SPY	ETF	135.465	135.56	135.4	135.4183	9286259.0
2012-02-09 15:00:00	SPY	ETF	135.41	135.53	135.25	135.35	19015129.0
2012-02-09 16:00:00	SPY	ETF	135.35	135.42	135.1259	135.23	6980531.0
2012-02-09 17:00:00	SPY	ETF	135.22	135.22	135.13	135.14	270852.0
2012-02-09 18:00:00	SPY	ETF	135.15	135.36	135.07	135.14	122868.0
2012-02-09 19:00:00	SPY	ETF	135.11	135.14	135.02	135.09	172049.0
2012-02-09 04:00:00	QQQ	ETF	62.45	62.51	62.45	62.51	600.0
2012-02-09 05:00:00	QQQ	ETF	62.4	62.4	62.37	62.37	5400.0
2012-02-09 06:00:00	QQQ	ETF	62.41	62.41	62.35	62.36	3325.0
2012-02-09 07:00:00	QQQ	ETF	62.35	62.45	62.34	62.41	56245.0
2012-02-09 08:00:00	QQQ	ETF	62.41	62.67	62.4	62.56	731113.0
2012-02-09 09:00:00	QQQ	ETF	62.58	62.74	62.45	62.6	6558509.0
2012-02-09 10:00:00	QQQ	ETF	62.6	62.67	62.32	62.62	10777615.0
2012-02-09 11:00:00	QQQ	ETF	62.62	62.81	62.59	62.79	6026066.0
2012-02-09 12:00:00	QQQ	ETF	62.79	62.93	62.79	62.88	3831444.0
2012-02-09 13:00:00	QQQ	ETF	62.88	62.97	62.8	62.898	3938527.0
2012-02-09 14:00:00	QQQ	ETF	62.89	62.965	62.85	62.91	2589556.0
2012-02-09 15:00:00	QQQ	ETF	62.91	62.98	62.85	62.91	6876688.0
2012-02-09 16:00:00	QQQ	ETF	62.91	62.95	62.86	62.86	973920.0
2012-02-09 17:00:00	QQQ	ETF	62.87	62.89	62.85	62.85	26129.0
2012-02-09 18:00:00	QQQ	ETF	62.87	62.91	62.82	62.87	28998.0
2012-02-09 19:00:00	QQQ	ETF	62.86	62.87	62.82	62.85	10175.0
2012-02-09 06:00:00	IWM	ETF	82.67	82.67	82.53	82.53	795.0
2012-02-09 07:00:00	IWM	ETF	82.55	82.65	82.54	82.64	53622.0
2012-02-09 08:00:00	IWM	ETF	82.68	83.13	82.66	82.97	638947.0
2012-02-09 09:00:00	IWM	ETF	82.96	83.04	82.37	82.53	6044936.0
2012-02-09 10:00:00	IWM	ETF	82.52	82.55	81.84	82.29	12167577.0
2012-02-09 11:00:00	IWM	ETF	82.3	82.41	82.08	82.335	5930697.0
2012-02-09 12:00:00	IWM	ETF	82.35	82.51	82.2	82.32	2649149.0
2012-02-09 13:00:00	IWM	ETF	82.32	82.6	82.19	82.535	3985605.0
2012-02-09 14:00:00	IWM	ETF	82.55	82.63	82.44	82.48	3609595.0
2012-02-09 15:00:00	IWM	ETF	82.48	82.62	82.29	82.37	5663371.0
2012-02-09 16:00:00	IWM	ETF	82.37	82.46	82.3128	82.39	4258697.0
2012-02-09 17:00:00	IWM	ETF	82.4	82.4	82.35	82.35	54100.0
2012-02-09 18:00:00	IWM	ETF	82.3	82.3	82.3	82.3	3100.0
2012-02-09 19:00:00	IWM	ETF	82.2	82.2	82.2	82.2	1250.0
2012-02-09 07:00:00	DIA	ETF	128.45	128.6	128.45	128.59	3000.0
2012-02-09 08:00:00	DIA	ETF	128.61	129.19	128.61	128.91	60407.0
2012-02-09 09:00:00	DIA	ETF	128.85	129.12	128.77	129.02	652651.0
2012-02-09 10:00:00	DIA	ETF	129.04	129.09	128.305	128.63	1579026.0

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

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