PREVIEW / etf_1hour / 2018-08-22

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-08-22.parquet
  size:    302 KB
  rows:    9,907

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-08-22 04:00:00	SPY	ETF	285.26	285.58	285.25	285.55	12502.0
2018-08-22 05:00:00	SPY	ETF	285.55	285.59	285.41	285.42	10100.0
2018-08-22 06:00:00	SPY	ETF	285.48	285.9	285.48	285.9	63914.0
2018-08-22 07:00:00	SPY	ETF	285.9	286.05	285.53	285.6	291790.0
2018-08-22 08:00:00	SPY	ETF	285.822	286.05	285.24	285.6	1013896.0
2018-08-22 09:00:00	SPY	ETF	285.59	286.3	285.54	285.77	6625504.0
2018-08-22 10:00:00	SPY	ETF	285.775	286.52	285.575	286.4	7464632.0
2018-08-22 11:00:00	SPY	ETF	286.4	286.76	286.33	286.66	6700799.0
2018-08-22 12:00:00	SPY	ETF	286.67	286.72	286.26	286.41	3295522.0
2018-08-22 13:00:00	SPY	ETF	286.41	286.53	286.23	286.435	3236070.0
2018-08-22 14:00:00	SPY	ETF	286.435	286.72	285.9811	286.27	4488517.0
2018-08-22 15:00:00	SPY	ETF	286.28	286.53	286.19	286.2	7869551.0
2018-08-22 16:00:00	SPY	ETF	286.2	286.24	286.0	286.13	3430381.0
2018-08-22 17:00:00	SPY	ETF	286.11	286.17	285.95	286.1	105633.0
2018-08-22 18:00:00	SPY	ETF	286.12	286.35	286.12	286.3	103061.0
2018-08-22 19:00:00	SPY	ETF	286.3	286.3	286.13	286.18	16420.0
2018-08-22 04:00:00	QQQ	ETF	179.73	179.9	179.71	179.9	16880.0
2018-08-22 05:00:00	QQQ	ETF	179.9	179.91	179.81	179.85	6706.0
2018-08-22 06:00:00	QQQ	ETF	179.84	180.24	179.84	180.21	46805.0
2018-08-22 07:00:00	QQQ	ETF	180.22	180.33	179.97	180.09	40067.0
2018-08-22 08:00:00	QQQ	ETF	180.36	180.36	179.61	179.87	236137.0
2018-08-22 09:00:00	QQQ	ETF	179.91	180.59	179.84	180.03	2683599.0
2018-08-22 10:00:00	QQQ	ETF	180.05	180.901	179.75	180.85	2731429.0
2018-08-22 11:00:00	QQQ	ETF	180.85	181.21	180.79	181.17	1726926.0
2018-08-22 12:00:00	QQQ	ETF	181.165	181.2	180.73	180.82	1200482.0
2018-08-22 13:00:00	QQQ	ETF	180.82	181.06	180.73	180.96	745080.0
2018-08-22 14:00:00	QQQ	ETF	180.95	181.16	180.68	180.97	2804647.0
2018-08-22 15:00:00	QQQ	ETF	180.975	181.27	180.95	181.03	2894792.0
2018-08-22 16:00:00	QQQ	ETF	181.03	181.1	180.92	180.98	1553809.0
2018-08-22 17:00:00	QQQ	ETF	181.05	181.05	180.85	180.96	46014.0
2018-08-22 18:00:00	QQQ	ETF	180.97	181.16	180.97	181.16	74769.0
2018-08-22 19:00:00	QQQ	ETF	181.18	181.18	181.06	181.08	16680.0
2018-08-22 04:00:00	IWM	ETF	170.0	170.29	170.0	170.29	911.0
2018-08-22 05:00:00	IWM	ETF	170.29	170.29	170.27	170.27	3400.0
2018-08-22 06:00:00	IWM	ETF	170.32	170.47	170.32	170.47	6100.0
2018-08-22 07:00:00	IWM	ETF	170.59	170.59	170.27	170.3	9500.0
2018-08-22 08:00:00	IWM	ETF	170.6	170.6	170.04	170.36	479533.0
2018-08-22 09:00:00	IWM	ETF	170.3801	171.49	170.3801	170.57	3451420.0
2018-08-22 10:00:00	IWM	ETF	170.57	171.105	170.42	170.87	1865944.0
2018-08-22 11:00:00	IWM	ETF	170.87	171.26	170.68	171.2	1323200.0
2018-08-22 12:00:00	IWM	ETF	171.22	171.32	170.97	171.03	835459.0
2018-08-22 13:00:00	IWM	ETF	171.02	171.36	170.94	171.25	908690.0
2018-08-22 14:00:00	IWM	ETF	171.25	171.345	170.93	171.13	921245.0
2018-08-22 15:00:00	IWM	ETF	171.14	171.38	171.07	171.18	2564232.0
2018-08-22 16:00:00	IWM	ETF	171.17	171.29	171.11	171.28	429242.0
2018-08-22 17:00:00	IWM	ETF	171.18	171.23	171.18	171.23	535.0
2018-08-22 18:00:00	IWM	ETF	171.29	171.35	171.29	171.33	8880.0
2018-08-22 19:00:00	IWM	ETF	171.33	171.34	171.33	171.34	600.0
2018-08-22 04:00:00	DIA	ETF	257.2	257.4	257.2	257.4	300.0
2018-08-22 05:00:00	DIA	ETF	257.38	257.38	257.32	257.32	800.0

> showing 50 of 9,907 rows — these rows as CSV

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