PREVIEW / etf_1hour / 2019-06-12

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-06-12.parquet
  size:    314 KB
  rows:    10,450

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-06-12 04:00:00	SPY	ETF	288.4	288.64	288.15	288.21	16589.0
2019-06-12 05:00:00	SPY	ETF	288.05	288.31	287.97	287.98	17984.0
2019-06-12 06:00:00	SPY	ETF	288.1	288.45	287.86	288.45	14806.0
2019-06-12 07:00:00	SPY	ETF	288.46	288.57	288.09	288.12	144193.0
2019-06-12 08:00:00	SPY	ETF	288.51	288.9	288.05	288.31	514003.0
2019-06-12 09:00:00	SPY	ETF	288.34	289.26	288.34	288.84	6433894.0
2019-06-12 10:00:00	SPY	ETF	288.84	288.98	288.04	288.32	8239846.0
2019-06-12 11:00:00	SPY	ETF	288.315	288.54	287.83	287.845	5081552.0
2019-06-12 12:00:00	SPY	ETF	287.85	288.58	287.815	288.425	5504649.0
2019-06-12 13:00:00	SPY	ETF	288.43	288.56	288.115	288.39	3899832.0
2019-06-12 14:00:00	SPY	ETF	288.3941	288.56	288.01	288.42	3351559.0
2019-06-12 15:00:00	SPY	ETF	288.42	288.47	288.0401	288.36	7266916.0
2019-06-12 16:00:00	SPY	ETF	288.33	288.54	288.27	288.43	5429694.0
2019-06-12 17:00:00	SPY	ETF	288.42	288.53	288.36	288.42	99786.0
2019-06-12 18:00:00	SPY	ETF	288.47	288.76	288.39	288.71	76274.0
2019-06-12 19:00:00	SPY	ETF	288.75	288.89	288.67	288.83	35138.0
2019-06-12 04:00:00	QQQ	ETF	182.63	182.92	182.55	182.55	17729.0
2019-06-12 05:00:00	QQQ	ETF	182.5	182.67	182.36	182.41	22921.0
2019-06-12 06:00:00	QQQ	ETF	182.49	182.74	182.34	182.72	22930.0
2019-06-12 07:00:00	QQQ	ETF	182.74	182.85	182.51	182.52	118753.0
2019-06-12 08:00:00	QQQ	ETF	182.83	183.21	182.51	182.7	254491.0
2019-06-12 09:00:00	QQQ	ETF	182.7	183.28	182.47	182.995	3312520.0
2019-06-12 10:00:00	QQQ	ETF	183.0	183.11	182.07	182.4	6241438.0
2019-06-12 11:00:00	QQQ	ETF	182.4	182.6999	182.11	182.13	2687253.0
2019-06-12 12:00:00	QQQ	ETF	182.13	182.63	182.0	182.52	2379100.0
2019-06-12 13:00:00	QQQ	ETF	182.52	182.66	182.2313	182.42	1003940.0
2019-06-12 14:00:00	QQQ	ETF	182.42	182.61	182.14	182.44	1359829.0
2019-06-12 15:00:00	QQQ	ETF	182.44	182.49	182.15	182.36	3567527.0
2019-06-12 16:00:00	QQQ	ETF	182.37	182.45	182.2	182.43	1407288.0
2019-06-12 17:00:00	QQQ	ETF	182.35	182.36	182.28	182.32	16791.0
2019-06-12 18:00:00	QQQ	ETF	182.33	182.63	182.33	182.55	58237.0
2019-06-12 19:00:00	QQQ	ETF	182.57	182.77	182.57	182.74	45670.0
2019-06-12 04:00:00	IWM	ETF	151.14	151.14	150.91	150.93	1270.0
2019-06-12 05:00:00	IWM	ETF	150.82	150.94	150.79	150.8	11700.0
2019-06-12 06:00:00	IWM	ETF	150.84	150.99	150.74	150.99	10500.0
2019-06-12 07:00:00	IWM	ETF	151.1	151.13	150.92	150.99	9391.0
2019-06-12 08:00:00	IWM	ETF	151.12	151.15	150.8699	151.0	22208.0
2019-06-12 09:00:00	IWM	ETF	151.08	151.54	150.7351	150.87	1270037.0
2019-06-12 10:00:00	IWM	ETF	150.87	151.49	150.62	151.0	1374147.0
2019-06-12 11:00:00	IWM	ETF	150.98	151.12	150.69	150.83	966361.0
2019-06-12 12:00:00	IWM	ETF	150.83	151.78	150.8184	151.55	1546294.0
2019-06-12 13:00:00	IWM	ETF	151.54	151.55	151.24	151.4767	696272.0
2019-06-12 14:00:00	IWM	ETF	151.48	151.73	151.27	151.59	1030762.0
2019-06-12 15:00:00	IWM	ETF	151.6	151.69	151.23	151.41	1826848.0
2019-06-12 16:00:00	IWM	ETF	151.39	151.69	151.3627	151.64	1546939.0
2019-06-12 17:00:00	IWM	ETF	151.6	151.6	151.57	151.57	1000.0
2019-06-12 18:00:00	IWM	ETF	151.63	151.8	151.63	151.77	22300.0
2019-06-12 19:00:00	IWM	ETF	151.8	151.89	151.79	151.85	7306.0
2019-06-12 06:00:00	DIA	ETF	259.88	259.88	259.84	259.84	5105.0
2019-06-12 07:00:00	DIA	ETF	260.83	260.86	259.95	260.01	8790.0

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

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