PREVIEW / etf_1hour / 2013-06-04

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-06-04.parquet
  size:    207 KB
  rows:    6,412

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
2013-06-04 04:00:00	SPY	ETF	164.1	164.28	164.04	164.04	13400.0
2013-06-04 05:00:00	SPY	ETF	164.08	164.16	164.0	164.13	55200.0
2013-06-04 06:00:00	SPY	ETF	164.16	164.32	164.01	164.21	98200.0
2013-06-04 07:00:00	SPY	ETF	164.21	164.29	164.06	164.16	114365.0
2013-06-04 08:00:00	SPY	ETF	164.19	164.6	164.08	164.42	774192.0
2013-06-04 09:00:00	SPY	ETF	164.4	165.01	164.29	164.85	14817673.0
2013-06-04 10:00:00	SPY	ETF	164.855	165.1	164.3691	164.37	18732881.0
2013-06-04 11:00:00	SPY	ETF	164.37	164.62	164.19	164.52	13193243.0
2013-06-04 12:00:00	SPY	ETF	164.511	164.89	163.82	164.05	15054224.0
2013-06-04 13:00:00	SPY	ETF	164.04	164.27	163.01	163.27	22680845.0
2013-06-04 14:00:00	SPY	ETF	163.27	163.59	162.73	163.31	26328384.0
2013-06-04 15:00:00	SPY	ETF	163.31	164.13	163.2	163.505	31404893.0
2013-06-04 16:00:00	SPY	ETF	163.51	164.4444	162.8	163.64	12532711.0
2013-06-04 17:00:00	SPY	ETF	163.64	163.65	163.51	163.51	657060.0
2013-06-04 18:00:00	SPY	ETF	163.51	163.66	163.43	163.63	61937.0
2013-06-04 19:00:00	SPY	ETF	163.62	163.63	163.53	163.59	32291.0
2013-06-04 04:00:00	QQQ	ETF	73.36	73.38	73.29	73.29	47200.0
2013-06-04 05:00:00	QQQ	ETF	73.28	73.35	73.28	73.35	3400.0
2013-06-04 06:00:00	QQQ	ETF	73.38	73.4	73.3	73.37	24700.0
2013-06-04 07:00:00	QQQ	ETF	73.37	73.4	73.32	73.38	8700.0
2013-06-04 08:00:00	QQQ	ETF	73.37	73.54	73.37	73.46	104262.0
2013-06-04 09:00:00	QQQ	ETF	73.47	73.74	73.43	73.7	3243053.0
2013-06-04 10:00:00	QQQ	ETF	73.7	73.82	73.54	73.54	5610234.0
2013-06-04 11:00:00	QQQ	ETF	73.54	73.7	73.41	73.64	2556076.0
2013-06-04 12:00:00	QQQ	ETF	73.63	73.645	73.27	73.37	2509897.0
2013-06-04 13:00:00	QQQ	ETF	73.37	73.425	72.88	72.9848	3907763.0
2013-06-04 14:00:00	QQQ	ETF	72.98	73.0201	72.7	72.92	5305678.0
2013-06-04 15:00:00	QQQ	ETF	72.9196	73.23	72.8	72.99	7567720.0
2013-06-04 16:00:00	QQQ	ETF	72.99	73.4124	72.9599	73.11	1949277.0
2013-06-04 17:00:00	QQQ	ETF	73.03	73.03	72.93	72.97	46500.0
2013-06-04 18:00:00	QQQ	ETF	72.93	73.04	72.91	73.02	13170.0
2013-06-04 19:00:00	QQQ	ETF	73.01	73.01	72.99	72.99	2600.0
2013-06-04 05:00:00	IWM	ETF	98.6	98.6	98.6	98.6	100.0
2013-06-04 06:00:00	IWM	ETF	98.48	98.59	98.48	98.55	1200.0
2013-06-04 07:00:00	IWM	ETF	98.6	98.62	98.5	98.57	50140.0
2013-06-04 08:00:00	IWM	ETF	98.58	98.86	98.57	98.78	369674.0
2013-06-04 09:00:00	IWM	ETF	98.77	99.2	98.52	98.83	4745205.0
2013-06-04 10:00:00	IWM	ETF	98.83	98.9	98.19	98.2	6190626.0
2013-06-04 11:00:00	IWM	ETF	98.19	98.5	97.975	98.32	5179823.0
2013-06-04 12:00:00	IWM	ETF	98.32	98.35	97.72	97.93	5192975.0
2013-06-04 13:00:00	IWM	ETF	97.93	98.01	97.18	97.32	7472432.0
2013-06-04 14:00:00	IWM	ETF	97.32	97.995	96.92	97.72	12033784.0
2013-06-04 15:00:00	IWM	ETF	97.71	98.04	97.405	97.68	13283793.0
2013-06-04 16:00:00	IWM	ETF	97.68	97.97	97.5891	97.79	2972746.0
2013-06-04 17:00:00	IWM	ETF	97.72	97.79	97.72	97.79	4000.0
2013-06-04 18:00:00	IWM	ETF	97.68	97.79	97.68	97.71	900.0
2013-06-04 19:00:00	IWM	ETF	97.78	97.78	97.78	97.78	286.0
2013-06-04 06:00:00	DIA	ETF	152.01	152.01	152.01	152.01	100.0
2013-06-04 07:00:00	DIA	ETF	152.08	152.08	152.08	152.08	1000.0
2013-06-04 08:00:00	DIA	ETF	152.2	152.3	152.19	152.3	7385.0

> showing 50 of 6,412 rows — these rows as CSV

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