PREVIEW / etf_1hour / 2021-10-13

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-10-13.parquet
  size:    419 KB
  rows:    14,689

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-10-13 04:00:00	SPY	ETF	433.52	434.99	433.52	434.62	32057.0
2021-10-13 05:00:00	SPY	ETF	434.55	434.72	434.36	434.55	39015.0
2021-10-13 06:00:00	SPY	ETF	434.71	434.96	434.2	434.2	39590.0
2021-10-13 07:00:00	SPY	ETF	434.28	434.74	433.93	434.51	325207.0
2021-10-13 08:00:00	SPY	ETF	434.53	435.09	433.0	433.52	979088.0
2021-10-13 09:00:00	SPY	ETF	433.5	435.3	432.71	433.09	8330655.0
2021-10-13 10:00:00	SPY	ETF	433.11	433.44	431.54	432.74	10037985.0
2021-10-13 11:00:00	SPY	ETF	432.74	434.25	432.31	433.62	6383172.0
2021-10-13 12:00:00	SPY	ETF	433.63	434.13	433.32	433.6605	3664429.0
2021-10-13 13:00:00	SPY	ETF	433.67	435.22	433.53	434.76	4638443.0
2021-10-13 14:00:00	SPY	ETF	434.76	436.05	433.94	434.48	8087377.0
2021-10-13 15:00:00	SPY	ETF	434.48	435.37	434.12	435.13	10974536.0
2021-10-13 16:00:00	SPY	ETF	435.13	435.28	434.5	435.12	2317217.0
2021-10-13 17:00:00	SPY	ETF	435.12	435.24	435.02	435.13	44191.0
2021-10-13 18:00:00	SPY	ETF	435.1	435.88	435.1	435.63	93886.0
2021-10-13 19:00:00	SPY	ETF	435.74	436.01	435.55	435.86	48677.0
2021-10-13 04:00:00	QQQ	ETF	357.74	359.1	357.49	358.67	72322.0
2021-10-13 05:00:00	QQQ	ETF	358.65	359.09	358.47	358.79	37726.0
2021-10-13 06:00:00	QQQ	ETF	358.9	359.45	358.67	358.71	52035.0
2021-10-13 07:00:00	QQQ	ETF	358.71	358.95	358.13	358.67	257331.0
2021-10-13 08:00:00	QQQ	ETF	358.56	359.31	356.3	357.94	691659.0
2021-10-13 09:00:00	QQQ	ETF	357.94	360.2899	357.77	358.73	5546783.0
2021-10-13 10:00:00	QQQ	ETF	358.75	359.33	357.59	358.32	5793351.0
2021-10-13 11:00:00	QQQ	ETF	358.32	359.33	357.43	359.01	3496154.0
2021-10-13 12:00:00	QQQ	ETF	359.02	359.09	358.32	358.52	2004359.0
2021-10-13 13:00:00	QQQ	ETF	358.51	360.09	358.44	359.6	3198527.0
2021-10-13 14:00:00	QQQ	ETF	359.6	360.69	358.9001	359.45	4775502.0
2021-10-13 15:00:00	QQQ	ETF	359.47	360.03	359.13	360.0	4668036.0
2021-10-13 16:00:00	QQQ	ETF	360.0	360.11	359.77	360.02	956291.0
2021-10-13 17:00:00	QQQ	ETF	360.03	360.05	359.91	360.05	88765.0
2021-10-13 18:00:00	QQQ	ETF	360.09	360.84	360.09	360.68	73752.0
2021-10-13 19:00:00	QQQ	ETF	360.69	361.0	360.57	360.88	70972.0
2021-10-13 04:00:00	IWM	ETF	221.83	222.52	221.71	222.21	24629.0
2021-10-13 05:00:00	IWM	ETF	222.27	222.27	221.99	222.04	24496.0
2021-10-13 06:00:00	IWM	ETF	222.08	222.38	221.96	222.19	15888.0
2021-10-13 07:00:00	IWM	ETF	222.18	222.56	221.92	222.46	113121.0
2021-10-13 08:00:00	IWM	ETF	222.23	222.69	221.26	221.75	397341.0
2021-10-13 09:00:00	IWM	ETF	221.75	222.7	221.09	221.16	2590968.0
2021-10-13 10:00:00	IWM	ETF	221.16	221.73	219.83	221.55	2996956.0
2021-10-13 11:00:00	IWM	ETF	221.58	222.4	221.21	221.72	1874048.0
2021-10-13 12:00:00	IWM	ETF	221.73	222.01	221.4	221.84	924486.0
2021-10-13 13:00:00	IWM	ETF	221.83	222.28	221.73	222.13	789081.0
2021-10-13 14:00:00	IWM	ETF	222.125	222.65	221.49	221.93	1855976.0
2021-10-13 15:00:00	IWM	ETF	221.94	222.59	221.61	222.56	2914792.0
2021-10-13 16:00:00	IWM	ETF	222.57	222.74	222.43	222.56	1269009.0
2021-10-13 17:00:00	IWM	ETF	222.37	222.57	222.37	222.57	7655.0
2021-10-13 18:00:00	IWM	ETF	222.57	222.99	222.57	222.85	47751.0
2021-10-13 19:00:00	IWM	ETF	223.0	223.12	222.8	222.94	21498.0
2021-10-13 04:00:00	DIA	ETF	343.83	344.56	343.66	344.56	3675.0
2021-10-13 05:00:00	DIA	ETF	344.34	344.34	344.34	344.34	400.0

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

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