PREVIEW / etf_1hour / 2018-12-19

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-12-19.parquet
  size:    340 KB
  rows:    11,067

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-12-19 04:00:00	SPY	ETF	255.46	255.97	255.46	255.97	52910.0
2018-12-19 05:00:00	SPY	ETF	255.93	256.37	255.93	256.14	74779.0
2018-12-19 06:00:00	SPY	ETF	256.11	256.22	255.95	256.13	126617.0
2018-12-19 07:00:00	SPY	ETF	256.13	256.51	256.09	256.2	412439.0
2018-12-19 08:00:00	SPY	ETF	256.18	256.45	255.38	255.56	406816.0
2018-12-19 09:00:00	SPY	ETF	255.56	257.42	254.95	256.91	11038205.0
2018-12-19 10:00:00	SPY	ETF	256.91	257.75	256.87	257.64	15322476.0
2018-12-19 11:00:00	SPY	ETF	257.63	257.69	256.55	257.6075	12271524.0
2018-12-19 12:00:00	SPY	ETF	257.6	258.38	257.52	257.64	9525548.0
2018-12-19 13:00:00	SPY	ETF	257.64	259.12	256.76	258.87	11107362.0
2018-12-19 14:00:00	SPY	ETF	258.87	259.4	251.55	252.24	61569001.0
2018-12-19 15:00:00	SPY	ETF	252.24	252.27	249.35	251.2	74800792.0
2018-12-19 16:00:00	SPY	ETF	251.16	257.5553	250.0	250.76	15243779.0
2018-12-19 17:00:00	SPY	ETF	250.7	250.76	250.43	250.71	283845.0
2018-12-19 18:00:00	SPY	ETF	250.71	251.68	250.15	251.44	461567.0
2018-12-19 19:00:00	SPY	ETF	251.46	251.72	251.07	251.57	105372.0
2018-12-19 20:00:00	SPY	ETF	251.26	251.81	251.26	251.81	800.0
2018-12-19 04:00:00	QQQ	ETF	158.5	158.78	158.5	158.66	9738.0
2018-12-19 05:00:00	QQQ	ETF	158.8	159.2	158.78	159.06	24622.0
2018-12-19 06:00:00	QQQ	ETF	159.05	159.09	158.91	159.09	19144.0
2018-12-19 07:00:00	QQQ	ETF	159.06	159.28	158.96	159.01	83981.0
2018-12-19 08:00:00	QQQ	ETF	159.1299	159.26	158.39	158.5	162395.0
2018-12-19 09:00:00	QQQ	ETF	158.49	160.239	157.93	159.92	4660078.0
2018-12-19 10:00:00	QQQ	ETF	159.93	160.42	159.77	160.135	5118436.0
2018-12-19 11:00:00	QQQ	ETF	160.14	160.179	159.22	160.05	3232457.0
2018-12-19 12:00:00	QQQ	ETF	160.08	160.35	159.5986	159.62	2984390.0
2018-12-19 13:00:00	QQQ	ETF	159.61	160.45	159.0	160.4175	4091480.0
2018-12-19 14:00:00	QQQ	ETF	160.34	160.72	155.1231	155.69	19485984.0
2018-12-19 15:00:00	QQQ	ETF	155.69	155.7	153.34	154.78	25160641.0
2018-12-19 16:00:00	QQQ	ETF	154.77	155.06	154.0	154.53	2861487.0
2018-12-19 17:00:00	QQQ	ETF	154.49	154.64	154.25	154.52	3467347.0
2018-12-19 18:00:00	QQQ	ETF	154.55	155.21	154.15	155.05	259612.0
2018-12-19 19:00:00	QQQ	ETF	155.17	155.3	154.8	155.19	77078.0
2018-12-19 04:00:00	IWM	ETF	136.88	137.4	136.88	137.4	1200.0
2018-12-19 05:00:00	IWM	ETF	137.41	137.56	137.35	137.37	9381.0
2018-12-19 06:00:00	IWM	ETF	137.4	137.43	137.25	137.25	2328.0
2018-12-19 07:00:00	IWM	ETF	137.42	137.56	137.4	137.52	8404.0
2018-12-19 08:00:00	IWM	ETF	137.4199	137.45	137.07	137.18	32245.0
2018-12-19 09:00:00	IWM	ETF	137.18	137.8	136.72	137.32	2477914.0
2018-12-19 10:00:00	IWM	ETF	137.31	137.81	137.0699	137.52	3219922.0
2018-12-19 11:00:00	IWM	ETF	137.54	137.81	137.03	137.77	2825028.0
2018-12-19 12:00:00	IWM	ETF	137.79	138.25	137.68	137.87	2240079.0
2018-12-19 13:00:00	IWM	ETF	137.86	138.65	137.64	138.25	2704957.0
2018-12-19 14:00:00	IWM	ETF	138.47	138.68	134.45	134.79	12399835.0
2018-12-19 15:00:00	IWM	ETF	134.81	134.82	133.25	134.03	13757889.0
2018-12-19 16:00:00	IWM	ETF	134.02	134.17	133.07	133.5	1135085.0
2018-12-19 17:00:00	IWM	ETF	134.0	134.0	133.45	134.0	1005683.0
2018-12-19 18:00:00	IWM	ETF	133.57	134.0	133.34	133.87	98163.0
2018-12-19 19:00:00	IWM	ETF	133.87	133.95	133.65	133.95	8858.0
2018-12-19 04:00:00	DIA	ETF	237.8	238.08	237.8	238.08	430.0

> showing 50 of 11,067 rows — these rows as CSV

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