PREVIEW / etf_1hour / 2018-09-11

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-09-11.parquet
  size:    307 KB
  rows:    10,047

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
2018-09-11 04:00:00	SPY	ETF	288.35	288.41	287.8	287.96	10169.0
2018-09-11 05:00:00	SPY	ETF	287.86	287.86	287.38	287.65	26054.0
2018-09-11 06:00:00	SPY	ETF	287.7	287.8	287.58	287.76	27772.0
2018-09-11 07:00:00	SPY	ETF	287.75	287.75	287.33	287.55	114876.0
2018-09-11 08:00:00	SPY	ETF	287.4801	288.67	287.23	287.36	814606.0
2018-09-11 09:00:00	SPY	ETF	287.36	287.92	286.975	287.86	6993984.0
2018-09-11 10:00:00	SPY	ETF	287.86	288.38	287.77	288.05	7071321.0
2018-09-11 11:00:00	SPY	ETF	288.06	289.41	288.05	289.4	7073542.0
2018-09-11 12:00:00	SPY	ETF	289.39	289.55	289.17	289.47	4978100.0
2018-09-11 13:00:00	SPY	ETF	289.475	289.54	289.05	289.16	3660251.0
2018-09-11 14:00:00	SPY	ETF	289.16	289.49	289.0001	289.2935	2863219.0
2018-09-11 15:00:00	SPY	ETF	289.29	289.45	288.94	289.11	8417721.0
2018-09-11 16:00:00	SPY	ETF	289.12	289.31	288.7627	289.23	5610612.0
2018-09-11 17:00:00	SPY	ETF	289.19	289.29	289.05	289.26	827007.0
2018-09-11 18:00:00	SPY	ETF	289.29	289.43	289.23	289.38	57938.0
2018-09-11 19:00:00	SPY	ETF	289.37	289.38	289.3	289.33	42373.0
2018-09-11 04:00:00	QQQ	ETF	182.12	182.13	181.52	181.65	102983.0
2018-09-11 05:00:00	QQQ	ETF	181.65	181.65	181.13	181.45	50984.0
2018-09-11 06:00:00	QQQ	ETF	181.47	181.57	181.4	181.56	26117.0
2018-09-11 07:00:00	QQQ	ETF	181.56	181.56	181.22	181.39	75928.0
2018-09-11 08:00:00	QQQ	ETF	181.56	181.56	180.93	181.03	259756.0
2018-09-11 09:00:00	QQQ	ETF	181.02	182.01	180.52	181.84	4857135.0
2018-09-11 10:00:00	QQQ	ETF	181.84	182.29	181.635	181.81	3488477.0
2018-09-11 11:00:00	QQQ	ETF	181.81	183.23	181.7899	183.22	3527783.0
2018-09-11 12:00:00	QQQ	ETF	183.22	183.42	182.87	183.14	3110984.0
2018-09-11 13:00:00	QQQ	ETF	183.14	183.2	182.52	182.82	1883104.0
2018-09-11 14:00:00	QQQ	ETF	182.81	183.25	182.67	183.06	1707833.0
2018-09-11 15:00:00	QQQ	ETF	183.06	183.2	182.92	183.11	4257277.0
2018-09-11 16:00:00	QQQ	ETF	183.11	183.24	183.05	183.17	1292952.0
2018-09-11 17:00:00	QQQ	ETF	183.16	183.25	183.02	183.11	234162.0
2018-09-11 18:00:00	QQQ	ETF	183.19	183.34	183.18	183.31	23266.0
2018-09-11 19:00:00	QQQ	ETF	183.3	183.33	183.23	183.26	18333.0
2018-09-11 04:00:00	IWM	ETF	171.11	171.11	171.06	171.06	431.0
2018-09-11 05:00:00	IWM	ETF	170.67	170.67	170.67	170.67	200.0
2018-09-11 06:00:00	IWM	ETF	170.73	170.81	170.73	170.81	3600.0
2018-09-11 07:00:00	IWM	ETF	170.75	170.75	170.52	170.67	33559.0
2018-09-11 08:00:00	IWM	ETF	170.65	170.68	170.47	170.47	5797.0
2018-09-11 09:00:00	IWM	ETF	170.54	171.19	170.24	170.84	1324035.0
2018-09-11 10:00:00	IWM	ETF	170.84	171.13	170.0	170.165	2181780.0
2018-09-11 11:00:00	IWM	ETF	170.155	171.57	170.11	171.54	1867450.0
2018-09-11 12:00:00	IWM	ETF	171.55	171.6	171.09	171.323	1202890.0
2018-09-11 13:00:00	IWM	ETF	171.33	171.38	170.73	170.83	1091003.0
2018-09-11 14:00:00	IWM	ETF	170.83	171.289	170.8	171.0	801668.0
2018-09-11 15:00:00	IWM	ETF	171.01	171.125	170.86	171.02	2380148.0
2018-09-11 16:00:00	IWM	ETF	171.01	171.28	170.9	171.24	438539.0
2018-09-11 17:00:00	IWM	ETF	171.15	171.2	171.03	171.2	472128.0
2018-09-11 18:00:00	IWM	ETF	171.23	171.32	171.19	171.28	6124.0
2018-09-11 19:00:00	IWM	ETF	171.25	171.26	171.21	171.26	9500.0
2018-09-11 04:00:00	DIA	ETF	259.18	259.18	258.79	258.79	5025.0
2018-09-11 06:00:00	DIA	ETF	258.34	258.34	258.27	258.27	800.0

> showing 50 of 10,047 rows — these rows as CSV

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