PREVIEW / etf_1hour / 2015-12-14

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-12-14.parquet
  size:    254 KB
  rows:    8,114

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-12-14 04:00:00	SPY	ETF	202.5	203.3	202.5	203.17	72246.0
2015-12-14 05:00:00	SPY	ETF	203.23	203.23	202.81	203.11	65512.0
2015-12-14 06:00:00	SPY	ETF	203.09	203.13	201.25	201.88	438813.0
2015-12-14 07:00:00	SPY	ETF	201.87	202.11	200.79	201.52	791649.0
2015-12-14 08:00:00	SPY	ETF	202.02	202.4	201.02	202.13	1399757.0
2015-12-14 09:00:00	SPY	ETF	202.15	202.73	201.5	201.57	16877037.0
2015-12-14 10:00:00	SPY	ETF	201.58	203.05	200.83	201.384	41465645.0
2015-12-14 11:00:00	SPY	ETF	201.37	201.46	199.95	201.04	25971747.0
2015-12-14 12:00:00	SPY	ETF	201.03	202.44	200.84	202.32	23388291.0
2015-12-14 13:00:00	SPY	ETF	202.33	202.57	201.27	201.76	14769757.0
2015-12-14 14:00:00	SPY	ETF	201.751	202.42	201.34	202.15	13866833.0
2015-12-14 15:00:00	SPY	ETF	202.15	203.0	201.54	202.99	29560414.0
2015-12-14 16:00:00	SPY	ETF	202.99	203.15	201.2161	202.79	12380151.0
2015-12-14 17:00:00	SPY	ETF	202.76	202.83	202.67	202.83	147467.0
2015-12-14 18:00:00	SPY	ETF	202.84	203.47	202.83	203.31	467585.0
2015-12-14 19:00:00	SPY	ETF	203.3	203.37	202.9	203.1	129501.0
2015-12-14 20:00:00	SPY	ETF	202.8623	202.8623	202.8623	202.8623	400000.0
2015-12-14 04:00:00	QQQ	ETF	111.3	111.7	111.3	111.7	1800.0
2015-12-14 05:00:00	QQQ	ETF	111.51	111.53	111.48	111.53	2300.0
2015-12-14 06:00:00	QQQ	ETF	111.55	111.55	110.71	110.91	7500.0
2015-12-14 07:00:00	QQQ	ETF	111.03	111.03	110.39	110.63	163962.0
2015-12-14 08:00:00	QQQ	ETF	110.64	111.08	110.4	110.93	202600.0
2015-12-14 09:00:00	QQQ	ETF	110.95	111.2	110.53	110.62	7298542.0
2015-12-14 10:00:00	QQQ	ETF	110.63	111.28	110.09	110.48	14536915.0
2015-12-14 11:00:00	QQQ	ETF	110.47	110.52	109.38	110.1125	6073889.0
2015-12-14 12:00:00	QQQ	ETF	110.12	110.92	109.9807	110.87	4497792.0
2015-12-14 13:00:00	QQQ	ETF	110.87	111.02	110.51	110.84	2818864.0
2015-12-14 14:00:00	QQQ	ETF	110.86	111.38	110.63	111.2	3738021.0
2015-12-14 15:00:00	QQQ	ETF	111.21	111.68	110.8	111.66	7017565.0
2015-12-14 16:00:00	QQQ	ETF	111.66	111.86	111.5	111.66	1108230.0
2015-12-14 17:00:00	QQQ	ETF	111.67	111.68	111.58	111.63	5806.0
2015-12-14 18:00:00	QQQ	ETF	111.68	111.97	111.67	111.97	118890.0
2015-12-14 19:00:00	QQQ	ETF	111.91	111.91	111.68	111.79	21795.0
2015-12-14 04:00:00	IWM	ETF	112.32	112.56	112.32	112.56	798.0
2015-12-14 06:00:00	IWM	ETF	112.56	112.56	111.57	111.57	300.0
2015-12-14 07:00:00	IWM	ETF	111.83	111.83	111.25	111.38	101069.0
2015-12-14 08:00:00	IWM	ETF	111.37	111.97	111.25	111.87	248764.0
2015-12-14 09:00:00	IWM	ETF	111.87	112.38	111.64	111.67	4889123.0
2015-12-14 10:00:00	IWM	ETF	111.7	111.94	110.84	111.04	9909236.0
2015-12-14 11:00:00	IWM	ETF	111.03	111.16	110.28	110.915	8310988.0
2015-12-14 12:00:00	IWM	ETF	110.915	111.64	110.835	111.51	5666079.0
2015-12-14 13:00:00	IWM	ETF	111.52	111.62	110.91	111.155	3124528.0
2015-12-14 14:00:00	IWM	ETF	111.17	111.3	110.85	111.18	4248496.0
2015-12-14 15:00:00	IWM	ETF	111.17	111.24	110.72	111.17	9040172.0
2015-12-14 16:00:00	IWM	ETF	111.18	112.0401	110.81	110.9	2475537.0
2015-12-14 17:00:00	IWM	ETF	110.94	111.11	110.89	110.97	914391.0
2015-12-14 18:00:00	IWM	ETF	110.94	111.26	110.94	111.26	6362.0
2015-12-14 19:00:00	IWM	ETF	111.17	111.2	111.14	111.19	4950.0
2015-12-14 05:00:00	DIA	ETF	173.51	173.51	173.46	173.46	6000.0
2015-12-14 07:00:00	DIA	ETF	172.53	172.53	172.15	172.33	2000.0

> showing 50 of 8,114 rows — these rows as CSV

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