PREVIEW / etf_1hour / 2020-06-18

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-06-18.parquet
  size:    353 KB
  rows:    12,157

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
2020-06-18 04:00:00	SPY	ETF	311.56	313.21	311.15	312.9	101928.0
2020-06-18 05:00:00	SPY	ETF	312.72	313.29	311.96	312.26	85336.0
2020-06-18 06:00:00	SPY	ETF	312.17	312.17	311.29	311.73	53805.0
2020-06-18 07:00:00	SPY	ETF	311.68	311.94	309.47	309.56	597134.0
2020-06-18 08:00:00	SPY	ETF	310.7801	311.94	308.8	310.19	1483280.0
2020-06-18 09:00:00	SPY	ETF	310.2	311.55	309.48	310.78	8128801.0
2020-06-18 10:00:00	SPY	ETF	310.76	312.3	310.22	312.21	10634209.0
2020-06-18 11:00:00	SPY	ETF	312.2	312.3	310.75	310.9199	6531757.0
2020-06-18 12:00:00	SPY	ETF	310.9	311.58	310.44	311.39	6432078.0
2020-06-18 13:00:00	SPY	ETF	311.38	311.99	311.16	311.845	3220264.0
2020-06-18 14:00:00	SPY	ETF	311.85	311.929	310.47	310.53	9732310.0
2020-06-18 15:00:00	SPY	ETF	310.52	312.0	310.06	311.74	20033066.0
2020-06-18 16:00:00	SPY	ETF	311.74	311.97	311.11	311.38	12279128.0
2020-06-18 17:00:00	SPY	ETF	311.28	311.78	311.28	311.31	207551.0
2020-06-18 18:00:00	SPY	ETF	311.31	312.18	311.1	312.1	247478.0
2020-06-18 19:00:00	SPY	ETF	312.14	313.03	312.12	312.93	221900.0
2020-06-18 04:00:00	QQQ	ETF	243.77	244.93	243.68	244.76	79267.0
2020-06-18 05:00:00	QQQ	ETF	244.81	245.02	244.18	244.26	57275.0
2020-06-18 06:00:00	QQQ	ETF	244.26	244.34	243.8	243.91	35258.0
2020-06-18 07:00:00	QQQ	ETF	243.98	244.25	242.88	242.97	165190.0
2020-06-18 08:00:00	QQQ	ETF	243.7401	244.03	242.67	243.68	359449.0
2020-06-18 09:00:00	QQQ	ETF	243.64	244.04	242.96	243.48	3482198.0
2020-06-18 10:00:00	QQQ	ETF	243.47	244.255	242.49	244.22	4970746.0
2020-06-18 11:00:00	QQQ	ETF	244.21	244.53	243.39	243.54	2862236.0
2020-06-18 12:00:00	QQQ	ETF	243.5	243.93	243.19	243.79	2269193.0
2020-06-18 13:00:00	QQQ	ETF	243.79	244.29	243.62	244.179	1858138.0
2020-06-18 14:00:00	QQQ	ETF	244.17	244.24	243.11	243.111	2208227.0
2020-06-18 15:00:00	QQQ	ETF	243.1388	244.46	242.7659	244.29	4652481.0
2020-06-18 16:00:00	QQQ	ETF	244.3	244.42	243.8	244.07	498259.0
2020-06-18 17:00:00	QQQ	ETF	244.14	244.28	243.98	244.28	33422.0
2020-06-18 18:00:00	QQQ	ETF	244.05	244.48	244.0	244.48	54021.0
2020-06-18 19:00:00	QQQ	ETF	244.48	245.0	244.48	244.82	63892.0
2020-06-18 04:00:00	IWM	ETF	141.39	142.93	141.39	142.62	48465.0
2020-06-18 05:00:00	IWM	ETF	142.6	142.83	141.69	141.79	39200.0
2020-06-18 06:00:00	IWM	ETF	141.5	141.95	141.36	141.84	22539.0
2020-06-18 07:00:00	IWM	ETF	141.85	141.96	140.05	140.16	303541.0
2020-06-18 08:00:00	IWM	ETF	140.14	141.9204	139.73	140.63	523686.0
2020-06-18 09:00:00	IWM	ETF	140.43	142.01	139.81	141.31	3552331.0
2020-06-18 10:00:00	IWM	ETF	141.29	143.31	141.29	143.2101	3029395.0
2020-06-18 11:00:00	IWM	ETF	143.215	143.23	141.305	141.48	2469726.0
2020-06-18 12:00:00	IWM	ETF	141.46	141.99	141.18	141.82	1753375.0
2020-06-18 13:00:00	IWM	ETF	141.82	142.245	141.685	142.22	1279692.0
2020-06-18 14:00:00	IWM	ETF	142.23	142.29	141.545	141.56	1967957.0
2020-06-18 15:00:00	IWM	ETF	141.56	141.95	141.2	141.79	3688569.0
2020-06-18 16:00:00	IWM	ETF	141.72	141.86	141.0	141.2	1115563.0
2020-06-18 17:00:00	IWM	ETF	140.88	141.806	140.88	141.21	240649.0
2020-06-18 18:00:00	IWM	ETF	141.12	141.919	141.12	141.88	37804.0
2020-06-18 19:00:00	IWM	ETF	141.89	142.7	141.87	142.6	53657.0
2020-06-18 04:00:00	DIA	ETF	261.5	263.38	261.36	263.03	4950.0
2020-06-18 05:00:00	DIA	ETF	262.78	262.98	262.23	262.23	4700.0

> showing 50 of 12,157 rows — these rows as CSV

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