PREVIEW / etf_1hour / 2019-01-10

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-01-10.parquet
  size:    323 KB
  rows:    10,726

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
2019-01-10 04:00:00	SPY	ETF	255.92	256.3	255.74	256.0	51589.0
2019-01-10 05:00:00	SPY	ETF	256.06	256.57	255.89	256.0	76963.0
2019-01-10 06:00:00	SPY	ETF	256.08	256.25	255.9	256.19	46351.0
2019-01-10 07:00:00	SPY	ETF	256.16	256.58	256.0	256.45	148681.0
2019-01-10 08:00:00	SPY	ETF	256.32	256.75	255.46	256.24	734718.0
2019-01-10 09:00:00	SPY	ETF	256.22	256.49	255.5	255.9227	8643274.0
2019-01-10 10:00:00	SPY	ETF	255.93	257.6	255.73	257.55	13371241.0
2019-01-10 11:00:00	SPY	ETF	257.55	258.33	257.37	258.14	12018456.0
2019-01-10 12:00:00	SPY	ETF	258.135	258.69	257.67	258.2701	7756340.0
2019-01-10 13:00:00	SPY	ETF	258.28	258.32	256.66	257.445	11498793.0
2019-01-10 14:00:00	SPY	ETF	257.44	258.84	257.419	258.28	14783468.0
2019-01-10 15:00:00	SPY	ETF	258.28	259.16	258.12	258.96	19636939.0
2019-01-10 16:00:00	SPY	ETF	258.94	259.21	256.25	258.77	6449363.0
2019-01-10 17:00:00	SPY	ETF	258.74	258.88	258.66	258.72	108731.0
2019-01-10 18:00:00	SPY	ETF	258.71	258.71	258.26	258.46	224032.0
2019-01-10 19:00:00	SPY	ETF	258.44	258.92	258.44	258.57	115228.0
2019-01-10 04:00:00	QQQ	ETF	159.42	159.67	159.21	159.48	44244.0
2019-01-10 05:00:00	QQQ	ETF	159.47	159.83	159.4	159.4	53578.0
2019-01-10 06:00:00	QQQ	ETF	159.5	159.65	159.44	159.6	17511.0
2019-01-10 07:00:00	QQQ	ETF	159.6	159.82	159.35	159.68	181804.0
2019-01-10 08:00:00	QQQ	ETF	159.69	160.82	159.05	159.6	214863.0
2019-01-10 09:00:00	QQQ	ETF	159.59	159.72	158.7	159.0	4458097.0
2019-01-10 10:00:00	QQQ	ETF	158.9915	160.5	158.9201	160.39	5921005.0
2019-01-10 11:00:00	QQQ	ETF	160.4	160.69	160.06	160.59	3309477.0
2019-01-10 12:00:00	QQQ	ETF	160.58	161.14	160.28	160.89	3531857.0
2019-01-10 13:00:00	QQQ	ETF	160.91	160.93	159.61	160.2	4803299.0
2019-01-10 14:00:00	QQQ	ETF	160.18	161.12	160.18	160.77	4104358.0
2019-01-10 15:00:00	QQQ	ETF	160.77	161.37	160.67	161.23	6119285.0
2019-01-10 16:00:00	QQQ	ETF	161.22	161.46	161.02	161.1	1943366.0
2019-01-10 17:00:00	QQQ	ETF	161.15	161.15	161.06	161.06	8184.0
2019-01-10 18:00:00	QQQ	ETF	161.06	161.06	160.77	160.89	57084.0
2019-01-10 19:00:00	QQQ	ETF	160.88	161.2	160.88	160.99	117608.0
2019-01-10 04:00:00	IWM	ETF	141.93	142.07	141.77	141.99	6800.0
2019-01-10 05:00:00	IWM	ETF	142.08	142.24	141.99	141.99	2400.0
2019-01-10 06:00:00	IWM	ETF	141.99	142.05	141.99	142.0	4050.0
2019-01-10 07:00:00	IWM	ETF	142.07	142.1	141.92	142.1	20400.0
2019-01-10 08:00:00	IWM	ETF	142.13	142.27	142.01	142.1	73378.0
2019-01-10 09:00:00	IWM	ETF	142.1	142.21	141.35	141.68	3197072.0
2019-01-10 10:00:00	IWM	ETF	141.68	142.77	141.59	142.72	3081609.0
2019-01-10 11:00:00	IWM	ETF	142.7238	143.3	142.52	143.28	2012812.0
2019-01-10 12:00:00	IWM	ETF	143.2715	143.71	143.07	143.519	1931823.0
2019-01-10 13:00:00	IWM	ETF	143.52	143.58	142.27	142.7621	2864179.0
2019-01-10 14:00:00	IWM	ETF	142.76	143.5117	142.76	143.3	1599342.0
2019-01-10 15:00:00	IWM	ETF	143.28	143.72	143.2	143.62	3769956.0
2019-01-10 16:00:00	IWM	ETF	143.65	143.74	143.46	143.57	1937122.0
2019-01-10 17:00:00	IWM	ETF	143.54	143.64	143.54	143.61	39131.0
2019-01-10 18:00:00	IWM	ETF	143.51	143.51	143.36	143.4	55041.0
2019-01-10 19:00:00	IWM	ETF	143.46	143.65	143.46	143.55	10636.0
2019-01-10 04:00:00	DIA	ETF	237.16	237.16	237.16	237.16	186.0
2019-01-10 05:00:00	DIA	ETF	237.44	237.44	237.44	237.44	600.0

> showing 50 of 10,726 rows — these rows as CSV

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