PREVIEW / etf_1hour / 2020-04-02

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-04-02.parquet
  size:    369 KB
  rows:    12,662

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-04-02 04:00:00	SPY	ETF	249.53	250.63	249.53	249.67	632491.0
2020-04-02 05:00:00	SPY	ETF	249.65	249.86	248.89	249.05	128199.0
2020-04-02 06:00:00	SPY	ETF	249.02	249.71	248.5	249.48	231827.0
2020-04-02 07:00:00	SPY	ETF	249.46	250.02	248.65	249.88	558466.0
2020-04-02 08:00:00	SPY	ETF	248.6101	250.18	245.27	246.13	3332904.0
2020-04-02 09:00:00	SPY	ETF	246.13	248.03	242.94	246.5	19554240.0
2020-04-02 10:00:00	SPY	ETF	246.51	252.68	246.15	250.86	30460020.0
2020-04-02 11:00:00	SPY	ETF	250.85	251.34	248.67	250.795	20255210.0
2020-04-02 12:00:00	SPY	ETF	250.8	251.95	250.205	250.98	13659398.0
2020-04-02 13:00:00	SPY	ETF	251.0	251.72	247.53	248.25	18441457.0
2020-04-02 14:00:00	SPY	ETF	248.26	249.3479	245.93	249.31	21999005.0
2020-04-02 15:00:00	SPY	ETF	249.3	252.26	248.37	251.87	33650016.0
2020-04-02 16:00:00	SPY	ETF	251.88	253.0	249.4543	251.93	10174169.0
2020-04-02 17:00:00	SPY	ETF	251.86	252.05	251.55	251.95	1299814.0
2020-04-02 18:00:00	SPY	ETF	251.89	252.73	251.15	252.12	519115.0
2020-04-02 19:00:00	SPY	ETF	252.12	252.37	250.25	250.79	467140.0
2020-04-02 04:00:00	QQQ	ETF	184.79	185.51	184.75	184.8	49495.0
2020-04-02 05:00:00	QQQ	ETF	184.8	184.93	183.81	183.83	46805.0
2020-04-02 06:00:00	QQQ	ETF	183.66	184.38	183.33	183.89	83674.0
2020-04-02 07:00:00	QQQ	ETF	184.02	184.77	183.5	184.71	175536.0
2020-04-02 08:00:00	QQQ	ETF	184.04	185.1	181.6	181.96	1038792.0
2020-04-02 09:00:00	QQQ	ETF	181.95	183.71	180.27	182.49	6346345.0
2020-04-02 10:00:00	QQQ	ETF	182.4801	186.06	182.24	184.8167	9259040.0
2020-04-02 11:00:00	QQQ	ETF	184.81	185.81	184.01	185.5	5591178.0
2020-04-02 12:00:00	QQQ	ETF	185.52	186.06	184.76	185.36	3738234.0
2020-04-02 13:00:00	QQQ	ETF	185.37	185.87	182.96	183.58	5904794.0
2020-04-02 14:00:00	QQQ	ETF	183.58	184.25	181.865	184.2	6806064.0
2020-04-02 15:00:00	QQQ	ETF	184.195	190.1	183.66	186.02	10240291.0
2020-04-02 16:00:00	QQQ	ETF	186.02	186.93	185.91	186.11	1267577.0
2020-04-02 17:00:00	QQQ	ETF	186.19	186.34	186.01	186.3	40487.0
2020-04-02 18:00:00	QQQ	ETF	186.1	186.8	185.74	186.42	141490.0
2020-04-02 19:00:00	QQQ	ETF	186.48	186.52	185.06	185.38	122288.0
2020-04-02 04:00:00	IWM	ETF	108.38	108.81	108.35	108.35	11365.0
2020-04-02 05:00:00	IWM	ETF	108.21	108.29	108.0	108.15	7847.0
2020-04-02 06:00:00	IWM	ETF	107.92	108.15	107.85	107.85	15656.0
2020-04-02 07:00:00	IWM	ETF	107.99	108.09	107.53	108.09	116315.0
2020-04-02 08:00:00	IWM	ETF	107.58	108.17	106.17	106.51	445582.0
2020-04-02 09:00:00	IWM	ETF	106.51	107.57	104.99	106.94	4147592.0
2020-04-02 10:00:00	IWM	ETF	106.95	110.39	106.66	108.91	6494805.0
2020-04-02 11:00:00	IWM	ETF	108.87	109.27	107.4	108.97	4601062.0
2020-04-02 12:00:00	IWM	ETF	108.99	109.33	106.0	108.12	3229088.0
2020-04-02 13:00:00	IWM	ETF	108.19	108.55	106.25	106.64	3203510.0
2020-04-02 14:00:00	IWM	ETF	106.65	106.65	104.565	106.2279	5740964.0
2020-04-02 15:00:00	IWM	ETF	106.275	107.76	105.81	107.74	8596568.0
2020-04-02 16:00:00	IWM	ETF	107.75	108.21	107.51	107.51	2159939.0
2020-04-02 17:00:00	IWM	ETF	107.4	107.65	107.32	107.55	12729.0
2020-04-02 18:00:00	IWM	ETF	107.56	107.69	107.16	107.56	57553.0
2020-04-02 19:00:00	IWM	ETF	107.5	107.51	106.8	107.0	31517.0
2020-04-02 04:00:00	DIA	ETF	212.7	213.28	212.65	212.65	8172.0
2020-04-02 05:00:00	DIA	ETF	212.58	212.82	212.1	212.1	4500.0

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

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