PREVIEW / etf_1hour / 2014-10-23

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-10-23.parquet
  size:    234 KB
  rows:    7,416

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-23 04:00:00	SPY	ETF	193.71	194.39	193.71	194.06	65336.0
2014-10-23 05:00:00	SPY	ETF	194.02	194.21	194.0	194.05	45346.0
2014-10-23 06:00:00	SPY	ETF	194.04	194.09	193.49	193.56	248401.0
2014-10-23 07:00:00	SPY	ETF	193.54	194.44	193.54	194.42	917009.0
2014-10-23 08:00:00	SPY	ETF	194.13	194.7	193.09	194.63	2376486.0
2014-10-23 09:00:00	SPY	ETF	194.6	194.87	194.26	194.447	17203281.0
2014-10-23 10:00:00	SPY	ETF	194.45	195.49	194.41	195.46	22000976.0
2014-10-23 11:00:00	SPY	ETF	195.47	195.75	195.18	195.31	17017284.0
2014-10-23 12:00:00	SPY	ETF	195.31	195.59	194.57	195.205	10933665.0
2014-10-23 13:00:00	SPY	ETF	195.21	195.7	195.17	195.56	9689860.0
2014-10-23 14:00:00	SPY	ETF	195.57	196.2	194.98	195.45	26399658.0
2014-10-23 15:00:00	SPY	ETF	195.455	195.5	194.73	194.95	37503022.0
2014-10-23 16:00:00	SPY	ETF	194.95	195.24	194.9133	195.2	6691611.0
2014-10-23 17:00:00	SPY	ETF	195.21	195.26	195.14	195.16	288019.0
2014-10-23 18:00:00	SPY	ETF	195.16	195.28	195.09	195.1	141132.0
2014-10-23 19:00:00	SPY	ETF	195.13	195.26	195.09	195.26	88772.0
2014-10-23 04:00:00	QQQ	ETF	96.69	97.1	96.69	96.99	2866.0
2014-10-23 05:00:00	QQQ	ETF	97.0	97.04	96.96	96.98	5351.0
2014-10-23 06:00:00	QQQ	ETF	97.0	97.02	96.76	96.78	18700.0
2014-10-23 07:00:00	QQQ	ETF	96.85	97.24	96.85	97.24	120947.0
2014-10-23 08:00:00	QQQ	ETF	97.2	97.4	96.89	97.33	471298.0
2014-10-23 09:00:00	QQQ	ETF	97.33	97.5	97.17	97.42	5320549.0
2014-10-23 10:00:00	QQQ	ETF	97.43	97.98	97.409	97.95	7690094.0
2014-10-23 11:00:00	QQQ	ETF	97.95	98.05	97.84	97.94	4252860.0
2014-10-23 12:00:00	QQQ	ETF	97.93	98.13	97.86	97.91	2284305.0
2014-10-23 13:00:00	QQQ	ETF	97.92	98.17	97.9	98.12	2816446.0
2014-10-23 14:00:00	QQQ	ETF	98.12	98.36	97.82	98.01	6337694.0
2014-10-23 15:00:00	QQQ	ETF	98.01	98.04	97.7136	97.84	11269237.0
2014-10-23 16:00:00	QQQ	ETF	97.84	98.05	97.7	97.9	2485415.0
2014-10-23 17:00:00	QQQ	ETF	97.9	97.92	97.45	97.64	193822.0
2014-10-23 18:00:00	QQQ	ETF	97.65	97.83	97.64	97.72	186798.0
2014-10-23 19:00:00	QQQ	ETF	97.73	97.79	97.68	97.78	16764.0
2014-10-23 04:00:00	IWM	ETF	109.49	109.81	109.49	109.8	976.0
2014-10-23 06:00:00	IWM	ETF	109.63	109.63	109.36	109.5	5650.0
2014-10-23 07:00:00	IWM	ETF	109.51	109.83	109.51	109.83	121737.0
2014-10-23 08:00:00	IWM	ETF	109.67	110.1	109.67	109.99	394660.0
2014-10-23 09:00:00	IWM	ETF	109.97	110.25	109.77	110.0201	6359226.0
2014-10-23 10:00:00	IWM	ETF	110.04	111.17	110.03	111.17	8680280.0
2014-10-23 11:00:00	IWM	ETF	111.17	111.49	111.04	111.28	5009327.0
2014-10-23 12:00:00	IWM	ETF	111.28	111.44	110.855	110.9	3062651.0
2014-10-23 13:00:00	IWM	ETF	110.91	111.2968	110.86	111.19	2551651.0
2014-10-23 14:00:00	IWM	ETF	111.19	111.58	110.88	111.04	5237025.0
2014-10-23 15:00:00	IWM	ETF	111.05	111.06	110.56	110.89	10573879.0
2014-10-23 16:00:00	IWM	ETF	110.89	111.08	108.9648	110.94	3342792.0
2014-10-23 17:00:00	IWM	ETF	110.94	111.02	110.89	110.89	15324.0
2014-10-23 18:00:00	IWM	ETF	110.98	111.13	110.91	111.0	16327.0
2014-10-23 19:00:00	IWM	ETF	110.91	111.05	110.91	111.0	3199.0
2014-10-23 04:00:00	DIA	ETF	165.6	165.6	165.6	165.6	100.0
2014-10-23 05:00:00	DIA	ETF	165.5	165.5	165.46	165.46	300.0
2014-10-23 06:00:00	DIA	ETF	165.43	165.43	165.16	165.16	600.0

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

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