PREVIEW / etf_1hour / 2021-03-29

all etf 1-hour files

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

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-29 04:00:00	SPY	ETF	394.03	394.03	393.19	393.68	84591.0
2021-03-29 05:00:00	SPY	ETF	393.61	394.49	393.61	394.48	36529.0
2021-03-29 06:00:00	SPY	ETF	394.46	394.77	394.34	394.5	123512.0
2021-03-29 07:00:00	SPY	ETF	394.49	395.03	394.32	394.39	258392.0
2021-03-29 08:00:00	SPY	ETF	394.74	395.0096	392.98	394.04	370541.0
2021-03-29 09:00:00	SPY	ETF	394.05	399.9398	393.8	394.11	8507422.0
2021-03-29 10:00:00	SPY	ETF	394.12	394.39	392.9885	393.21	12409792.0
2021-03-29 11:00:00	SPY	ETF	393.21	394.87	392.81	394.66	9170314.0
2021-03-29 12:00:00	SPY	ETF	394.65	395.87	393.57	395.82	7362888.0
2021-03-29 13:00:00	SPY	ETF	395.81	396.64	395.5	395.62	8211771.0
2021-03-29 14:00:00	SPY	ETF	395.62	396.01	394.9	395.46	8480824.0
2021-03-29 15:00:00	SPY	ETF	395.47	396.75	395.12	395.77	17918843.0
2021-03-29 16:00:00	SPY	ETF	395.76	396.1	395.58	395.88	11925882.0
2021-03-29 17:00:00	SPY	ETF	395.88	396.25	395.69	396.1	239369.0
2021-03-29 18:00:00	SPY	ETF	396.03	396.43	395.78	396.11	109051.0
2021-03-29 19:00:00	SPY	ETF	396.14	396.28	395.85	396.19	37398.0
2021-03-29 04:00:00	QQQ	ETF	314.26	314.58	313.41	314.16	245015.0
2021-03-29 05:00:00	QQQ	ETF	314.12	315.45	314.04	315.35	142827.0
2021-03-29 06:00:00	QQQ	ETF	315.33	315.83	315.06	315.58	156056.0
2021-03-29 07:00:00	QQQ	ETF	315.61	316.22	315.61	315.78	251880.0
2021-03-29 08:00:00	QQQ	ETF	315.71	316.1496	312.36	314.87	256372.0
2021-03-29 09:00:00	QQQ	ETF	314.9	316.38	313.35	313.38	7321835.0
2021-03-29 10:00:00	QQQ	ETF	313.39	314.66	312.47	313.65	9241821.0
2021-03-29 11:00:00	QQQ	ETF	313.68	314.94	312.82	314.47	5841027.0
2021-03-29 12:00:00	QQQ	ETF	314.49	316.22	313.4	316.18	4222999.0
2021-03-29 13:00:00	QQQ	ETF	316.18	316.99	315.68	315.801	4822077.0
2021-03-29 14:00:00	QQQ	ETF	315.81	315.96	314.17	314.6299	4389589.0
2021-03-29 15:00:00	QQQ	ETF	314.66	316.24	314.66	315.87	5972080.0
2021-03-29 16:00:00	QQQ	ETF	315.87	316.4	315.57	316.03	947743.0
2021-03-29 17:00:00	QQQ	ETF	316.14	316.33	315.91	316.18	41804.0
2021-03-29 18:00:00	QQQ	ETF	316.19	316.5	316.18	316.3	74883.0
2021-03-29 19:00:00	QQQ	ETF	316.35	316.46	316.07	316.42	56966.0
2021-03-29 04:00:00	IWM	ETF	218.53	218.53	217.63	218.29	17310.0
2021-03-29 05:00:00	IWM	ETF	218.01	218.97	217.94	218.91	13339.0
2021-03-29 06:00:00	IWM	ETF	218.87	219.35	218.68	219.0	118994.0
2021-03-29 07:00:00	IWM	ETF	218.98	219.68	218.93	218.96	77482.0
2021-03-29 08:00:00	IWM	ETF	219.29	219.5496	217.55	219.36	92457.0
2021-03-29 09:00:00	IWM	ETF	219.38	220.93	219.01	219.74	3220721.0
2021-03-29 10:00:00	IWM	ETF	219.73	220.07	215.365	215.52	6199685.0
2021-03-29 11:00:00	IWM	ETF	215.51	216.2881	214.38	215.99	5177780.0
2021-03-29 12:00:00	IWM	ETF	215.925	216.79	214.08	216.59	3912527.0
2021-03-29 13:00:00	IWM	ETF	216.61	217.123	215.02	215.11	2732155.0
2021-03-29 14:00:00	IWM	ETF	215.18	215.79	214.27	214.685	2664110.0
2021-03-29 15:00:00	IWM	ETF	214.7	216.69	214.08	214.41	5870465.0
2021-03-29 16:00:00	IWM	ETF	214.4	214.75	214.19	214.65	1169541.0
2021-03-29 17:00:00	IWM	ETF	215.18	215.26	214.4	215.15	207650.0
2021-03-29 18:00:00	IWM	ETF	215.03	215.48	214.4	215.01	63169.0
2021-03-29 19:00:00	IWM	ETF	215.08	215.19	214.8	215.17	14985.0
2021-03-29 04:00:00	DIA	ETF	329.18	329.18	328.88	328.9	2017.0
2021-03-29 05:00:00	DIA	ETF	328.84	329.28	328.84	329.28	2750.0

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

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