PREVIEW / etf_1hour / 2019-07-12

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-07-12.parquet
  size:    326 KB
  rows:    10,693

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-07-12 04:00:00	SPY	ETF	299.84	300.06	299.84	300.05	15652.0
2019-07-12 05:00:00	SPY	ETF	300.07	300.16	300.02	300.08	41599.0
2019-07-12 06:00:00	SPY	ETF	300.13	300.2	299.85	300.01	54127.0
2019-07-12 07:00:00	SPY	ETF	300.0	300.08	299.86	300.0	85218.0
2019-07-12 08:00:00	SPY	ETF	299.99	300.13	299.31	299.96	215849.0
2019-07-12 09:00:00	SPY	ETF	299.99	300.02	299.62	299.75	4551076.0
2019-07-12 10:00:00	SPY	ETF	299.75	300.0	299.51	299.615	4999739.0
2019-07-12 11:00:00	SPY	ETF	299.62	300.06	299.52	299.97	3729597.0
2019-07-12 12:00:00	SPY	ETF	299.97	300.11	299.81	300.1	3897979.0
2019-07-12 13:00:00	SPY	ETF	300.105	300.14	299.91	299.9901	2000955.0
2019-07-12 14:00:00	SPY	ETF	299.99	300.36	299.97	300.35	4568261.0
2019-07-12 15:00:00	SPY	ETF	300.34	300.73	300.16	300.68	11228917.0
2019-07-12 16:00:00	SPY	ETF	300.68	300.7152	300.37	300.37	3949665.0
2019-07-12 17:00:00	SPY	ETF	300.42	300.65	300.38	300.4	75509.0
2019-07-12 18:00:00	SPY	ETF	300.47	300.49	300.38	300.38	18000.0
2019-07-12 19:00:00	SPY	ETF	300.43	300.5	300.37	300.44	14249.0
2019-07-12 04:00:00	QQQ	ETF	192.69	192.99	192.69	192.96	17214.0
2019-07-12 05:00:00	QQQ	ETF	192.96	193.02	192.9	192.95	22292.0
2019-07-12 06:00:00	QQQ	ETF	192.99	193.1	192.77	192.87	52654.0
2019-07-12 07:00:00	QQQ	ETF	192.89	192.96	192.72	192.81	60207.0
2019-07-12 08:00:00	QQQ	ETF	192.9101	192.98	192.72	192.75	124229.0
2019-07-12 09:00:00	QQQ	ETF	192.75	193.105	192.56	192.88	1844289.0
2019-07-12 10:00:00	QQQ	ETF	192.86	193.15	192.45	192.66	2769210.0
2019-07-12 11:00:00	QQQ	ETF	192.6641	193.15	192.58	193.14	1515491.0
2019-07-12 12:00:00	QQQ	ETF	193.14	193.335	193.07	193.32	1472062.0
2019-07-12 13:00:00	QQQ	ETF	193.31	193.366	193.06	193.131	1169091.0
2019-07-12 14:00:00	QQQ	ETF	193.14	193.31	193.117	193.3	1029525.0
2019-07-12 15:00:00	QQQ	ETF	193.3	193.54	193.13	193.52	3842270.0
2019-07-12 16:00:00	QQQ	ETF	193.52	193.57	193.34	193.36	2303666.0
2019-07-12 17:00:00	QQQ	ETF	193.33	193.53	193.33	193.42	49035.0
2019-07-12 18:00:00	QQQ	ETF	193.38	193.43	193.38	193.43	11498.0
2019-07-12 19:00:00	QQQ	ETF	193.43	193.46	193.42	193.46	4244.0
2019-07-12 04:00:00	IWM	ETF	155.23	155.27	155.18	155.18	5800.0
2019-07-12 05:00:00	IWM	ETF	155.18	155.18	155.18	155.18	800.0
2019-07-12 06:00:00	IWM	ETF	155.29	155.29	155.19	155.2	2100.0
2019-07-12 07:00:00	IWM	ETF	155.29	155.31	155.2	155.22	10825.0
2019-07-12 08:00:00	IWM	ETF	155.22	155.41	154.91	155.26	114249.0
2019-07-12 09:00:00	IWM	ETF	155.26	155.45	154.88	155.04	1469663.0
2019-07-12 10:00:00	IWM	ETF	155.04	155.83	155.03	155.58	1878489.0
2019-07-12 11:00:00	IWM	ETF	155.57	156.17	155.32	155.915	2182094.0
2019-07-12 12:00:00	IWM	ETF	155.91	156.0	155.47	155.995	1054554.0
2019-07-12 13:00:00	IWM	ETF	155.98	156.065	155.82	155.91	958666.0
2019-07-12 14:00:00	IWM	ETF	155.9	156.32	155.87	156.29	1717260.0
2019-07-12 15:00:00	IWM	ETF	156.29	156.67	156.1	156.1	4443827.0
2019-07-12 16:00:00	IWM	ETF	156.1	156.12	155.92	156.0	1255789.0
2019-07-12 17:00:00	IWM	ETF	155.99	156.0	155.92	155.92	5156.0
2019-07-12 18:00:00	IWM	ETF	155.92	155.95	155.92	155.92	3987.0
2019-07-12 19:00:00	IWM	ETF	155.94	155.96	155.9101	155.9101	8335.0
2019-07-12 04:00:00	DIA	ETF	271.43	271.81	271.43	271.81	875.0
2019-07-12 07:00:00	DIA	ETF	271.65	271.65	271.65	271.65	500.0

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

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