PREVIEW / etf_1hour / 2019-09-06

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-09-06.parquet
  size:    330 KB
  rows:    10,875

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-09-06 04:00:00	SPY	ETF	298.12	298.14	298.0	298.03	8256.0
2019-09-06 05:00:00	SPY	ETF	298.25	298.66	298.01	298.01	28553.0
2019-09-06 06:00:00	SPY	ETF	298.0	298.33	297.89	298.22	46417.0
2019-09-06 07:00:00	SPY	ETF	298.24	298.64	298.18	298.6	432871.0
2019-09-06 08:00:00	SPY	ETF	298.2699	298.98	297.88	298.26	1695346.0
2019-09-06 09:00:00	SPY	ETF	298.31	298.55	297.42	297.95	7868601.0
2019-09-06 10:00:00	SPY	ETF	297.96	298.61	297.74	298.42	5691267.0
2019-09-06 11:00:00	SPY	ETF	298.43	298.52	298.11	298.22	3667790.0
2019-09-06 12:00:00	SPY	ETF	298.225	298.44	297.77	298.21	5284434.0
2019-09-06 13:00:00	SPY	ETF	298.21	298.76	298.18	298.6249	3939082.0
2019-09-06 14:00:00	SPY	ETF	298.63	298.65	298.32	298.41	4096352.0
2019-09-06 15:00:00	SPY	ETF	298.4	298.72	297.88	298.07	11992074.0
2019-09-06 16:00:00	SPY	ETF	298.09	298.49	297.99	298.47	3933184.0
2019-09-06 17:00:00	SPY	ETF	298.47	298.72	298.05	298.66	216744.0
2019-09-06 18:00:00	SPY	ETF	298.63	298.7	298.6	298.61	22462.0
2019-09-06 19:00:00	SPY	ETF	298.61	298.66	298.58	298.6	46385.0
2019-09-06 04:00:00	QQQ	ETF	191.94	191.96	191.88	191.94	3950.0
2019-09-06 05:00:00	QQQ	ETF	191.99	192.35	191.81	191.81	45318.0
2019-09-06 06:00:00	QQQ	ETF	191.72	192.0	191.72	191.98	22959.0
2019-09-06 07:00:00	QQQ	ETF	191.99	192.24	191.94	192.18	224551.0
2019-09-06 08:00:00	QQQ	ETF	192.03	192.51	191.71	191.9	429716.0
2019-09-06 09:00:00	QQQ	ETF	191.91	192.18	191.2299	191.46	3032913.0
2019-09-06 10:00:00	QQQ	ETF	191.48	192.1	191.29	191.94	2031699.0
2019-09-06 11:00:00	QQQ	ETF	191.94	192.05	191.62	191.66	1516940.0
2019-09-06 12:00:00	QQQ	ETF	191.66	191.79	191.17	191.64	1458365.0
2019-09-06 13:00:00	QQQ	ETF	191.64	192.13	191.6	192.06	1482774.0
2019-09-06 14:00:00	QQQ	ETF	192.07	192.085	191.91	191.98	891212.0
2019-09-06 15:00:00	QQQ	ETF	191.9794	192.17	191.47	191.59	3164707.0
2019-09-06 16:00:00	QQQ	ETF	191.59	191.84	191.52	191.78	1050265.0
2019-09-06 17:00:00	QQQ	ETF	191.81	191.81	191.59	191.75	10280.0
2019-09-06 18:00:00	QQQ	ETF	191.8	191.83	191.76	191.76	750.0
2019-09-06 19:00:00	QQQ	ETF	191.76	192.0	191.76	192.0	9095.0
2019-09-06 04:00:00	IWM	ETF	150.76	150.76	150.76	150.76	100.0
2019-09-06 05:00:00	IWM	ETF	150.84	151.04	150.74	150.74	11500.0
2019-09-06 06:00:00	IWM	ETF	150.71	150.89	150.69	150.88	7000.0
2019-09-06 07:00:00	IWM	ETF	150.81	151.05	150.81	151.05	36571.0
2019-09-06 08:00:00	IWM	ETF	150.92	151.21	150.7	150.95	156112.0
2019-09-06 09:00:00	IWM	ETF	150.97	151.01	150.14	150.51	2432095.0
2019-09-06 10:00:00	IWM	ETF	150.5	151.23	150.32	151.05	1388739.0
2019-09-06 11:00:00	IWM	ETF	151.07	151.21	150.84	150.9658	829352.0
2019-09-06 12:00:00	IWM	ETF	150.96	151.215	150.62	150.8	825915.0
2019-09-06 13:00:00	IWM	ETF	150.8	150.95	150.49	150.825	744583.0
2019-09-06 14:00:00	IWM	ETF	150.835	150.875	150.23	150.3	1253308.0
2019-09-06 15:00:00	IWM	ETF	150.3	150.52	149.83	149.92	3584825.0
2019-09-06 16:00:00	IWM	ETF	149.92	150.09	149.85	150.04	591230.0
2019-09-06 17:00:00	IWM	ETF	149.9	150.4899	149.9	150.4899	356971.0
2019-09-06 18:00:00	IWM	ETF	150.06	150.06	150.06	150.06	179.0
2019-09-06 19:00:00	IWM	ETF	150.2	150.2	150.2	150.2	100.0
2019-09-06 04:00:00	DIA	ETF	267.98	267.98	267.84	267.84	800.0
2019-09-06 05:00:00	DIA	ETF	268.26	268.26	268.08	268.08	200.0

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

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