PREVIEW / etf_1hour / 2018-08-23

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-08-23.parquet
  size:    301 KB
  rows:    9,849

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-23 04:00:00	SPY	ETF	286.09	286.32	285.94	286.32	1722.0
2018-08-23 05:00:00	SPY	ETF	286.25	286.32	286.1	286.15	17150.0
2018-08-23 06:00:00	SPY	ETF	286.1	286.23	286.03	286.22	10019.0
2018-08-23 07:00:00	SPY	ETF	286.15	286.17	285.93	286.14	72637.0
2018-08-23 08:00:00	SPY	ETF	286.15	286.24	285.99	286.17	101232.0
2018-08-23 09:00:00	SPY	ETF	286.17	286.7499	285.8	286.46	4648486.0
2018-08-23 10:00:00	SPY	ETF	286.47	286.94	286.365	286.38	7768252.0
2018-08-23 11:00:00	SPY	ETF	286.37	286.45	285.43	285.66	8814941.0
2018-08-23 12:00:00	SPY	ETF	285.67	286.1368	285.65	285.85	3744162.0
2018-08-23 13:00:00	SPY	ETF	285.85	285.93	285.62	285.77	2645038.0
2018-08-23 14:00:00	SPY	ETF	285.76	286.12	285.76	285.995	2366651.0
2018-08-23 15:00:00	SPY	ETF	285.995	286.15	285.475	285.77	11551857.0
2018-08-23 16:00:00	SPY	ETF	285.76	285.9	285.5873	285.8	6336000.0
2018-08-23 17:00:00	SPY	ETF	285.82	285.85	285.77	285.77	12875.0
2018-08-23 18:00:00	SPY	ETF	285.8	285.83	285.75	285.78	23868.0
2018-08-23 19:00:00	SPY	ETF	285.75	285.86	285.69	285.72	19710.0
2018-08-23 04:00:00	QQQ	ETF	181.08	181.08	180.86	180.93	2227.0
2018-08-23 05:00:00	QQQ	ETF	181.07	181.07	180.96	181.01	4237.0
2018-08-23 06:00:00	QQQ	ETF	180.99	181.01	180.83	180.87	9052.0
2018-08-23 07:00:00	QQQ	ETF	180.97	181.0	180.79	180.86	43532.0
2018-08-23 08:00:00	QQQ	ETF	180.87	180.96	180.8	180.91	79058.0
2018-08-23 09:00:00	QQQ	ETF	180.9	181.9	180.66	181.79	2737362.0
2018-08-23 10:00:00	QQQ	ETF	181.79	182.045	181.55	181.561	2899706.0
2018-08-23 11:00:00	QQQ	ETF	181.56	181.65	180.5	180.8	4846429.0
2018-08-23 12:00:00	QQQ	ETF	180.81	181.32	180.79	181.11	2310430.0
2018-08-23 13:00:00	QQQ	ETF	181.111	181.26	180.96	181.16	1206999.0
2018-08-23 14:00:00	QQQ	ETF	181.165	181.42	181.155	181.2799	1112852.0
2018-08-23 15:00:00	QQQ	ETF	181.28	181.33	180.65	180.77	3513931.0
2018-08-23 16:00:00	QQQ	ETF	180.77	180.93	180.76	180.76	881868.0
2018-08-23 17:00:00	QQQ	ETF	180.78	180.85	180.78	180.85	2155.0
2018-08-23 18:00:00	QQQ	ETF	180.82	180.86	180.78	180.86	7713.0
2018-08-23 19:00:00	QQQ	ETF	180.89	180.99	180.85	180.87	12084.0
2018-08-23 06:00:00	IWM	ETF	171.27	171.29	171.27	171.29	1800.0
2018-08-23 07:00:00	IWM	ETF	171.33	171.33	171.33	171.33	400.0
2018-08-23 08:00:00	IWM	ETF	171.3	171.35	171.18	171.25	105957.0
2018-08-23 09:00:00	IWM	ETF	171.24	171.32	170.99	171.05	1184787.0
2018-08-23 10:00:00	IWM	ETF	171.04	171.52	170.79	170.9	2173202.0
2018-08-23 11:00:00	IWM	ETF	170.9	171.09	170.175	170.58	2790724.0
2018-08-23 12:00:00	IWM	ETF	170.58	171.17	170.57	170.78	908476.0
2018-08-23 13:00:00	IWM	ETF	170.78	170.8	170.55	170.57	621366.0
2018-08-23 14:00:00	IWM	ETF	170.565	170.98	170.555	170.98	592903.0
2018-08-23 15:00:00	IWM	ETF	170.98	171.16	170.64	170.67	1891277.0
2018-08-23 16:00:00	IWM	ETF	170.68	170.87	170.65	170.82	671157.0
2018-08-23 18:00:00	IWM	ETF	170.78	170.78	170.78	170.78	800.0
2018-08-23 19:00:00	IWM	ETF	170.78	170.83	170.75	170.76	2514.0
2018-08-23 07:00:00	DIA	ETF	256.98	257.2	256.98	257.2	450.0
2018-08-23 08:00:00	DIA	ETF	257.05	257.09	257.05	257.09	1222.0
2018-08-23 09:00:00	DIA	ETF	257.0	257.4799	256.58	257.11	345321.0
2018-08-23 10:00:00	DIA	ETF	257.14	257.56	257.05	257.08	385154.0
2018-08-23 11:00:00	DIA	ETF	257.09	257.19	255.98	256.19	666789.0

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

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