PREVIEW / etf_1hour / 2018-06-04

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-06-04.parquet
  size:    298 KB
  rows:    9,781

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-06-04 04:00:00	SPY	ETF	274.35	274.6	274.31	274.6	30070.0
2018-06-04 05:00:00	SPY	ETF	274.6	274.9	274.59	274.6	35042.0
2018-06-04 06:00:00	SPY	ETF	274.63	274.8	274.51	274.59	103188.0
2018-06-04 07:00:00	SPY	ETF	274.55	274.72	274.32	274.48	165354.0
2018-06-04 08:00:00	SPY	ETF	274.55	274.68	274.32	274.5	524308.0
2018-06-04 09:00:00	SPY	ETF	274.49	275.185	274.26	275.04	6702401.0
2018-06-04 10:00:00	SPY	ETF	275.035	275.17	274.325	274.65	6928459.0
2018-06-04 11:00:00	SPY	ETF	274.65	274.84	274.265	274.67	3707036.0
2018-06-04 12:00:00	SPY	ETF	274.675	274.99	274.49	274.87	3026824.0
2018-06-04 13:00:00	SPY	ETF	274.87	275.03	274.61	274.7125	3258322.0
2018-06-04 14:00:00	SPY	ETF	274.71	274.99	274.6901	274.96	3725950.0
2018-06-04 15:00:00	SPY	ETF	274.96	275.08	274.76	274.9	12391434.0
2018-06-04 16:00:00	SPY	ETF	274.9	274.9274	274.77	274.9	2834076.0
2018-06-04 17:00:00	SPY	ETF	274.91	274.9279	274.75	274.8	176244.0
2018-06-04 18:00:00	SPY	ETF	274.8	274.87	274.65	274.72	109085.0
2018-06-04 19:00:00	SPY	ETF	274.72	274.8	274.72	274.78	10636.0
2018-06-04 04:00:00	QQQ	ETF	172.8	173.45	172.8	173.45	10553.0
2018-06-04 05:00:00	QQQ	ETF	173.5	173.55	173.41	173.41	17213.0
2018-06-04 06:00:00	QQQ	ETF	173.44	173.5	173.32	173.33	24160.0
2018-06-04 07:00:00	QQQ	ETF	173.3	173.3	173.06	173.16	279675.0
2018-06-04 08:00:00	QQQ	ETF	173.26	173.3	173.04	173.23	204225.0
2018-06-04 09:00:00	QQQ	ETF	173.23	173.78	173.07	173.6362	2488909.0
2018-06-04 10:00:00	QQQ	ETF	173.65	173.75	173.15	173.67	2258660.0
2018-06-04 11:00:00	QQQ	ETF	173.68	173.85	173.46	173.79	1506932.0
2018-06-04 12:00:00	QQQ	ETF	173.785	174.31	173.67	174.19	1868375.0
2018-06-04 13:00:00	QQQ	ETF	174.19	174.34	173.93	174.03	1534699.0
2018-06-04 14:00:00	QQQ	ETF	174.0316	174.26	173.99	174.24	1358569.0
2018-06-04 15:00:00	QQQ	ETF	174.23	174.3	174.105	174.22	4167453.0
2018-06-04 16:00:00	QQQ	ETF	174.22	174.31	174.15	174.25	862390.0
2018-06-04 17:00:00	QQQ	ETF	174.22	174.3	174.22	174.22	3609.0
2018-06-04 18:00:00	QQQ	ETF	174.25	174.3	174.12	174.15	447097.0
2018-06-04 19:00:00	QQQ	ETF	174.15	174.29	174.13	174.22	23991.0
2018-06-04 04:00:00	IWM	ETF	164.49	164.7	164.49	164.53	3800.0
2018-06-04 05:00:00	IWM	ETF	164.64	164.79	164.64	164.65	2746.0
2018-06-04 06:00:00	IWM	ETF	164.68	164.68	164.63	164.63	1290.0
2018-06-04 07:00:00	IWM	ETF	164.5	164.56	164.43	164.48	81431.0
2018-06-04 08:00:00	IWM	ETF	164.48	164.59	164.35	164.37	78510.0
2018-06-04 09:00:00	IWM	ETF	164.37	164.58	164.02	164.06	2038985.0
2018-06-04 10:00:00	IWM	ETF	164.06	164.18	163.32	163.64	2470499.0
2018-06-04 11:00:00	IWM	ETF	163.64	164.13	163.47	164.09	1089744.0
2018-06-04 12:00:00	IWM	ETF	164.11	164.21	163.9	164.13	1107158.0
2018-06-04 13:00:00	IWM	ETF	164.12	164.3	163.96	164.02	1309920.0
2018-06-04 14:00:00	IWM	ETF	164.02	164.32	163.98	164.29	784364.0
2018-06-04 15:00:00	IWM	ETF	164.29	164.71	164.25	164.69	3657348.0
2018-06-04 16:00:00	IWM	ETF	164.69	164.71	164.43	164.66	690136.0
2018-06-04 17:00:00	IWM	ETF	164.66	164.72	164.61	164.61	3877.0
2018-06-04 18:00:00	IWM	ETF	164.7	164.7	164.58	164.6	4653.0
2018-06-04 19:00:00	IWM	ETF	164.6	164.65	164.58	164.65	4461.0
2018-06-04 04:00:00	DIA	ETF	247.1	247.45	247.1	247.45	796.0
2018-06-04 05:00:00	DIA	ETF	247.48	247.88	247.48	247.88	900.0

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

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