PREVIEW / etf_1hour / 2013-10-22

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-10-22.parquet
  size:    214 KB
  rows:    6,733

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-10-22 04:00:00	SPY	ETF	174.27	174.31	174.2	174.27	3300.0
2013-10-22 05:00:00	SPY	ETF	174.26	174.26	174.21	174.21	11163.0
2013-10-22 06:00:00	SPY	ETF	174.24	174.26	174.18	174.24	25787.0
2013-10-22 07:00:00	SPY	ETF	174.23	174.4	174.21	174.3	115375.0
2013-10-22 08:00:00	SPY	ETF	174.31	175.0	174.3	174.78	2309347.0
2013-10-22 09:00:00	SPY	ETF	174.78	175.46	174.78	175.39	13836503.0
2013-10-22 10:00:00	SPY	ETF	175.39	175.93	174.66	175.06	30847625.0
2013-10-22 11:00:00	SPY	ETF	175.05	175.36	174.81	175.36	16822493.0
2013-10-22 12:00:00	SPY	ETF	175.36	175.39	174.94	175.11	7904541.0
2013-10-22 13:00:00	SPY	ETF	175.1	175.44	175.04	175.379	9667490.0
2013-10-22 14:00:00	SPY	ETF	175.3794	175.64	175.15	175.48	13514523.0
2013-10-22 15:00:00	SPY	ETF	175.48	175.81	175.34	175.43	20999329.0
2013-10-22 16:00:00	SPY	ETF	175.41	175.5	174.4262	175.46	5248402.0
2013-10-22 17:00:00	SPY	ETF	175.46	175.5	175.42	175.45	40323.0
2013-10-22 18:00:00	SPY	ETF	175.42	175.42	175.24	175.27	112537.0
2013-10-22 19:00:00	SPY	ETF	175.3	175.34	175.29	175.32	14059.0
2013-10-22 04:00:00	QQQ	ETF	82.37	82.37	82.35	82.37	3600.0
2013-10-22 05:00:00	QQQ	ETF	82.36	82.36	82.35	82.36	41500.0
2013-10-22 06:00:00	QQQ	ETF	82.37	82.37	82.36	82.36	1100.0
2013-10-22 07:00:00	QQQ	ETF	82.37	82.42	82.35	82.35	36700.0
2013-10-22 08:00:00	QQQ	ETF	82.35	82.69	82.35	82.6	285687.0
2013-10-22 09:00:00	QQQ	ETF	82.61	82.77	82.59	82.6799	4840708.0
2013-10-22 10:00:00	QQQ	ETF	82.6799	82.9	81.93	82.27	12531938.0
2013-10-22 11:00:00	QQQ	ETF	82.27	82.54	82.07	82.52	7017436.0
2013-10-22 12:00:00	QQQ	ETF	82.53	82.5501	82.185	82.3	2709855.0
2013-10-22 13:00:00	QQQ	ETF	82.28	82.5	82.26	82.47	2850528.0
2013-10-22 14:00:00	QQQ	ETF	82.46	82.57	82.19	82.42	4663775.0
2013-10-22 15:00:00	QQQ	ETF	82.42	82.65	82.39	82.42	5552599.0
2013-10-22 16:00:00	QQQ	ETF	82.42	82.56	82.156	82.56	2213907.0
2013-10-22 17:00:00	QQQ	ETF	82.43	82.43	82.42	82.42	800.0
2013-10-22 18:00:00	QQQ	ETF	82.42	82.42	82.3	82.31	23570.0
2013-10-22 19:00:00	QQQ	ETF	82.31	82.35	82.31	82.33	10163.0
2013-10-22 07:00:00	IWM	ETF	110.43	110.44	110.43	110.43	25100.0
2013-10-22 08:00:00	IWM	ETF	110.35	110.85	110.31	110.76	310027.0
2013-10-22 09:00:00	IWM	ETF	110.82	111.36	110.82	111.3	4065527.0
2013-10-22 10:00:00	IWM	ETF	111.3	111.49	110.3801	110.73	9218536.0
2013-10-22 11:00:00	IWM	ETF	110.72	110.915	110.47	110.905	4706628.0
2013-10-22 12:00:00	IWM	ETF	110.91	110.92	110.37	110.525	3329642.0
2013-10-22 13:00:00	IWM	ETF	110.52	110.85	110.465	110.79	2811810.0
2013-10-22 14:00:00	IWM	ETF	110.79	110.85	110.58	110.72	2846516.0
2013-10-22 15:00:00	IWM	ETF	110.73	111.0	110.68	110.75	7441099.0
2013-10-22 16:00:00	IWM	ETF	110.75	110.776	110.4636	110.7	1865000.0
2013-10-22 17:00:00	IWM	ETF	110.7	110.7	110.66	110.69	2800.0
2013-10-22 18:00:00	IWM	ETF	110.66	110.66	110.47	110.47	11600.0
2013-10-22 19:00:00	IWM	ETF	110.57	110.57	110.57	110.57	532.0
2013-10-22 08:00:00	DIA	ETF	153.71	154.04	153.38	153.86	18979.0
2013-10-22 09:00:00	DIA	ETF	154.0	154.4	153.82	154.32	1016917.0
2013-10-22 10:00:00	DIA	ETF	154.34	154.86	153.9	154.16	2096865.0
2013-10-22 11:00:00	DIA	ETF	154.15	154.27	154.0	154.26	953849.0
2013-10-22 12:00:00	DIA	ETF	154.265	154.29	153.86	153.98	723093.0

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

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