PREVIEW / etf_1hour / 2021-03-04

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-03-04.parquet
  size:    444 KB
  rows:    15,593

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-04 04:00:00	SPY	ETF	380.79	381.16	379.19	379.86	99091.0
2021-03-04 05:00:00	SPY	ETF	379.83	380.01	378.8	379.6	85081.0
2021-03-04 06:00:00	SPY	ETF	379.32	380.26	378.82	380.16	236589.0
2021-03-04 07:00:00	SPY	ETF	380.21	380.91	380.04	380.87	275677.0
2021-03-04 08:00:00	SPY	ETF	380.8	381.96	378.8896	381.4	629145.0
2021-03-04 09:00:00	SPY	ETF	381.45	383.375	380.15	380.89	14470544.0
2021-03-04 10:00:00	SPY	ETF	380.87	382.43	378.579	381.85	23139661.0
2021-03-04 11:00:00	SPY	ETF	381.85	383.67	381.23	382.96	12010005.0
2021-03-04 12:00:00	SPY	ETF	382.97	384.0	376.36	377.0169	22808054.0
2021-03-04 13:00:00	SPY	ETF	377.01	377.91	371.88	371.94	21899211.0
2021-03-04 14:00:00	SPY	ETF	371.93	377.49	371.9	377.23	21867682.0
2021-03-04 15:00:00	SPY	ETF	377.2201	377.49	374.36	376.73	29841182.0
2021-03-04 16:00:00	SPY	ETF	376.73	377.24	375.7	376.45	6144359.0
2021-03-04 17:00:00	SPY	ETF	376.46	376.7	376.07	376.3	220109.0
2021-03-04 18:00:00	SPY	ETF	376.3	376.88	375.59	375.59	193753.0
2021-03-04 19:00:00	SPY	ETF	375.72	375.79	373.95	373.95	403248.0
2021-03-04 04:00:00	QQQ	ETF	308.45	309.17	306.89	307.67	116248.0
2021-03-04 05:00:00	QQQ	ETF	307.55	308.06	306.37	306.99	97726.0
2021-03-04 06:00:00	QQQ	ETF	306.88	308.37	306.18	308.12	314039.0
2021-03-04 07:00:00	QQQ	ETF	308.1	308.89	307.79	308.611	517177.0
2021-03-04 08:00:00	QQQ	ETF	306.65	309.85	306.4296	309.08	768741.0
2021-03-04 09:00:00	QQQ	ETF	309.12	311.28	306.49	307.01	12266937.0
2021-03-04 10:00:00	QQQ	ETF	306.99	311.06	305.025	310.245	18631704.0
2021-03-04 11:00:00	QQQ	ETF	310.24	312.04	309.1001	310.66	10831824.0
2021-03-04 12:00:00	QQQ	ETF	310.68	311.7	303.48	304.45	22897343.0
2021-03-04 13:00:00	QQQ	ETF	304.45	305.34	300.11	300.18	16479488.0
2021-03-04 14:00:00	QQQ	ETF	300.15	305.66	300.15	305.13	16256235.0
2021-03-04 15:00:00	QQQ	ETF	305.07	305.55	302.43	304.09	14908375.0
2021-03-04 16:00:00	QQQ	ETF	304.08	304.64	303.16	303.17	2266276.0
2021-03-04 17:00:00	QQQ	ETF	303.15	304.3	303.01	303.29	112367.0
2021-03-04 18:00:00	QQQ	ETF	303.2	304.1	302.56	302.67	253953.0
2021-03-04 19:00:00	QQQ	ETF	302.5	302.69	300.82	300.84	279027.0
2021-03-04 04:00:00	IWM	ETF	219.05	219.31	217.45	218.03	10769.0
2021-03-04 05:00:00	IWM	ETF	218.19	218.19	216.8	217.52	13020.0
2021-03-04 06:00:00	IWM	ETF	217.59	218.09	216.9	218.06	60234.0
2021-03-04 07:00:00	IWM	ETF	218.05	218.93	218.05	218.93	60878.0
2021-03-04 08:00:00	IWM	ETF	218.2501	219.59	217.72	219.05	178687.0
2021-03-04 09:00:00	IWM	ETF	219.05	220.685	217.725	218.0	4645209.0
2021-03-04 10:00:00	IWM	ETF	218.0	218.66	215.16	218.04	7065700.0
2021-03-04 11:00:00	IWM	ETF	218.09	218.86	216.34	218.2	3421893.0
2021-03-04 12:00:00	IWM	ETF	218.22	218.95	213.24	213.82	6121985.0
2021-03-04 13:00:00	IWM	ETF	213.81	214.8	209.71	209.74	7776160.0
2021-03-04 14:00:00	IWM	ETF	209.73	214.36	209.43	214.1	6805081.0
2021-03-04 15:00:00	IWM	ETF	214.07	214.4	211.68	213.27	7121308.0
2021-03-04 16:00:00	IWM	ETF	213.29	216.9008	213.19	213.65	2723244.0
2021-03-04 17:00:00	IWM	ETF	213.49	213.75	213.26	213.49	21685.0
2021-03-04 18:00:00	IWM	ETF	213.5	213.95	212.76	212.77	71722.0
2021-03-04 19:00:00	IWM	ETF	212.65	212.67	210.831	210.89	103808.0
2021-03-04 04:00:00	DIA	ETF	312.95	312.95	312.07	312.11	500.0
2021-03-04 05:00:00	DIA	ETF	312.05	312.09	311.4	311.81	1100.0

> showing 50 of 15,593 rows — these rows as CSV

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