PREVIEW / etf_1hour / 2018-08-08

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-08-08.parquet
  size:    293 KB
  rows:    9,662

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-08 04:00:00	SPY	ETF	285.56	285.61	285.45	285.6	1600.0
2018-08-08 05:00:00	SPY	ETF	285.63	285.63	285.55	285.63	1600.0
2018-08-08 06:00:00	SPY	ETF	285.63	285.75	285.63	285.75	8850.0
2018-08-08 07:00:00	SPY	ETF	285.71	285.8	285.6	285.6	20640.0
2018-08-08 08:00:00	SPY	ETF	285.73	285.73	285.16	285.28	262378.0
2018-08-08 09:00:00	SPY	ETF	285.26	285.47	285.04	285.165	3812145.0
2018-08-08 10:00:00	SPY	ETF	285.17	285.6	284.94	285.57	5229836.0
2018-08-08 11:00:00	SPY	ETF	285.58	285.76	285.39	285.42	3303421.0
2018-08-08 12:00:00	SPY	ETF	285.43	285.625	285.21	285.435	2383432.0
2018-08-08 13:00:00	SPY	ETF	285.435	285.7	285.37	285.68	2970437.0
2018-08-08 14:00:00	SPY	ETF	285.68	285.77	285.55	285.65	2976454.0
2018-08-08 15:00:00	SPY	ETF	285.645	285.91	285.37	285.42	12284600.0
2018-08-08 16:00:00	SPY	ETF	285.41	285.4918	284.95	285.01	7434257.0
2018-08-08 17:00:00	SPY	ETF	285.02	285.07	284.95	285.01	104209.0
2018-08-08 18:00:00	SPY	ETF	284.97	285.17	284.95	285.13	73176.0
2018-08-08 19:00:00	SPY	ETF	285.12	285.17	285.08	285.14	20975.0
2018-08-08 04:00:00	QQQ	ETF	181.78	181.84	181.76	181.78	12658.0
2018-08-08 05:00:00	QQQ	ETF	181.85	181.92	181.78	181.83	3903.0
2018-08-08 06:00:00	QQQ	ETF	181.9	181.9	181.87	181.9	4438.0
2018-08-08 07:00:00	QQQ	ETF	181.91	181.99	181.79	181.79	35825.0
2018-08-08 08:00:00	QQQ	ETF	181.9399	181.9399	181.33	181.4	188705.0
2018-08-08 09:00:00	QQQ	ETF	181.44	181.74	181.06	181.54	2998382.0
2018-08-08 10:00:00	QQQ	ETF	181.54	182.35	181.41	182.25	3744381.0
2018-08-08 11:00:00	QQQ	ETF	182.26	182.29	181.77	181.79	2207206.0
2018-08-08 12:00:00	QQQ	ETF	181.79	182.07	181.631	181.91	1516503.0
2018-08-08 13:00:00	QQQ	ETF	181.9	182.05	181.81	182.0348	1534613.0
2018-08-08 14:00:00	QQQ	ETF	182.035	182.2364	181.88	182.09	2143159.0
2018-08-08 15:00:00	QQQ	ETF	182.085	182.28	181.89	181.92	3397453.0
2018-08-08 16:00:00	QQQ	ETF	181.92	182.02	181.52	181.55	2300390.0
2018-08-08 17:00:00	QQQ	ETF	182.02	182.02	181.46	181.53	70170.0
2018-08-08 18:00:00	QQQ	ETF	181.54	181.72	181.52	181.72	45852.0
2018-08-08 19:00:00	QQQ	ETF	181.7	181.72	181.65	181.69	12236.0
2018-08-08 04:00:00	IWM	ETF	167.77	167.77	167.77	167.77	100.0
2018-08-08 07:00:00	IWM	ETF	167.82	167.84	167.73	167.74	11902.0
2018-08-08 08:00:00	IWM	ETF	167.7	167.7	167.37	167.6	123598.0
2018-08-08 09:00:00	IWM	ETF	167.62	167.76	167.21	167.28	1305812.0
2018-08-08 10:00:00	IWM	ETF	167.28	167.42	166.49	167.2	2871734.0
2018-08-08 11:00:00	IWM	ETF	167.2	167.61	167.06	167.35	2080424.0
2018-08-08 12:00:00	IWM	ETF	167.35	167.68	167.27	167.4566	1340326.0
2018-08-08 13:00:00	IWM	ETF	167.46	167.98	167.46	167.93	1261896.0
2018-08-08 14:00:00	IWM	ETF	167.91	167.985	167.675	167.73	982340.0
2018-08-08 15:00:00	IWM	ETF	167.72	167.91	167.53	167.58	1951462.0
2018-08-08 16:00:00	IWM	ETF	167.57	167.6104	167.35	167.37	764645.0
2018-08-08 17:00:00	IWM	ETF	167.5	167.5	167.5	167.5	101.0
2018-08-08 18:00:00	IWM	ETF	167.47	167.47	167.47	167.47	500.0
2018-08-08 19:00:00	IWM	ETF	167.47	167.48	167.45	167.46	3000.0
2018-08-08 07:00:00	DIA	ETF	256.37	256.37	256.37	256.37	150.0
2018-08-08 08:00:00	DIA	ETF	256.2	256.2	255.81	255.81	1588.0
2018-08-08 09:00:00	DIA	ETF	256.01	256.121	255.57	255.7	315385.0
2018-08-08 10:00:00	DIA	ETF	255.72	255.869	255.38	255.8101	225752.0

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

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