PREVIEW / etf_1hour / 2021-08-05

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-08-05.parquet
  size:    405 KB
  rows:    14,093

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
2021-08-05 04:00:00	SPY	ETF	439.8	439.97	439.59	439.88	23415.0
2021-08-05 05:00:00	SPY	ETF	439.98	440.47	439.98	440.38	13649.0
2021-08-05 06:00:00	SPY	ETF	440.39	440.39	439.86	439.95	52248.0
2021-08-05 07:00:00	SPY	ETF	439.94	440.22	439.8	440.15	221057.0
2021-08-05 08:00:00	SPY	ETF	439.8801	440.27	439.73	439.84	220016.0
2021-08-05 09:00:00	SPY	ETF	439.86	440.81	439.79	440.795	4868714.0
2021-08-05 10:00:00	SPY	ETF	440.8	441.075	440.33	440.975	4266839.0
2021-08-05 11:00:00	SPY	ETF	440.98	441.13	440.775	440.8831	2923603.0
2021-08-05 12:00:00	SPY	ETF	440.89	441.02	440.44	440.45	2330254.0
2021-08-05 13:00:00	SPY	ETF	440.455	441.0	440.41	440.98	2040521.0
2021-08-05 14:00:00	SPY	ETF	440.99	441.14	440.67	440.74	3188218.0
2021-08-05 15:00:00	SPY	ETF	440.74	441.85	440.65	441.76	7930920.0
2021-08-05 16:00:00	SPY	ETF	441.77	441.77	439.1133	441.68	2438021.0
2021-08-05 17:00:00	SPY	ETF	441.7	441.74	441.59	441.6	59728.0
2021-08-05 18:00:00	SPY	ETF	441.6	441.76	441.43	441.46	48904.0
2021-08-05 19:00:00	SPY	ETF	441.46	441.46	441.31	441.31	33297.0
2021-08-05 04:00:00	QQQ	ETF	367.91	368.0	367.75	367.98	38409.0
2021-08-05 05:00:00	QQQ	ETF	367.92	368.48	367.92	368.44	23291.0
2021-08-05 06:00:00	QQQ	ETF	368.35	368.53	368.2	368.24	36935.0
2021-08-05 07:00:00	QQQ	ETF	368.23	368.53	368.1	368.44	36968.0
2021-08-05 08:00:00	QQQ	ETF	368.44	368.52	367.57	368.03	77564.0
2021-08-05 09:00:00	QQQ	ETF	368.0	368.84	367.45	368.74	3037354.0
2021-08-05 10:00:00	QQQ	ETF	368.75	369.42	368.21	369.2499	3443422.0
2021-08-05 11:00:00	QQQ	ETF	369.25	369.75	369.13	369.2992	2311209.0
2021-08-05 12:00:00	QQQ	ETF	369.29	369.47	369.0301	369.105	1625364.0
2021-08-05 13:00:00	QQQ	ETF	369.12	369.48	369.01	369.46	1047294.0
2021-08-05 14:00:00	QQQ	ETF	369.468	369.65	369.31	369.4	1613812.0
2021-08-05 15:00:00	QQQ	ETF	369.37	369.91	369.11	369.77	3367025.0
2021-08-05 16:00:00	QQQ	ETF	369.77	369.83	369.31	369.83	950530.0
2021-08-05 17:00:00	QQQ	ETF	369.86	369.86	369.7	369.8	6599.0
2021-08-05 18:00:00	QQQ	ETF	369.71	369.78	369.62	369.66	19727.0
2021-08-05 19:00:00	QQQ	ETF	369.66	369.74	369.58	369.59	45885.0
2021-08-05 04:00:00	IWM	ETF	218.58	218.81	218.58	218.81	20672.0
2021-08-05 05:00:00	IWM	ETF	218.83	219.07	218.71	218.96	21569.0
2021-08-05 06:00:00	IWM	ETF	218.84	218.89	218.38	218.38	168306.0
2021-08-05 07:00:00	IWM	ETF	218.4	218.73	218.32	218.71	170613.0
2021-08-05 08:00:00	IWM	ETF	218.34	219.12	218.03	218.71	171863.0
2021-08-05 09:00:00	IWM	ETF	218.75	220.6	218.68	220.595	3445835.0
2021-08-05 10:00:00	IWM	ETF	220.6	221.16	219.565	221.1506	3046637.0
2021-08-05 11:00:00	IWM	ETF	221.16	222.39	221.12	222.06	2964011.0
2021-08-05 12:00:00	IWM	ETF	222.06	222.435	221.32	221.52	2706130.0
2021-08-05 13:00:00	IWM	ETF	221.53	221.9	221.37	221.78	1073148.0
2021-08-05 14:00:00	IWM	ETF	221.76	222.06	221.5	221.64	1574908.0
2021-08-05 15:00:00	IWM	ETF	221.65	222.22	221.62	222.11	3146359.0
2021-08-05 16:00:00	IWM	ETF	222.11	222.15	221.96	221.96	852725.0
2021-08-05 17:00:00	IWM	ETF	221.96	222.1	221.84	222.0	16533.0
2021-08-05 18:00:00	IWM	ETF	222.02	222.02	221.8	221.8	57702.0
2021-08-05 19:00:00	IWM	ETF	221.84	221.84	221.73	221.8	51160.0
2021-08-05 04:00:00	DIA	ETF	348.35	348.37	348.22	348.37	1250.0
2021-08-05 05:00:00	DIA	ETF	348.69	348.78	348.69	348.74	1800.0

> showing 50 of 14,093 rows — these rows as CSV

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