PREVIEW / etf_1hour / 2016-03-11

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-03-11.parquet
  size:    252 KB
  rows:    8,110

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
2016-03-11 04:00:00	SPY	ETF	201.1	201.56	201.05	201.29	80288.0
2016-03-11 05:00:00	SPY	ETF	201.31	201.72	201.31	201.49	154052.0
2016-03-11 06:00:00	SPY	ETF	201.66	201.72	201.31	201.36	183622.0
2016-03-11 07:00:00	SPY	ETF	201.33	201.42	201.19	201.3	602562.0
2016-03-11 08:00:00	SPY	ETF	201.3	201.5	200.615	201.21	1159259.0
2016-03-11 09:00:00	SPY	ETF	201.23	201.88	201.12	201.48	14872293.0
2016-03-11 10:00:00	SPY	ETF	201.48	202.039	201.14	201.78	24056052.0
2016-03-11 11:00:00	SPY	ETF	201.79	202.33	201.73	202.24	14695528.0
2016-03-11 12:00:00	SPY	ETF	202.24	202.48	202.13	202.17	9860627.0
2016-03-11 13:00:00	SPY	ETF	202.1625	202.3	201.82	202.23	9137045.0
2016-03-11 14:00:00	SPY	ETF	202.23	202.32	201.94	202.11	9744161.0
2016-03-11 15:00:00	SPY	ETF	202.11	202.81	202.07	202.73	32920408.0
2016-03-11 16:00:00	SPY	ETF	202.73	202.7725	199.4636	202.68	17351772.0
2016-03-11 17:00:00	SPY	ETF	202.65	202.73	202.61	202.68	1331046.0
2016-03-11 18:00:00	SPY	ETF	202.68	202.73	202.64	202.73	46027.0
2016-03-11 19:00:00	SPY	ETF	202.72	202.72	202.65	202.68	23877.0
2016-03-11 04:00:00	QQQ	ETF	105.73	105.9	105.72	105.85	6816.0
2016-03-11 05:00:00	QQQ	ETF	105.86	105.97	105.86	105.95	1503.0
2016-03-11 06:00:00	QQQ	ETF	105.92	106.0	105.79	105.79	5217.0
2016-03-11 07:00:00	QQQ	ETF	105.78	105.84	105.73	105.78	35261.0
2016-03-11 08:00:00	QQQ	ETF	105.78	105.89	105.67	105.75	318184.0
2016-03-11 09:00:00	QQQ	ETF	105.77	105.98	105.55	105.84	4415205.0
2016-03-11 10:00:00	QQQ	ETF	105.84	106.13	105.46	105.98	5007794.0
2016-03-11 11:00:00	QQQ	ETF	105.98	106.06	105.95	106.01	3146228.0
2016-03-11 12:00:00	QQQ	ETF	106.01	106.12	105.951	105.99	1915720.0
2016-03-11 13:00:00	QQQ	ETF	105.99	106.15	105.83	106.11	1726511.0
2016-03-11 14:00:00	QQQ	ETF	106.12	106.19	105.971	106.1	2018721.0
2016-03-11 15:00:00	QQQ	ETF	106.1	106.49	106.09	106.48	6000756.0
2016-03-11 16:00:00	QQQ	ETF	106.46	106.49	106.27	106.36	1821335.0
2016-03-11 17:00:00	QQQ	ETF	106.38	106.38	106.29	106.29	6739.0
2016-03-11 18:00:00	QQQ	ETF	106.32	106.3501	106.3	106.35	4222.0
2016-03-11 19:00:00	QQQ	ETF	106.38	106.38	106.35	106.36	1908.0
2016-03-11 04:00:00	IWM	ETF	106.61	106.94	106.61	106.94	300.0
2016-03-11 05:00:00	IWM	ETF	107.1	107.1	106.96	106.96	23100.0
2016-03-11 06:00:00	IWM	ETF	107.1	107.1	107.1	107.1	200.0
2016-03-11 07:00:00	IWM	ETF	106.98	107.06	106.92	106.95	32064.0
2016-03-11 08:00:00	IWM	ETF	107.04	107.07	106.75	106.86	191049.0
2016-03-11 09:00:00	IWM	ETF	106.85	107.18	106.66	107.0	4542235.0
2016-03-11 10:00:00	IWM	ETF	107.01	107.41	106.76	107.341	4259128.0
2016-03-11 11:00:00	IWM	ETF	107.345	107.78	107.25	107.64	4241714.0
2016-03-11 12:00:00	IWM	ETF	107.64	107.75	107.5	107.54	2209845.0
2016-03-11 13:00:00	IWM	ETF	107.54	107.68	107.375	107.65	1848135.0
2016-03-11 14:00:00	IWM	ETF	107.66	107.85	107.55	107.61	1802039.0
2016-03-11 15:00:00	IWM	ETF	107.6	108.33	107.59	108.2	7426965.0
2016-03-11 16:00:00	IWM	ETF	108.19	108.262	107.5	108.18	3607710.0
2016-03-11 17:00:00	IWM	ETF	108.18	108.2	108.11	108.13	21799.0
2016-03-11 18:00:00	IWM	ETF	108.15	108.18	108.15	108.18	3000.0
2016-03-11 19:00:00	IWM	ETF	108.15	108.2	108.15	108.2	4300.0
2016-03-11 06:00:00	DIA	ETF	171.6	171.6	171.6	171.6	2000.0
2016-03-11 07:00:00	DIA	ETF	171.39	171.5	171.37	171.47	7550.0

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

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