PREVIEW / etf_1hour / 2020-05-20

all etf 1-hour files

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

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-20 04:00:00	SPY	ETF	293.38	295.05	293.38	294.76	73074.0
2020-05-20 05:00:00	SPY	ETF	294.73	295.68	294.57	295.6	142083.0
2020-05-20 06:00:00	SPY	ETF	295.57	295.74	295.22	295.52	154814.0
2020-05-20 07:00:00	SPY	ETF	295.43	295.63	295.06	295.45	581826.0
2020-05-20 08:00:00	SPY	ETF	292.13	296.06	292.13	295.62	823118.0
2020-05-20 09:00:00	SPY	ETF	295.65	296.79	295.57	296.61	8008446.0
2020-05-20 10:00:00	SPY	ETF	296.605	297.55	296.474	297.09	10217871.0
2020-05-20 11:00:00	SPY	ETF	297.09	297.87	296.93	297.58	6719548.0
2020-05-20 12:00:00	SPY	ETF	297.573	297.74	296.1	296.87	8473357.0
2020-05-20 13:00:00	SPY	ETF	296.885	296.99	295.97	296.5023	7420772.0
2020-05-20 14:00:00	SPY	ETF	296.5	297.43	295.81	297.105	8489956.0
2020-05-20 15:00:00	SPY	ETF	297.1	297.34	296.22	296.96	17178339.0
2020-05-20 16:00:00	SPY	ETF	296.97	297.63	296.93	297.5	14347198.0
2020-05-20 17:00:00	SPY	ETF	297.5	297.65	296.93	297.55	97866.0
2020-05-20 18:00:00	SPY	ETF	297.58	297.66	297.0	297.07	326847.0
2020-05-20 19:00:00	SPY	ETF	297.05	297.15	296.8	296.83	250940.0
2020-05-20 04:00:00	QQQ	ETF	227.98	229.18	227.98	228.95	64702.0
2020-05-20 05:00:00	QQQ	ETF	228.94	229.66	228.89	229.65	34068.0
2020-05-20 06:00:00	QQQ	ETF	229.56	229.61	229.22	229.47	26625.0
2020-05-20 07:00:00	QQQ	ETF	229.4	229.45	229.15	229.31	130758.0
2020-05-20 08:00:00	QQQ	ETF	229.32	229.75	227.43	229.47	264906.0
2020-05-20 09:00:00	QQQ	ETF	229.53	230.9199	229.38	230.91	5068863.0
2020-05-20 10:00:00	QQQ	ETF	230.92	231.22	230.51	230.76	5219377.0
2020-05-20 11:00:00	QQQ	ETF	230.77	231.74	230.74	231.5999	3564312.0
2020-05-20 12:00:00	QQQ	ETF	231.6	231.76	230.15	230.93	4182806.0
2020-05-20 13:00:00	QQQ	ETF	230.94	231.13	230.25	230.81	2929979.0
2020-05-20 14:00:00	QQQ	ETF	230.8	231.38	230.18	231.26	3583203.0
2020-05-20 15:00:00	QQQ	ETF	231.26	231.57	230.645	231.36	4720257.0
2020-05-20 16:00:00	QQQ	ETF	231.35	231.8	230.9457	231.75	1269726.0
2020-05-20 17:00:00	QQQ	ETF	231.72	231.95	231.72	231.92	68683.0
2020-05-20 18:00:00	QQQ	ETF	231.84	231.9	231.46	231.52	94347.0
2020-05-20 19:00:00	QQQ	ETF	231.57	231.65	231.43	231.55	87684.0
2020-05-20 04:00:00	IWM	ETF	131.12	132.52	131.12	132.33	23609.0
2020-05-20 05:00:00	IWM	ETF	132.36	132.79	131.94	132.79	16600.0
2020-05-20 06:00:00	IWM	ETF	132.66	133.06	132.61	132.74	43115.0
2020-05-20 07:00:00	IWM	ETF	132.72	132.77	132.08	132.5	149240.0
2020-05-20 08:00:00	IWM	ETF	132.1899	132.83	131.4	132.27	175769.0
2020-05-20 09:00:00	IWM	ETF	132.4	133.84	132.21	133.33	4837294.0
2020-05-20 10:00:00	IWM	ETF	133.33	134.94	133.1	134.895	5936127.0
2020-05-20 11:00:00	IWM	ETF	134.89	134.98	134.25	134.66	4015595.0
2020-05-20 12:00:00	IWM	ETF	134.65	134.74	133.26	133.94	3455818.0
2020-05-20 13:00:00	IWM	ETF	133.95	134.29	133.32	133.92	2634379.0
2020-05-20 14:00:00	IWM	ETF	133.92	134.59	133.48	134.3077	2726185.0
2020-05-20 15:00:00	IWM	ETF	134.3	134.39	133.5687	133.96	4510354.0
2020-05-20 16:00:00	IWM	ETF	134.0	134.37	133.91	134.3	2423149.0
2020-05-20 17:00:00	IWM	ETF	134.47	134.55	134.0	134.4099	66600.0
2020-05-20 18:00:00	IWM	ETF	134.25	134.49	133.99	134.14	81424.0
2020-05-20 19:00:00	IWM	ETF	134.01	134.09	133.9	133.9899	24514.0
2020-05-20 04:00:00	DIA	ETF	243.84	244.85	243.84	244.57	1735.0
2020-05-20 05:00:00	DIA	ETF	244.58	245.22	244.58	245.22	2755.0

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

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