PREVIEW / etf_1hour / 2021-06-01

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-06-01.parquet
  size:    424 KB
  rows:    15,161

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-06-01 04:00:00	SPY	ETF	421.48	421.7	421.14	421.63	26620.0
2021-06-01 05:00:00	SPY	ETF	421.65	421.92	421.55	421.7	34594.0
2021-06-01 06:00:00	SPY	ETF	421.73	421.91	421.71	421.87	56882.0
2021-06-01 07:00:00	SPY	ETF	421.84	422.49	421.83	422.2	221008.0
2021-06-01 08:00:00	SPY	ETF	421.8999	422.49	419.6	422.09	246533.0
2021-06-01 09:00:00	SPY	ETF	422.1	422.72	420.98	421.3	6596209.0
2021-06-01 10:00:00	SPY	ETF	421.3	421.5101	419.44	419.83	9105394.0
2021-06-01 11:00:00	SPY	ETF	419.81	420.475	419.56	420.29	4069283.0
2021-06-01 12:00:00	SPY	ETF	420.3	420.36	419.69	419.825	2966611.0
2021-06-01 13:00:00	SPY	ETF	419.83	419.83	419.2	419.6015	3280059.0
2021-06-01 14:00:00	SPY	ETF	419.6	420.38	419.46	420.33	4092741.0
2021-06-01 15:00:00	SPY	ETF	420.33	420.36	419.45	419.63	8759738.0
2021-06-01 16:00:00	SPY	ETF	419.63	419.925	419.49	419.59	3102313.0
2021-06-01 17:00:00	SPY	ETF	419.72	419.72	419.47	419.5	83249.0
2021-06-01 18:00:00	SPY	ETF	419.55	419.67	418.9	418.93	110195.0
2021-06-01 19:00:00	SPY	ETF	418.93	419.29	418.82	419.29	45546.0
2021-06-01 04:00:00	QQQ	ETF	334.16	334.92	334.16	334.89	53564.0
2021-06-01 05:00:00	QQQ	ETF	334.88	335.17	334.81	334.95	27995.0
2021-06-01 06:00:00	QQQ	ETF	334.99	335.17	334.9	334.96	43991.0
2021-06-01 07:00:00	QQQ	ETF	334.89	335.41	334.76	335.0	202650.0
2021-06-01 08:00:00	QQQ	ETF	335.0596	335.23	333.64	335.04	206078.0
2021-06-01 09:00:00	QQQ	ETF	335.03	335.785	334.15	334.59	3848997.0
2021-06-01 10:00:00	QQQ	ETF	334.6	334.7815	331.43	331.99	6824637.0
2021-06-01 11:00:00	QQQ	ETF	331.97	333.24	331.65	333.055	3498825.0
2021-06-01 12:00:00	QQQ	ETF	333.06	333.46	332.58	333.18	2214294.0
2021-06-01 13:00:00	QQQ	ETF	333.17	333.17	332.5099	333.0884	2035814.0
2021-06-01 14:00:00	QQQ	ETF	333.08	333.88	332.92	333.78	2170796.0
2021-06-01 15:00:00	QQQ	ETF	333.78	333.81	332.69	332.83	3552081.0
2021-06-01 16:00:00	QQQ	ETF	332.85	332.98	332.66	332.77	1072970.0
2021-06-01 17:00:00	QQQ	ETF	332.62	332.85	332.62	332.71	13328.0
2021-06-01 18:00:00	QQQ	ETF	332.8	332.8	332.23	332.25	55198.0
2021-06-01 19:00:00	QQQ	ETF	332.19	332.49	332.18	332.44	40576.0
2021-06-01 04:00:00	IWM	ETF	226.65	226.94	226.47	226.78	2806.0
2021-06-01 05:00:00	IWM	ETF	226.72	226.79	226.59	226.66	13575.0
2021-06-01 06:00:00	IWM	ETF	226.72	227.15	226.72	227.15	74183.0
2021-06-01 07:00:00	IWM	ETF	227.07	227.73	227.07	227.73	73461.0
2021-06-01 08:00:00	IWM	ETF	227.58	227.66	226.5	227.63	50033.0
2021-06-01 09:00:00	IWM	ETF	227.62	227.68	226.77	227.1559	3242499.0
2021-06-01 10:00:00	IWM	ETF	227.16	227.69	225.96	226.35	3495497.0
2021-06-01 11:00:00	IWM	ETF	226.32	227.4825	226.28	227.18	1824842.0
2021-06-01 12:00:00	IWM	ETF	227.19	228.04	226.98	227.65	2636008.0
2021-06-01 13:00:00	IWM	ETF	227.64	227.7	227.07	227.4881	1624028.0
2021-06-01 14:00:00	IWM	ETF	227.47	228.49	227.35	228.44	2001844.0
2021-06-01 15:00:00	IWM	ETF	228.44	228.5598	227.87	228.16	3682919.0
2021-06-01 16:00:00	IWM	ETF	228.16	228.33	228.01	228.19	935098.0
2021-06-01 17:00:00	IWM	ETF	228.33	228.33	228.2	228.23	11111.0
2021-06-01 18:00:00	IWM	ETF	228.21	228.21	227.75	227.76	24567.0
2021-06-01 19:00:00	IWM	ETF	227.73	227.92	227.73	227.92	12019.0
2021-06-01 04:00:00	DIA	ETF	347.14	347.25	347.13	347.25	2071.0
2021-06-01 05:00:00	DIA	ETF	347.38	347.38	347.21	347.21	2383.0

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

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