PREVIEW / etf_1hour / 2018-08-24

all etf 1-hour files

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

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-24 04:00:00	SPY	ETF	286.3	286.45	286.26	286.4	7820.0
2018-08-24 05:00:00	SPY	ETF	286.36	286.38	286.22	286.3	4400.0
2018-08-24 06:00:00	SPY	ETF	286.26	286.48	286.26	286.45	15362.0
2018-08-24 07:00:00	SPY	ETF	286.46	286.5	286.36	286.4	31138.0
2018-08-24 08:00:00	SPY	ETF	286.46	286.46	286.18	286.31	117333.0
2018-08-24 09:00:00	SPY	ETF	286.33	286.66	286.31	286.45	5350651.0
2018-08-24 10:00:00	SPY	ETF	286.46	287.415	286.45	287.195	10378093.0
2018-08-24 11:00:00	SPY	ETF	287.2	287.6	287.031	287.59	6686718.0
2018-08-24 12:00:00	SPY	ETF	287.59	287.6699	287.42	287.56	4201177.0
2018-08-24 13:00:00	SPY	ETF	287.56	287.67	287.03	287.38	4698399.0
2018-08-24 14:00:00	SPY	ETF	287.38	287.57	287.31	287.41	3710718.0
2018-08-24 15:00:00	SPY	ETF	287.4175	287.61	287.27	287.5	10299803.0
2018-08-24 16:00:00	SPY	ETF	287.51	287.69	285.7309	287.61	11354837.0
2018-08-24 17:00:00	SPY	ETF	287.59	287.63	287.52	287.53	40880.0
2018-08-24 18:00:00	SPY	ETF	287.55	287.65	287.53	287.65	5210.0
2018-08-24 19:00:00	SPY	ETF	287.55	287.65	287.55	287.63	16204.0
2018-08-24 04:00:00	QQQ	ETF	181.28	181.28	181.21	181.22	8470.0
2018-08-24 05:00:00	QQQ	ETF	181.22	181.22	181.15	181.16	2050.0
2018-08-24 06:00:00	QQQ	ETF	181.31	181.42	181.28	181.31	20900.0
2018-08-24 07:00:00	QQQ	ETF	181.38	181.41	181.26	181.3	46659.0
2018-08-24 08:00:00	QQQ	ETF	181.35	181.41	181.21	181.33	99899.0
2018-08-24 09:00:00	QQQ	ETF	181.33	181.77	181.3	181.54	2089928.0
2018-08-24 10:00:00	QQQ	ETF	181.55	182.5399	181.545	182.35	3720203.0
2018-08-24 11:00:00	QQQ	ETF	182.36	182.625	182.17	182.529	2845160.0
2018-08-24 12:00:00	QQQ	ETF	182.53	182.5799	182.38	182.455	1337182.0
2018-08-24 13:00:00	QQQ	ETF	182.45	182.5	182.09	182.32	1767467.0
2018-08-24 14:00:00	QQQ	ETF	182.31	182.56	182.2948	182.42	1025932.0
2018-08-24 15:00:00	QQQ	ETF	182.42	182.63	182.33	182.48	4618137.0
2018-08-24 16:00:00	QQQ	ETF	182.48	182.61	182.46	182.55	1202555.0
2018-08-24 17:00:00	QQQ	ETF	182.69	182.73	182.53	182.53	15738.0
2018-08-24 18:00:00	QQQ	ETF	182.55	182.55	182.53	182.53	845.0
2018-08-24 19:00:00	QQQ	ETF	182.54	182.6	182.54	182.58	6835.0
2018-08-24 04:00:00	IWM	ETF	170.88	171.13	170.88	171.13	300.0
2018-08-24 06:00:00	IWM	ETF	171.18	171.2	171.18	171.2	3000.0
2018-08-24 07:00:00	IWM	ETF	171.2	171.29	171.18	171.27	54600.0
2018-08-24 08:00:00	IWM	ETF	171.25	171.3	171.02	171.09	68200.0
2018-08-24 09:00:00	IWM	ETF	171.09	171.4655	171.06	171.21	985622.0
2018-08-24 10:00:00	IWM	ETF	171.21	171.78	171.1195	171.44	1602476.0
2018-08-24 11:00:00	IWM	ETF	171.435	171.5654	171.2	171.42	1026430.0
2018-08-24 12:00:00	IWM	ETF	171.43	171.67	171.36	171.66	953457.0
2018-08-24 13:00:00	IWM	ETF	171.66	171.67	171.02	171.26	945168.0
2018-08-24 14:00:00	IWM	ETF	171.25	171.45	171.1901	171.4	862099.0
2018-08-24 15:00:00	IWM	ETF	171.41	171.755	171.4	171.52	2510882.0
2018-08-24 16:00:00	IWM	ETF	171.5	171.69	171.5	171.59	2111263.0
2018-08-24 17:00:00	IWM	ETF	171.56	171.59	171.56	171.59	7450.0
2018-08-24 19:00:00	IWM	ETF	171.64	171.64	171.64	171.64	100.0
2018-08-24 07:00:00	DIA	ETF	257.24	257.36	257.24	257.36	3141.0
2018-08-24 08:00:00	DIA	ETF	257.24	257.32	257.17	257.32	1800.0
2018-08-24 09:00:00	DIA	ETF	257.15	257.32	256.99	257.12	376502.0
2018-08-24 10:00:00	DIA	ETF	257.14	258.01	257.04	257.8	831552.0

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

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