PREVIEW / etf_1hour / 2013-10-23

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-10-23.parquet
  size:    211 KB
  rows:    6,692

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-23 04:00:00	SPY	ETF	174.55	174.84	174.23	174.52	50502.0
2013-10-23 05:00:00	SPY	ETF	174.54	174.61	174.43	174.43	50997.0
2013-10-23 06:00:00	SPY	ETF	174.42	174.62	174.32	174.56	159102.0
2013-10-23 07:00:00	SPY	ETF	174.54	174.62	174.38	174.57	399122.0
2013-10-23 08:00:00	SPY	ETF	174.56	174.81	174.42	174.76	1907237.0
2013-10-23 09:00:00	SPY	ETF	174.77	174.89	174.19	174.23	16132109.0
2013-10-23 10:00:00	SPY	ETF	174.2301	174.71	173.96	174.27	23940603.0
2013-10-23 11:00:00	SPY	ETF	174.27	174.67	174.21	174.51	11598566.0
2013-10-23 12:00:00	SPY	ETF	174.52	174.57	174.18	174.53	9404829.0
2013-10-23 13:00:00	SPY	ETF	174.54	174.65	174.36	174.48	6775658.0
2013-10-23 14:00:00	SPY	ETF	174.48	174.84	174.42	174.71	7537462.0
2013-10-23 15:00:00	SPY	ETF	174.71	174.81	174.4	174.62	19372520.0
2013-10-23 16:00:00	SPY	ETF	174.62	174.82	174.51	174.75	4455548.0
2013-10-23 17:00:00	SPY	ETF	174.75	174.83	174.74	174.76	215996.0
2013-10-23 18:00:00	SPY	ETF	174.76	174.8	174.58	174.67	69134.0
2013-10-23 19:00:00	SPY	ETF	174.69	174.78	174.64	174.76	52485.0
2013-10-23 04:00:00	QQQ	ETF	82.0	82.0	81.85	81.98	72600.0
2013-10-23 05:00:00	QQQ	ETF	81.97	81.97	81.9	81.9	6300.0
2013-10-23 06:00:00	QQQ	ETF	81.89	81.96	81.84	81.94	31740.0
2013-10-23 07:00:00	QQQ	ETF	81.93	81.96	81.85	81.93	159404.0
2013-10-23 08:00:00	QQQ	ETF	81.93	82.1	81.9	82.08	248460.0
2013-10-23 09:00:00	QQQ	ETF	82.08	82.2	81.77	81.781	5628264.0
2013-10-23 10:00:00	QQQ	ETF	81.79	82.005	81.55	81.651	6796698.0
2013-10-23 11:00:00	QQQ	ETF	81.66	81.87	81.58	81.81	3411183.0
2013-10-23 12:00:00	QQQ	ETF	81.8045	81.91	81.65	81.891	2361931.0
2013-10-23 13:00:00	QQQ	ETF	81.9	81.93	81.78	81.845	2440843.0
2013-10-23 14:00:00	QQQ	ETF	81.85	82.0	81.7801	81.9599	2426599.0
2013-10-23 15:00:00	QQQ	ETF	81.95	81.97	81.8099	81.96	4100051.0
2013-10-23 16:00:00	QQQ	ETF	81.96	82.4636	81.9	82.04	4391455.0
2013-10-23 17:00:00	QQQ	ETF	82.07	82.1	82.04	82.09	5322.0
2013-10-23 18:00:00	QQQ	ETF	82.03	82.03	81.96	82.02	13200.0
2013-10-23 19:00:00	QQQ	ETF	82.02	82.07	82.0	82.04	8100.0
2013-10-23 04:00:00	IWM	ETF	110.03	110.03	110.03	110.03	708.0
2013-10-23 05:00:00	IWM	ETF	110.0	110.0	110.0	110.0	1500.0
2013-10-23 06:00:00	IWM	ETF	109.99	109.99	109.99	109.99	300.0
2013-10-23 07:00:00	IWM	ETF	110.01	110.02	109.86	109.95	108976.0
2013-10-23 08:00:00	IWM	ETF	109.95	110.16	109.91	110.16	222502.0
2013-10-23 09:00:00	IWM	ETF	110.16	110.31	109.82	109.85	5130125.0
2013-10-23 10:00:00	IWM	ETF	109.855	110.37	109.77	110.16	7070389.0
2013-10-23 11:00:00	IWM	ETF	110.18	110.51	110.09	110.38	3923566.0
2013-10-23 12:00:00	IWM	ETF	110.3745	110.54	110.21	110.465	1854170.0
2013-10-23 13:00:00	IWM	ETF	110.47	110.49	110.22	110.4	2084817.0
2013-10-23 14:00:00	IWM	ETF	110.4059	110.545	110.28	110.425	1809484.0
2013-10-23 15:00:00	IWM	ETF	110.43	110.505	110.27	110.41	4802329.0
2013-10-23 16:00:00	IWM	ETF	110.4	110.7794	110.34	110.46	1546822.0
2013-10-23 17:00:00	IWM	ETF	110.46	110.47	110.46	110.47	5300.0
2013-10-23 18:00:00	IWM	ETF	110.39	110.4	110.36	110.4	900.0
2013-10-23 19:00:00	IWM	ETF	110.36	110.46	110.36	110.46	2600.0
2013-10-23 04:00:00	DIA	ETF	153.48	153.48	153.48	153.48	200.0
2013-10-23 07:00:00	DIA	ETF	153.65	153.65	153.57	153.57	300.0

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

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