PREVIEW / etf_1hour / 2013-08-08

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-08-08.parquet
  size:    206 KB
  rows:    6,425

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-08-08 04:00:00	SPY	ETF	169.43	169.65	169.42	169.64	9100.0
2013-08-08 05:00:00	SPY	ETF	169.59	169.68	169.53	169.65	1600.0
2013-08-08 06:00:00	SPY	ETF	169.61	169.9	169.61	169.89	91600.0
2013-08-08 07:00:00	SPY	ETF	169.9	170.03	169.86	169.91	302392.0
2013-08-08 08:00:00	SPY	ETF	169.9	170.0	169.81	169.91	627766.0
2013-08-08 09:00:00	SPY	ETF	169.91	170.18	169.69	169.83	11635800.0
2013-08-08 10:00:00	SPY	ETF	169.83	169.88	168.93	169.1901	17566043.0
2013-08-08 11:00:00	SPY	ETF	169.19	169.5	169.09	169.47	10501137.0
2013-08-08 12:00:00	SPY	ETF	169.47	170.05	169.47	169.96	11446207.0
2013-08-08 13:00:00	SPY	ETF	169.96	170.13	169.88	170.02	7953646.0
2013-08-08 14:00:00	SPY	ETF	170.02	170.16	169.92	170.01	11928173.0
2013-08-08 15:00:00	SPY	ETF	170.01	170.07	169.79	169.79	12746508.0
2013-08-08 16:00:00	SPY	ETF	169.79	169.94	169.2133	169.9	12653719.0
2013-08-08 17:00:00	SPY	ETF	169.9	169.91	169.2133	169.87	2042226.0
2013-08-08 18:00:00	SPY	ETF	169.85	169.93	169.81	169.84	208406.0
2013-08-08 19:00:00	SPY	ETF	169.85	169.9	169.72	169.76	32865.0
2013-08-08 04:00:00	QQQ	ETF	76.59	76.72	76.59	76.72	12200.0
2013-08-08 05:00:00	QQQ	ETF	76.7	76.74	76.7	76.72	3600.0
2013-08-08 06:00:00	QQQ	ETF	76.7	76.8	76.7	76.8	4800.0
2013-08-08 07:00:00	QQQ	ETF	76.82	76.85	76.8	76.82	47755.0
2013-08-08 08:00:00	QQQ	ETF	76.82	76.85	76.66	76.81	67130.0
2013-08-08 09:00:00	QQQ	ETF	76.81	76.91	76.61	76.67	1886863.0
2013-08-08 10:00:00	QQQ	ETF	76.67	76.68	76.3	76.5409	3847048.0
2013-08-08 11:00:00	QQQ	ETF	76.54	76.815	76.53	76.81	2675324.0
2013-08-08 12:00:00	QQQ	ETF	76.81	76.98	76.809	76.895	2764302.0
2013-08-08 13:00:00	QQQ	ETF	76.9	76.96	76.86	76.93	1938614.0
2013-08-08 14:00:00	QQQ	ETF	76.93	76.965	76.79	76.85	1508239.0
2013-08-08 15:00:00	QQQ	ETF	76.84	76.9	76.78	76.79	3151747.0
2013-08-08 16:00:00	QQQ	ETF	76.79	76.9154	76.3733	76.82	1072464.0
2013-08-08 17:00:00	QQQ	ETF	76.83	76.83	76.8	76.83	12040.0
2013-08-08 18:00:00	QQQ	ETF	76.83	76.83	76.78	76.78	42200.0
2013-08-08 19:00:00	QQQ	ETF	76.85	76.85	76.77	76.78	16420.0
2013-08-08 07:00:00	IWM	ETF	104.3	104.41	104.3	104.35	113204.0
2013-08-08 08:00:00	IWM	ETF	104.35	104.41	104.09	104.23	190467.0
2013-08-08 09:00:00	IWM	ETF	104.22	104.6	104.01	104.16	3556257.0
2013-08-08 10:00:00	IWM	ETF	104.16	104.19	103.585	103.86	3907225.0
2013-08-08 11:00:00	IWM	ETF	103.86	104.13	103.77	104.095	2949123.0
2013-08-08 12:00:00	IWM	ETF	104.09	104.29	104.03	104.1675	2350850.0
2013-08-08 13:00:00	IWM	ETF	104.17	104.26	104.0	104.1299	1533588.0
2013-08-08 14:00:00	IWM	ETF	104.125	104.38	104.11	104.31	4337084.0
2013-08-08 15:00:00	IWM	ETF	104.31	104.35	104.11	104.11	5655624.0
2013-08-08 16:00:00	IWM	ETF	104.1	104.1756	103.8	104.16	1136978.0
2013-08-08 17:00:00	IWM	ETF	104.19	104.19	104.16	104.16	20100.0
2013-08-08 19:00:00	IWM	ETF	104.04	104.15	104.03	104.14	1500.0
2013-08-08 06:00:00	DIA	ETF	155.03	155.03	155.03	155.03	1900.0
2013-08-08 07:00:00	DIA	ETF	155.27	155.27	155.27	155.27	100.0
2013-08-08 08:00:00	DIA	ETF	155.34	155.34	155.24	155.26	10390.0
2013-08-08 09:00:00	DIA	ETF	155.22	155.45	154.84	154.93	800612.0
2013-08-08 10:00:00	DIA	ETF	154.94	154.98	153.9899	154.15	902574.0
2013-08-08 11:00:00	DIA	ETF	154.16	154.44	154.0919	154.42	428037.0

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

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