PREVIEW / etf_1hour / 2013-09-11

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-09-11.parquet
  size:    208 KB
  rows:    6,501

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-09-11 04:00:00	SPY	ETF	168.64	168.88	168.64	168.88	3700.0
2013-09-11 05:00:00	SPY	ETF	168.85	168.85	168.64	168.64	2200.0
2013-09-11 06:00:00	SPY	ETF	168.68	168.84	168.67	168.78	48076.0
2013-09-11 07:00:00	SPY	ETF	168.76	168.84	168.57	168.59	336449.0
2013-09-11 08:00:00	SPY	ETF	168.59	168.8	168.57	168.68	730325.0
2013-09-11 09:00:00	SPY	ETF	168.68	168.84	168.43	168.49	11280592.0
2013-09-11 10:00:00	SPY	ETF	168.5	168.71	168.35	168.57	14212827.0
2013-09-11 11:00:00	SPY	ETF	168.57	169.13	168.57	169.03	10416607.0
2013-09-11 12:00:00	SPY	ETF	169.03	169.18	168.93	169.16	6743535.0
2013-09-11 13:00:00	SPY	ETF	169.151	169.31	169.05	169.24	9361017.0
2013-09-11 14:00:00	SPY	ETF	169.24	169.32	169.08	169.115	7471731.0
2013-09-11 15:00:00	SPY	ETF	169.12	169.4	168.99	169.4	19172143.0
2013-09-11 16:00:00	SPY	ETF	169.4	169.55	168.5244	169.54	10152042.0
2013-09-11 17:00:00	SPY	ETF	169.55	169.61	168.8787	169.56	532836.0
2013-09-11 18:00:00	SPY	ETF	169.55	169.55	169.0754	169.47	129085.0
2013-09-11 19:00:00	SPY	ETF	169.5	169.54	169.42	169.45	120660.0
2013-09-11 05:00:00	QQQ	ETF	78.03	78.03	78.03	78.03	100.0
2013-09-11 06:00:00	QQQ	ETF	77.98	78.05	77.98	78.03	10278.0
2013-09-11 07:00:00	QQQ	ETF	78.02	78.02	77.79	77.83	120720.0
2013-09-11 08:00:00	QQQ	ETF	77.83	77.88	77.8	77.86	220890.0
2013-09-11 09:00:00	QQQ	ETF	77.86	77.93	77.67	77.7	4614216.0
2013-09-11 10:00:00	QQQ	ETF	77.7	77.87	77.59	77.73	4227594.0
2013-09-11 11:00:00	QQQ	ETF	77.74	77.96	77.7201	77.9	3758364.0
2013-09-11 12:00:00	QQQ	ETF	77.9	78.01	77.87	78.0	3395828.0
2013-09-11 13:00:00	QQQ	ETF	77.99	78.09	77.91	78.04	2836694.0
2013-09-11 14:00:00	QQQ	ETF	78.03	78.11	77.96	78.03	2123342.0
2013-09-11 15:00:00	QQQ	ETF	78.02	78.08	77.91	78.07	4114394.0
2013-09-11 16:00:00	QQQ	ETF	78.08	78.17	77.9799	78.17	839866.0
2013-09-11 17:00:00	QQQ	ETF	78.17	78.25	77.8392	78.25	275811.0
2013-09-11 18:00:00	QQQ	ETF	78.2	78.2	78.13	78.13	2963.0
2013-09-11 19:00:00	QQQ	ETF	78.14	78.14	78.1	78.1	2400.0
2013-09-11 07:00:00	IWM	ETF	104.91	104.91	104.74	104.74	6600.0
2013-09-11 08:00:00	IWM	ETF	104.75	104.83	104.7	104.83	171568.0
2013-09-11 09:00:00	IWM	ETF	104.82	105.0	104.535	104.602	2429287.0
2013-09-11 10:00:00	IWM	ETF	104.61	104.81	104.55	104.68	3713942.0
2013-09-11 11:00:00	IWM	ETF	104.68	105.11	104.68	105.01	2978796.0
2013-09-11 12:00:00	IWM	ETF	105.0	105.16	104.96	105.12	2081220.0
2013-09-11 13:00:00	IWM	ETF	105.13	105.22	105.0	105.0805	2899673.0
2013-09-11 14:00:00	IWM	ETF	105.0897	105.12	104.8	104.84	4328164.0
2013-09-11 15:00:00	IWM	ETF	104.84	104.99	104.71	104.98	4519638.0
2013-09-11 16:00:00	IWM	ETF	104.98	105.09	104.8801	105.08	899029.0
2013-09-11 17:00:00	IWM	ETF	105.1	105.14	104.8849	105.14	362641.0
2013-09-11 18:00:00	IWM	ETF	105.07	105.07	105.07	105.07	320.0
2013-09-11 19:00:00	IWM	ETF	105.02	105.02	105.02	105.02	600.0
2013-09-11 04:00:00	DIA	ETF	151.7	151.7	151.68	151.68	16500.0
2013-09-11 07:00:00	DIA	ETF	151.7	151.7	151.67	151.67	600.0
2013-09-11 08:00:00	DIA	ETF	151.73	151.75	151.67	151.75	1930.0
2013-09-11 09:00:00	DIA	ETF	151.73	152.2	151.63	152.1	862027.0
2013-09-11 10:00:00	DIA	ETF	152.1	152.33	152.1	152.24	1095995.0
2013-09-11 11:00:00	DIA	ETF	152.26	152.75	152.23	152.68	727357.0

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

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