PREVIEW / etf_1hour / 2014-10-03

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-10-03.parquet
  size:    229 KB
  rows:    7,218

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
2014-10-03 04:00:00	SPY	ETF	194.83	195.46	194.83	195.42	15185.0
2014-10-03 05:00:00	SPY	ETF	195.35	195.44	195.2	195.2	19872.0
2014-10-03 06:00:00	SPY	ETF	195.17	195.31	195.15	195.17	111972.0
2014-10-03 07:00:00	SPY	ETF	195.21	195.49	195.19	195.44	283007.0
2014-10-03 08:00:00	SPY	ETF	195.19	195.9	194.69	195.33	6959999.0
2014-10-03 09:00:00	SPY	ETF	195.33	196.22	195.08	196.03	20306868.0
2014-10-03 10:00:00	SPY	ETF	196.04	196.5	195.72	196.03	20999173.0
2014-10-03 11:00:00	SPY	ETF	196.02	196.32	195.915	196.17	9385575.0
2014-10-03 12:00:00	SPY	ETF	196.17	196.79	196.05	196.68	9960898.0
2014-10-03 13:00:00	SPY	ETF	196.67	196.7127	196.32	196.48	9798703.0
2014-10-03 14:00:00	SPY	ETF	196.475	196.88	196.475	196.75	10008978.0
2014-10-03 15:00:00	SPY	ETF	196.75	196.94	196.51	196.53	22051183.0
2014-10-03 16:00:00	SPY	ETF	196.51	196.75	195.2	196.48	9756407.0
2014-10-03 17:00:00	SPY	ETF	196.49	196.57	196.47	196.53	122019.0
2014-10-03 18:00:00	SPY	ETF	196.52	196.57	196.45	196.53	97869.0
2014-10-03 19:00:00	SPY	ETF	196.52	196.55	196.5	196.52	2847.0
2014-10-03 04:00:00	QQQ	ETF	97.55	97.67	97.55	97.67	1420.0
2014-10-03 05:00:00	QQQ	ETF	97.6	97.61	97.6	97.61	19900.0
2014-10-03 06:00:00	QQQ	ETF	97.54	97.64	97.54	97.56	38620.0
2014-10-03 07:00:00	QQQ	ETF	97.54	97.7	97.54	97.68	41850.0
2014-10-03 08:00:00	QQQ	ETF	97.67	97.99	97.2262	97.68	2125989.0
2014-10-03 09:00:00	QQQ	ETF	97.68	98.13	97.21	98.06	8494659.0
2014-10-03 10:00:00	QQQ	ETF	98.07	98.39	98.01	98.259	8580867.0
2014-10-03 11:00:00	QQQ	ETF	98.25	98.345	98.04	98.15	3326969.0
2014-10-03 12:00:00	QQQ	ETF	98.14	98.45	98.11	98.38	2624800.0
2014-10-03 13:00:00	QQQ	ETF	98.38	98.42	98.21	98.33	1918579.0
2014-10-03 14:00:00	QQQ	ETF	98.33	98.54	98.325	98.47	2746303.0
2014-10-03 15:00:00	QQQ	ETF	98.47	98.57	98.18	98.19	7271574.0
2014-10-03 16:00:00	QQQ	ETF	98.18	98.35	97.8709	98.15	937407.0
2014-10-03 17:00:00	QQQ	ETF	98.15	98.16	98.12	98.12	3192.0
2014-10-03 18:00:00	QQQ	ETF	98.17	98.17	98.13	98.13	11440.0
2014-10-03 19:00:00	QQQ	ETF	98.13	98.18	98.09	98.09	9316.0
2014-10-03 04:00:00	IWM	ETF	109.33	109.35	109.33	109.35	200.0
2014-10-03 06:00:00	IWM	ETF	109.3	109.43	109.3	109.4	20175.0
2014-10-03 07:00:00	IWM	ETF	109.36	109.5	109.36	109.44	48090.0
2014-10-03 08:00:00	IWM	ETF	109.42	109.88	109.31	109.68	1340465.0
2014-10-03 09:00:00	IWM	ETF	109.7	109.95	109.08	109.7702	7433857.0
2014-10-03 10:00:00	IWM	ETF	109.8	110.11	109.5	110.08	6435902.0
2014-10-03 11:00:00	IWM	ETF	110.09	110.32	110.011	110.094	3968393.0
2014-10-03 12:00:00	IWM	ETF	110.095	110.3	110.01	110.07	3106415.0
2014-10-03 13:00:00	IWM	ETF	110.065	110.095	109.78	109.905	3104225.0
2014-10-03 14:00:00	IWM	ETF	109.91	110.07	109.86	109.94	2377637.0
2014-10-03 15:00:00	IWM	ETF	109.94	110.0	109.64	109.65	6144327.0
2014-10-03 16:00:00	IWM	ETF	109.64	109.77	109.47	109.68	2005662.0
2014-10-03 17:00:00	IWM	ETF	109.69	109.7	109.65	109.66	21350.0
2014-10-03 18:00:00	IWM	ETF	109.69	109.72	109.65	109.65	800.0
2014-10-03 19:00:00	IWM	ETF	109.66	109.66	109.6	109.6	1700.0
2014-10-03 08:00:00	DIA	ETF	168.5	168.94	168.36	168.57	31790.0
2014-10-03 09:00:00	DIA	ETF	168.59	169.38	168.37	169.15	1298866.0
2014-10-03 10:00:00	DIA	ETF	169.17	169.49	168.78	168.97	1007830.0

> showing 50 of 7,218 rows — these rows as CSV

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