PREVIEW / etf_1hour / 2021-03-25

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-03-25.parquet
  size:    416 KB
  rows:    14,623

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-03-25 04:00:00	SPY	ETF	387.7	388.93	387.52	388.54	48218.0
2021-03-25 05:00:00	SPY	ETF	388.29	388.35	387.99	388.31	17551.0
2021-03-25 06:00:00	SPY	ETF	388.4	388.74	388.4	388.69	123419.0
2021-03-25 07:00:00	SPY	ETF	388.64	388.7	386.08	386.12	354630.0
2021-03-25 08:00:00	SPY	ETF	386.14	388.8	385.53	385.9	1035551.0
2021-03-25 09:00:00	SPY	ETF	385.84	386.57	385.02	386.27	14000198.0
2021-03-25 10:00:00	SPY	ETF	386.27	387.3	383.9	384.82	14666089.0
2021-03-25 11:00:00	SPY	ETF	384.85	386.98	383.95	386.85	11866953.0
2021-03-25 12:00:00	SPY	ETF	386.86	388.41	386.41	388.07	9143156.0
2021-03-25 13:00:00	SPY	ETF	388.07	388.73	387.24	387.37	8855939.0
2021-03-25 14:00:00	SPY	ETF	387.34	388.98	386.595	388.88	6506029.0
2021-03-25 15:00:00	SPY	ETF	388.88	390.55	388.83	389.65	19322606.0
2021-03-25 16:00:00	SPY	ETF	389.65	390.39	389.4938	390.26	4263821.0
2021-03-25 17:00:00	SPY	ETF	390.27	390.45	389.7	390.27	161915.0
2021-03-25 18:00:00	SPY	ETF	390.29	390.29	389.7	390.0	212280.0
2021-03-25 19:00:00	SPY	ETF	389.98	390.7	389.88	390.3	168752.0
2021-03-25 04:00:00	QQQ	ETF	312.18	313.44	311.81	312.95	66576.0
2021-03-25 05:00:00	QQQ	ETF	312.73	312.88	312.32	312.8	55423.0
2021-03-25 06:00:00	QQQ	ETF	312.82	313.38	312.82	313.12	220954.0
2021-03-25 07:00:00	QQQ	ETF	313.07	313.12	310.34	310.52	375535.0
2021-03-25 08:00:00	QQQ	ETF	313.0904	313.2	309.7	310.09	818636.0
2021-03-25 09:00:00	QQQ	ETF	309.99	312.07	309.26	311.72	9364962.0
2021-03-25 10:00:00	QQQ	ETF	311.72	312.885	307.92	308.76	10824844.0
2021-03-25 11:00:00	QQQ	ETF	308.76	309.76	307.3899	309.63	9905360.0
2021-03-25 12:00:00	QQQ	ETF	309.63	311.49	309.23	310.85	8087445.0
2021-03-25 13:00:00	QQQ	ETF	310.83	311.67	309.52	309.64	6395325.0
2021-03-25 14:00:00	QQQ	ETF	309.625	311.6	308.485	311.48	6010703.0
2021-03-25 15:00:00	QQQ	ETF	311.45	312.56	310.97	311.32	9681651.0
2021-03-25 16:00:00	QQQ	ETF	311.34	311.87	311.33	311.75	2549070.0
2021-03-25 17:00:00	QQQ	ETF	311.54	311.77	311.33	311.77	148639.0
2021-03-25 18:00:00	QQQ	ETF	311.84	311.84	311.11	311.59	63174.0
2021-03-25 19:00:00	QQQ	ETF	311.58	312.3	311.54	312.05	120554.0
2021-03-25 04:00:00	IWM	ETF	212.99	213.36	212.66	212.87	27283.0
2021-03-25 05:00:00	IWM	ETF	212.83	212.83	212.25	212.34	25912.0
2021-03-25 06:00:00	IWM	ETF	212.41	212.69	212.35	212.48	14504.0
2021-03-25 07:00:00	IWM	ETF	212.41	212.45	209.39	209.41	497383.0
2021-03-25 08:00:00	IWM	ETF	211.7399	212.0799	208.67	209.49	591598.0
2021-03-25 09:00:00	IWM	ETF	209.34	211.285	208.64	209.84	6778176.0
2021-03-25 10:00:00	IWM	ETF	209.81	211.42	208.03	209.07	7508982.0
2021-03-25 11:00:00	IWM	ETF	209.08	213.32	208.43	213.27	7058578.0
2021-03-25 12:00:00	IWM	ETF	213.28	215.63	212.99	214.77	6534241.0
2021-03-25 13:00:00	IWM	ETF	214.76	215.6	213.42	213.48	3470272.0
2021-03-25 14:00:00	IWM	ETF	213.45	215.52	212.85	215.19	3092238.0
2021-03-25 15:00:00	IWM	ETF	215.17	217.52	215.07	216.69	7020482.0
2021-03-25 16:00:00	IWM	ETF	216.71	217.21	216.46	216.87	3130648.0
2021-03-25 17:00:00	IWM	ETF	216.71	217.3	216.71	217.1	32099.0
2021-03-25 18:00:00	IWM	ETF	217.19	217.24	216.51	216.75	107041.0
2021-03-25 19:00:00	IWM	ETF	216.75	217.62	216.75	217.31	36344.0
2021-03-25 04:00:00	DIA	ETF	324.5	325.17	324.5	325.15	1200.0
2021-03-25 05:00:00	DIA	ETF	324.83	324.83	324.77	324.77	294.0

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

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