PREVIEW / etf_1hour / 2022-04-11

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-04-11.parquet
  size:    459 KB
  rows:    16,537

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
2022-04-11 04:00:00	SPY	ETF	446.71	446.71	444.22	444.72	55994.0
2022-04-11 05:00:00	SPY	ETF	444.72	446.0	444.69	445.86	32706.0
2022-04-11 06:00:00	SPY	ETF	445.93	446.33	445.17	446.03	35400.0
2022-04-11 07:00:00	SPY	ETF	446.07	446.18	444.43	444.45	163308.0
2022-04-11 08:00:00	SPY	ETF	445.7501	446.92	443.7	444.23	400048.0
2022-04-11 09:00:00	SPY	ETF	444.22	445.0	442.89	444.1	9143291.0
2022-04-11 10:00:00	SPY	ETF	444.06	444.49	441.98	442.35	9503660.0
2022-04-11 11:00:00	SPY	ETF	442.32	442.75	441.605	442.1507	6105679.0
2022-04-11 12:00:00	SPY	ETF	442.15	442.34	441.35	441.85	4983912.0
2022-04-11 13:00:00	SPY	ETF	441.82	442.57	441.43	442.1891	4972234.0
2022-04-11 14:00:00	SPY	ETF	442.18	442.79	441.18	442.44	6450357.0
2022-04-11 15:00:00	SPY	ETF	442.46	443.0	439.39	439.97	18892111.0
2022-04-11 16:00:00	SPY	ETF	439.96	440.17	439.6	440.02	6343792.0
2022-04-11 17:00:00	SPY	ETF	440.02	440.12	439.91	440.059	176794.0
2022-04-11 18:00:00	SPY	ETF	440.09	440.39	440.07	440.36	102120.0
2022-04-11 19:00:00	SPY	ETF	440.36	440.36	439.45	439.66	80388.0
2022-04-11 20:00:00	SPY	ETF	439.67	439.67	439.67	439.67	600.0
2022-04-11 04:00:00	QQQ	ETF	348.0	348.0	344.81	345.28	196778.0
2022-04-11 05:00:00	QQQ	ETF	345.25	346.37	345.11	346.25	172403.0
2022-04-11 06:00:00	QQQ	ETF	346.23	346.79	345.4	346.53	130581.0
2022-04-11 07:00:00	QQQ	ETF	346.59	346.76	345.17	345.2	329310.0
2022-04-11 08:00:00	QQQ	ETF	346.55	349.411	344.11	344.8	972391.0
2022-04-11 09:00:00	QQQ	ETF	344.76	345.75	343.375	344.35	7483955.0
2022-04-11 10:00:00	QQQ	ETF	344.33	345.5	341.78	342.15	9187404.0
2022-04-11 11:00:00	QQQ	ETF	342.13	343.33	341.89	342.73	4791635.0
2022-04-11 12:00:00	QQQ	ETF	342.73	343.35	342.0	343.16	3488390.0
2022-04-11 13:00:00	QQQ	ETF	343.12	344.12	342.71	343.2	4193808.0
2022-04-11 14:00:00	QQQ	ETF	343.21	343.8	342.09	343.25	4600143.0
2022-04-11 15:00:00	QQQ	ETF	343.27	343.92	340.535	340.88	10346971.0
2022-04-11 16:00:00	QQQ	ETF	340.91	341.18	340.63	341.01	1850927.0
2022-04-11 17:00:00	QQQ	ETF	341.0	341.13	340.95	340.98	61564.0
2022-04-11 18:00:00	QQQ	ETF	341.1	341.33	341.1	341.29	118752.0
2022-04-11 19:00:00	QQQ	ETF	341.24	341.26	340.29	340.48	189883.0
2022-04-11 04:00:00	IWM	ETF	197.6	197.64	196.7	197.01	30222.0
2022-04-11 05:00:00	IWM	ETF	197.08	197.7	197.01	197.69	6137.0
2022-04-11 06:00:00	IWM	ETF	197.69	198.02	197.5	198.02	16662.0
2022-04-11 07:00:00	IWM	ETF	197.99	198.06	197.23	197.23	56801.0
2022-04-11 08:00:00	IWM	ETF	197.37	197.73	196.8	196.99	195405.0
2022-04-11 09:00:00	IWM	ETF	197.04	198.26	196.47	198.22	4092195.0
2022-04-11 10:00:00	IWM	ETF	198.21	199.2549	197.44	197.5	5082483.0
2022-04-11 11:00:00	IWM	ETF	197.49	197.8	196.93	196.99	3190513.0
2022-04-11 12:00:00	IWM	ETF	196.97	197.07	195.88	196.32	2043394.0
2022-04-11 13:00:00	IWM	ETF	196.31	197.6766	196.29	197.59	3215460.0
2022-04-11 14:00:00	IWM	ETF	197.58	198.0688	197.05	197.97	2222207.0
2022-04-11 15:00:00	IWM	ETF	197.97	198.19	196.26	196.5	5891410.0
2022-04-11 16:00:00	IWM	ETF	196.51	196.79	196.32	196.5	1060511.0
2022-04-11 17:00:00	IWM	ETF	196.4	196.54	196.4	196.43	8397.0
2022-04-11 18:00:00	IWM	ETF	196.49	196.77	196.49	196.77	22088.0
2022-04-11 19:00:00	IWM	ETF	196.71	196.71	196.17	196.28	30934.0
2022-04-11 04:00:00	DIA	ETF	346.65	346.65	345.84	345.9	4800.0

> showing 50 of 16,537 rows — these rows as CSV

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