PREVIEW / etf_1hour / 2013-10-04

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-10-04.parquet
  size:    202 KB
  rows:    6,237

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-04 04:00:00	SPY	ETF	167.65	167.92	167.56	167.87	63723.0
2013-10-04 05:00:00	SPY	ETF	167.86	167.93	167.84	167.9	32598.0
2013-10-04 06:00:00	SPY	ETF	167.88	167.94	167.85	167.92	38403.0
2013-10-04 07:00:00	SPY	ETF	167.91	168.0	167.78	167.87	190466.0
2013-10-04 08:00:00	SPY	ETF	167.84	168.03	167.67	167.89	613736.0
2013-10-04 09:00:00	SPY	ETF	167.87	168.27	167.53	168.15	11649864.0
2013-10-04 10:00:00	SPY	ETF	168.19	168.65	168.08	168.26	16691902.0
2013-10-04 11:00:00	SPY	ETF	168.265	168.47	167.97	168.4	13127949.0
2013-10-04 12:00:00	SPY	ETF	168.4	168.89	168.35	168.75	10979327.0
2013-10-04 13:00:00	SPY	ETF	168.75	168.83	168.615	168.64	7834376.0
2013-10-04 14:00:00	SPY	ETF	168.64	169.045	168.64	168.97	7760073.0
2013-10-04 15:00:00	SPY	ETF	168.9638	169.06	168.65	168.86	17639814.0
2013-10-04 16:00:00	SPY	ETF	168.86	168.98	168.61	168.76	8590807.0
2013-10-04 17:00:00	SPY	ETF	168.76	168.76	168.5506	168.66	399791.0
2013-10-04 18:00:00	SPY	ETF	168.7	168.76	168.7	168.75	4188.0
2013-10-04 19:00:00	SPY	ETF	168.75	168.91	168.7	168.84	20540.0
2013-10-04 04:00:00	QQQ	ETF	78.73	78.86	78.66	78.82	26500.0
2013-10-04 05:00:00	QQQ	ETF	78.83	78.88	78.81	78.88	11085.0
2013-10-04 06:00:00	QQQ	ETF	78.87	78.87	78.84	78.86	5000.0
2013-10-04 07:00:00	QQQ	ETF	78.87	78.9	78.79	78.8	17870.0
2013-10-04 08:00:00	QQQ	ETF	78.79	78.88	78.71	78.81	80195.0
2013-10-04 09:00:00	QQQ	ETF	78.81	79.11	78.65	79.005	3217924.0
2013-10-04 10:00:00	QQQ	ETF	79.01	79.24	78.96	79.0679	3569132.0
2013-10-04 11:00:00	QQQ	ETF	79.06	79.16	78.96	79.14	2748521.0
2013-10-04 12:00:00	QQQ	ETF	79.14	79.41	79.11	79.33	2258170.0
2013-10-04 13:00:00	QQQ	ETF	79.34	79.4	79.3	79.32	1642779.0
2013-10-04 14:00:00	QQQ	ETF	79.33	79.5	79.29	79.46	1889897.0
2013-10-04 15:00:00	QQQ	ETF	79.45	79.51	79.33	79.41	4220419.0
2013-10-04 16:00:00	QQQ	ETF	79.4	79.5	79.026	79.42	2316085.0
2013-10-04 17:00:00	QQQ	ETF	79.37	79.47	79.2364	79.44	182977.0
2013-10-04 19:00:00	QQQ	ETF	79.4	79.42	79.4	79.42	1100.0
2013-10-04 04:00:00	IWM	ETF	106.37	106.37	106.37	106.37	100.0
2013-10-04 06:00:00	IWM	ETF	106.31	106.31	106.31	106.31	200.0
2013-10-04 07:00:00	IWM	ETF	106.5	106.5	106.38	106.38	36300.0
2013-10-04 08:00:00	IWM	ETF	106.31	106.46	106.31	106.46	51182.0
2013-10-04 09:00:00	IWM	ETF	106.44	106.86	106.15	106.7	3923421.0
2013-10-04 10:00:00	IWM	ETF	106.72	107.05	106.61	106.91	4499424.0
2013-10-04 11:00:00	IWM	ETF	106.9	107.05	106.73	107.01	2082660.0
2013-10-04 12:00:00	IWM	ETF	107.01	107.31	106.93	107.2	3226766.0
2013-10-04 13:00:00	IWM	ETF	107.21	107.28	107.051	107.0693	1267325.0
2013-10-04 14:00:00	IWM	ETF	107.07	107.32	107.07	107.23	2031707.0
2013-10-04 15:00:00	IWM	ETF	107.24	107.31	106.98	107.01	5437951.0
2013-10-04 16:00:00	IWM	ETF	107.01	107.1612	106.89	107.0	1565964.0
2013-10-04 17:00:00	IWM	ETF	107.0	107.0	106.59	106.93	111841.0
2013-10-04 18:00:00	IWM	ETF	106.99	106.99	106.97	106.97	700.0
2013-10-04 19:00:00	IWM	ETF	106.97	107.05	106.97	107.05	4113.0
2013-10-04 07:00:00	DIA	ETF	149.75	149.75	149.75	149.75	500.0
2013-10-04 08:00:00	DIA	ETF	149.85	149.85	149.68	149.78	2400.0
2013-10-04 09:00:00	DIA	ETF	149.72	150.0162	149.43	149.94	588796.0
2013-10-04 10:00:00	DIA	ETF	149.97	150.28	149.86	150.01	1120357.0

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

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