PREVIEW / etf_1hour / 2018-08-14

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-08-14.parquet
  size:    300 KB
  rows:    9,818

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-14 04:00:00	SPY	ETF	283.7	283.7	283.17	283.27	6591.0
2018-08-14 05:00:00	SPY	ETF	283.11	283.43	283.11	283.27	4800.0
2018-08-14 06:00:00	SPY	ETF	283.19	283.61	283.19	283.44	105835.0
2018-08-14 07:00:00	SPY	ETF	283.37	283.4	283.15	283.28	154544.0
2018-08-14 08:00:00	SPY	ETF	283.1999	283.36	282.91	283.12	149422.0
2018-08-14 09:00:00	SPY	ETF	283.12	283.33	282.75	282.99	5638203.0
2018-08-14 10:00:00	SPY	ETF	283.0	283.9865	282.4833	283.7352	6295656.0
2018-08-14 11:00:00	SPY	ETF	283.74	283.91	283.44	283.5841	5013767.0
2018-08-14 12:00:00	SPY	ETF	283.59	284.09	283.59	283.67	3785794.0
2018-08-14 13:00:00	SPY	ETF	283.67	284.07	283.63	284.04	3328567.0
2018-08-14 14:00:00	SPY	ETF	284.05	284.14	283.72	284.0	3450597.0
2018-08-14 15:00:00	SPY	ETF	284.005	284.17	283.765	283.86	9454026.0
2018-08-14 16:00:00	SPY	ETF	283.84	284.04	283.66	283.99	5035095.0
2018-08-14 17:00:00	SPY	ETF	283.96	284.05	283.92	283.98	75453.0
2018-08-14 18:00:00	SPY	ETF	284.03	284.03	283.82	283.97	75691.0
2018-08-14 19:00:00	SPY	ETF	283.93	284.0	283.85	283.97	16214.0
2018-08-14 04:00:00	QQQ	ETF	181.4	181.65	181.26	181.3	11604.0
2018-08-14 05:00:00	QQQ	ETF	181.23	181.52	181.23	181.39	13250.0
2018-08-14 06:00:00	QQQ	ETF	181.38	181.52	181.34	181.45	12154.0
2018-08-14 07:00:00	QQQ	ETF	181.34	181.39	181.18	181.25	98270.0
2018-08-14 08:00:00	QQQ	ETF	181.35	181.35	181.06	181.13	74716.0
2018-08-14 09:00:00	QQQ	ETF	181.2	181.2	180.34	180.55	3090008.0
2018-08-14 10:00:00	QQQ	ETF	180.56	181.39	180.04	181.25	3578284.0
2018-08-14 11:00:00	QQQ	ETF	181.24	181.57	181.08	181.2964	2513162.0
2018-08-14 12:00:00	QQQ	ETF	181.31	181.66	181.26	181.335	1359485.0
2018-08-14 13:00:00	QQQ	ETF	181.34	181.58	181.2102	181.55	964473.0
2018-08-14 14:00:00	QQQ	ETF	181.55	181.6	181.22	181.509	1581069.0
2018-08-14 15:00:00	QQQ	ETF	181.51	181.65	181.39	181.47	3706902.0
2018-08-14 16:00:00	QQQ	ETF	181.46	181.6	181.38	181.59	1059817.0
2018-08-14 17:00:00	QQQ	ETF	181.48	181.69	181.48	181.51	3848.0
2018-08-14 18:00:00	QQQ	ETF	181.58	181.62	181.47	181.52	25252.0
2018-08-14 19:00:00	QQQ	ETF	181.55	181.56	181.49	181.56	15809.0
2018-08-14 04:00:00	IWM	ETF	167.21	167.51	167.21	167.24	1280.0
2018-08-14 06:00:00	IWM	ETF	167.44	167.49	167.44	167.48	1200.0
2018-08-14 07:00:00	IWM	ETF	167.4	167.4	167.1	167.15	23654.0
2018-08-14 08:00:00	IWM	ETF	167.09	167.09	166.96	167.01	7246.0
2018-08-14 09:00:00	IWM	ETF	166.99	167.68	166.86	167.37	1578179.0
2018-08-14 10:00:00	IWM	ETF	167.43	168.55	167.2	168.2975	3735560.0
2018-08-14 11:00:00	IWM	ETF	168.3	168.6	168.055	168.14	2212536.0
2018-08-14 12:00:00	IWM	ETF	168.14	168.59	168.14	168.31	1168880.0
2018-08-14 13:00:00	IWM	ETF	168.31	168.44	168.06	168.21	911799.0
2018-08-14 14:00:00	IWM	ETF	168.22	168.25	167.97	168.08	794230.0
2018-08-14 15:00:00	IWM	ETF	168.09	168.38	168.07	168.22	3727814.0
2018-08-14 16:00:00	IWM	ETF	168.23	168.54	168.2	168.49	1153723.0
2018-08-14 17:00:00	IWM	ETF	168.38	168.49	168.38	168.42	3816.0
2018-08-14 18:00:00	IWM	ETF	168.46	168.49	168.4	168.49	16625.0
2018-08-14 19:00:00	IWM	ETF	168.49	168.49	168.41	168.45	2700.0
2018-08-14 04:00:00	DIA	ETF	252.72	253.52	252.72	253.07	5520.0
2018-08-14 06:00:00	DIA	ETF	253.33	253.33	253.33	253.33	100.0
2018-08-14 07:00:00	DIA	ETF	253.34	253.35	253.25	253.25	1593.0

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

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