PREVIEW / etf_1hour / 2020-05-11

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-05-11.parquet
  size:    368 KB
  rows:    12,634

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-05-11 04:00:00	SPY	ETF	293.83	294.34	292.5	292.8	79788.0
2020-05-11 05:00:00	SPY	ETF	292.71	292.71	291.75	292.1	171116.0
2020-05-11 06:00:00	SPY	ETF	292.09	292.28	291.0	291.29	319609.0
2020-05-11 07:00:00	SPY	ETF	291.33	291.54	289.89	290.06	824413.0
2020-05-11 08:00:00	SPY	ETF	291.27	294.8	289.3399	289.78	1189083.0
2020-05-11 09:00:00	SPY	ETF	289.77	291.21	289.74	290.45	8967581.0
2020-05-11 10:00:00	SPY	ETF	290.45	291.41	290.38	290.88	10341309.0
2020-05-11 11:00:00	SPY	ETF	290.88	292.0	290.82	291.9471	6939267.0
2020-05-11 12:00:00	SPY	ETF	291.93	293.11	291.71	292.98	6725953.0
2020-05-11 13:00:00	SPY	ETF	292.98	294.0	292.77	293.3599	6390703.0
2020-05-11 14:00:00	SPY	ETF	293.345	293.74	292.71	293.49	7372785.0
2020-05-11 15:00:00	SPY	ETF	293.5	294.0	292.5	292.56	16089218.0
2020-05-11 16:00:00	SPY	ETF	292.58	293.0054	292.08	292.19	12976462.0
2020-05-11 17:00:00	SPY	ETF	292.32	292.5	292.13	292.4	155496.0
2020-05-11 18:00:00	SPY	ETF	292.33	293.06	292.26	292.55	211660.0
2020-05-11 19:00:00	SPY	ETF	292.5	292.75	291.65	291.94	312168.0
2020-05-11 04:00:00	QQQ	ETF	225.9	226.01	224.75	224.97	109837.0
2020-05-11 05:00:00	QQQ	ETF	224.88	225.05	224.43	224.94	72010.0
2020-05-11 06:00:00	QQQ	ETF	224.9	225.01	223.97	224.09	57654.0
2020-05-11 07:00:00	QQQ	ETF	224.28	224.47	223.2	223.3	199579.0
2020-05-11 08:00:00	QQQ	ETF	224.11	226.53	222.56	223.18	433418.0
2020-05-11 09:00:00	QQQ	ETF	223.18	225.11	223.15	224.67	4972696.0
2020-05-11 10:00:00	QQQ	ETF	224.66	225.85	224.61	225.24	5071798.0
2020-05-11 11:00:00	QQQ	ETF	225.26	226.14	225.13	226.131	3078565.0
2020-05-11 12:00:00	QQQ	ETF	226.12	226.56	225.845	226.47	3737284.0
2020-05-11 13:00:00	QQQ	ETF	226.48	227.54	226.34	227.175	3679665.0
2020-05-11 14:00:00	QQQ	ETF	227.17	227.64	226.83	227.53	3330034.0
2020-05-11 15:00:00	QQQ	ETF	227.5306	227.93	226.64	226.65	6418194.0
2020-05-11 16:00:00	QQQ	ETF	226.655	226.88	226.17	226.55	905649.0
2020-05-11 17:00:00	QQQ	ETF	226.38	226.7	226.38	226.5	268475.0
2020-05-11 18:00:00	QQQ	ETF	226.58	227.24	226.58	226.82	95689.0
2020-05-11 19:00:00	QQQ	ETF	226.78	227.01	226.16	226.48	139480.0
2020-05-11 04:00:00	IWM	ETF	132.84	133.0	132.08	132.1	32812.0
2020-05-11 05:00:00	IWM	ETF	132.05	132.05	131.6	131.75	49178.0
2020-05-11 06:00:00	IWM	ETF	131.75	131.75	131.0	131.28	25885.0
2020-05-11 07:00:00	IWM	ETF	131.38	131.48	130.18	130.18	134753.0
2020-05-11 08:00:00	IWM	ETF	131.02	133.53	129.56	130.18	304069.0
2020-05-11 09:00:00	IWM	ETF	130.21	130.87	129.655	129.8	3800515.0
2020-05-11 10:00:00	IWM	ETF	129.8	130.49	129.332	129.86	5409498.0
2020-05-11 11:00:00	IWM	ETF	129.87	130.97	129.76	130.96	5191068.0
2020-05-11 12:00:00	IWM	ETF	130.97	132.47	130.88	132.33	2840958.0
2020-05-11 13:00:00	IWM	ETF	132.32	132.95	132.08	132.24	2662938.0
2020-05-11 14:00:00	IWM	ETF	132.23	132.52	130.3846	132.23	3416915.0
2020-05-11 15:00:00	IWM	ETF	132.225	132.53	131.43	131.61	5311083.0
2020-05-11 16:00:00	IWM	ETF	131.62	131.71	130.8155	130.97	1185645.0
2020-05-11 17:00:00	IWM	ETF	131.0	131.7	130.93	131.05	74928.0
2020-05-11 18:00:00	IWM	ETF	131.09	131.7	130.86	131.09	75062.0
2020-05-11 19:00:00	IWM	ETF	131.12	131.27	130.7	130.85	51450.0
2020-05-11 04:00:00	DIA	ETF	245.11	245.11	243.88	243.99	2432.0
2020-05-11 05:00:00	DIA	ETF	243.65	243.65	243.02	243.38	1642.0

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

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