PREVIEW / etf_1hour / 2015-04-02

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-04-02.parquet
  size:    234 KB
  rows:    7,449

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
2015-04-02 04:00:00	SPY	ETF	205.59	205.59	204.95	205.1	5864.0
2015-04-02 05:00:00	SPY	ETF	205.07	205.22	205.0	205.15	21680.0
2015-04-02 06:00:00	SPY	ETF	205.15	205.2	205.01	205.2	16530.0
2015-04-02 07:00:00	SPY	ETF	205.19	205.47	205.14	205.47	79468.0
2015-04-02 08:00:00	SPY	ETF	205.25	205.67	205.19	205.55	576779.0
2015-04-02 09:00:00	SPY	ETF	205.57	206.85	205.32	206.76	14549125.0
2015-04-02 10:00:00	SPY	ETF	206.77	206.98	206.23	206.39	12127327.0
2015-04-02 11:00:00	SPY	ETF	206.39	206.63	206.17	206.2527	7459124.0
2015-04-02 12:00:00	SPY	ETF	206.25	206.42	205.83	206.286	8456056.0
2015-04-02 13:00:00	SPY	ETF	206.29	206.55	206.2	206.42	6201674.0
2015-04-02 14:00:00	SPY	ETF	206.42	206.73	206.15	206.33	7328871.0
2015-04-02 15:00:00	SPY	ETF	206.33	206.77	206.22	206.38	17664266.0
2015-04-02 16:00:00	SPY	ETF	206.37	206.58	206.26	206.54	8406565.0
2015-04-02 17:00:00	SPY	ETF	206.54	206.54	206.44	206.46	336552.0
2015-04-02 18:00:00	SPY	ETF	206.46	206.48	206.42	206.42	27063.0
2015-04-02 19:00:00	SPY	ETF	206.44	206.44	206.37	206.39	23838.0
2015-04-02 04:00:00	QQQ	ETF	105.0	105.0	104.68	104.68	482.0
2015-04-02 07:00:00	QQQ	ETF	104.9	105.09	104.9	105.09	6485.0
2015-04-02 08:00:00	QQQ	ETF	105.12	105.18	104.96	105.13	146911.0
2015-04-02 09:00:00	QQQ	ETF	105.16	105.4099	104.78	105.3099	4426647.0
2015-04-02 10:00:00	QQQ	ETF	105.31	105.46	104.9843	105.08	2809431.0
2015-04-02 11:00:00	QQQ	ETF	105.09	105.25	105.03	105.08	1524088.0
2015-04-02 12:00:00	QQQ	ETF	105.07	105.1699	104.85	105.09	1637146.0
2015-04-02 13:00:00	QQQ	ETF	105.0979	105.25	105.02	105.19	1281456.0
2015-04-02 14:00:00	QQQ	ETF	105.18	105.33	105.01	105.07	1172605.0
2015-04-02 15:00:00	QQQ	ETF	105.07	105.41	105.06	105.15	3710264.0
2015-04-02 16:00:00	QQQ	ETF	105.15	105.279	105.07	105.16	1584243.0
2015-04-02 17:00:00	QQQ	ETF	105.15	105.16	105.06	105.1	19545.0
2015-04-02 18:00:00	QQQ	ETF	105.08	105.08	105.06	105.08	4427.0
2015-04-02 19:00:00	QQQ	ETF	105.07	105.0701	105.07	105.0701	200.0
2015-04-02 05:00:00	IWM	ETF	123.96	123.96	123.96	123.96	1000.0
2015-04-02 06:00:00	IWM	ETF	123.95	124.05	123.93	124.05	1500.0
2015-04-02 07:00:00	IWM	ETF	124.07	124.22	124.03	124.2	29752.0
2015-04-02 08:00:00	IWM	ETF	124.24	124.35	124.13	124.33	104465.0
2015-04-02 09:00:00	IWM	ETF	124.35	125.14	124.25	125.02	3188176.0
2015-04-02 10:00:00	IWM	ETF	125.04	125.26	124.85	124.93	2831488.0
2015-04-02 11:00:00	IWM	ETF	124.935	125.09	124.68	124.71	2096228.0
2015-04-02 12:00:00	IWM	ETF	124.72	124.91	124.47	124.75	2168170.0
2015-04-02 13:00:00	IWM	ETF	124.755	125.04	124.66	124.81	1707045.0
2015-04-02 14:00:00	IWM	ETF	124.815	124.9	124.53	124.6	1198971.0
2015-04-02 15:00:00	IWM	ETF	124.595	124.82	124.51	124.64	3281682.0
2015-04-02 16:00:00	IWM	ETF	124.64	124.75	124.2855	124.661	1097241.0
2015-04-02 17:00:00	IWM	ETF	124.68	124.68	124.5	124.5	48468.0
2015-04-02 18:00:00	IWM	ETF	124.5	124.5	124.5	124.5	917.0
2015-04-02 19:00:00	IWM	ETF	124.58	124.58	124.58	124.58	100.0
2015-04-02 07:00:00	DIA	ETF	176.52	176.6	176.52	176.56	600.0
2015-04-02 08:00:00	DIA	ETF	176.55	176.77	176.51	176.65	3250.0
2015-04-02 09:00:00	DIA	ETF	176.59	177.75	176.43	177.61	764637.0
2015-04-02 10:00:00	DIA	ETF	177.65	177.91	177.2	177.31	494463.0
2015-04-02 11:00:00	DIA	ETF	177.32	177.46	177.02	177.07	317746.0

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

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