PREVIEW / etf_1hour / 2022-04-07

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-04-07.parquet
  size:    446 KB
  rows:    16,034

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-07 04:00:00	SPY	ETF	445.74	447.5	445.61	447.5	35427.0
2022-04-07 05:00:00	SPY	ETF	447.41	447.9	447.1	447.9	41321.0
2022-04-07 06:00:00	SPY	ETF	447.88	447.99	447.55	447.57	30663.0
2022-04-07 07:00:00	SPY	ETF	447.54	448.65	446.91	447.34	267988.0
2022-04-07 08:00:00	SPY	ETF	448.4801	448.5	444.95	445.9001	613547.0
2022-04-07 09:00:00	SPY	ETF	445.98	447.655	445.29	447.0	6288238.0
2022-04-07 10:00:00	SPY	ETF	447.0	447.75	444.31	445.24	8805682.0
2022-04-07 11:00:00	SPY	ETF	445.2352	446.09	443.86	444.32	6396021.0
2022-04-07 12:00:00	SPY	ETF	444.31	445.18	443.53	444.2715	5266039.0
2022-04-07 13:00:00	SPY	ETF	444.27	447.685	444.16	447.49	7446285.0
2022-04-07 14:00:00	SPY	ETF	447.46	449.47	446.88	449.24	7742388.0
2022-04-07 15:00:00	SPY	ETF	449.25	450.69	448.44	448.74	17365396.0
2022-04-07 16:00:00	SPY	ETF	448.74	448.95	448.21	448.56	2930904.0
2022-04-07 17:00:00	SPY	ETF	448.5	448.63	448.29	448.51	70346.0
2022-04-07 18:00:00	SPY	ETF	448.5	448.85	448.48	448.64	70341.0
2022-04-07 19:00:00	SPY	ETF	448.7	449.32	448.61	449.24	24890.0
2022-04-07 04:00:00	QQQ	ETF	353.49	354.98	353.38	354.93	115882.0
2022-04-07 05:00:00	QQQ	ETF	354.84	355.11	354.49	355.08	66622.0
2022-04-07 06:00:00	QQQ	ETF	355.0	355.22	354.54	354.54	81570.0
2022-04-07 07:00:00	QQQ	ETF	354.59	355.56	353.94	354.36	351545.0
2022-04-07 08:00:00	QQQ	ETF	354.24	355.53	351.75	352.65	556315.0
2022-04-07 09:00:00	QQQ	ETF	352.72	355.0	351.93	354.6	7632439.0
2022-04-07 10:00:00	QQQ	ETF	354.57	355.73	351.32	352.4	9364685.0
2022-04-07 11:00:00	QQQ	ETF	352.4	353.3	349.58	350.12	6256496.0
2022-04-07 12:00:00	QQQ	ETF	350.11	351.11	348.69	349.6881	4879703.0
2022-04-07 13:00:00	QQQ	ETF	349.655	353.29	349.58	353.0617	5917505.0
2022-04-07 14:00:00	QQQ	ETF	353.05	354.99	352.2799	354.72	5515859.0
2022-04-07 15:00:00	QQQ	ETF	354.67	356.35	353.82	354.13	10165533.0
2022-04-07 16:00:00	QQQ	ETF	354.12	354.35	353.63	353.96	1153090.0
2022-04-07 17:00:00	QQQ	ETF	353.93	354.16	353.89	354.09	134801.0
2022-04-07 18:00:00	QQQ	ETF	354.09	354.3	353.95	354.06	115240.0
2022-04-07 19:00:00	QQQ	ETF	354.1	354.89	354.0	354.69	215052.0
2022-04-07 04:00:00	IWM	ETF	199.93	200.34	199.7	200.34	19557.0
2022-04-07 05:00:00	IWM	ETF	200.37	200.73	200.16	200.73	34864.0
2022-04-07 06:00:00	IWM	ETF	200.77	200.8	200.66	200.76	22572.0
2022-04-07 07:00:00	IWM	ETF	200.69	201.31	200.46	200.65	51689.0
2022-04-07 08:00:00	IWM	ETF	200.72	200.9904	199.6796	199.97	115855.0
2022-04-07 09:00:00	IWM	ETF	200.01	201.23	199.51	199.86	2820095.0
2022-04-07 10:00:00	IWM	ETF	199.87	200.08	198.04	198.36	3604995.0
2022-04-07 11:00:00	IWM	ETF	198.38	198.91	197.435	197.61	2817349.0
2022-04-07 12:00:00	IWM	ETF	197.62	197.73	196.68	197.25	2412625.0
2022-04-07 13:00:00	IWM	ETF	197.23	198.77	197.19	198.68	2751850.0
2022-04-07 14:00:00	IWM	ETF	198.68	199.48	198.33	199.26	3183096.0
2022-04-07 15:00:00	IWM	ETF	199.26	200.38	199.15	199.41	5017736.0
2022-04-07 16:00:00	IWM	ETF	199.46	199.6	198.99	199.26	1207388.0
2022-04-07 17:00:00	IWM	ETF	199.35	199.46	199.02	199.27	77462.0
2022-04-07 18:00:00	IWM	ETF	199.27	199.33	199.18	199.25	32285.0
2022-04-07 19:00:00	IWM	ETF	199.26	199.52	199.17	199.51	47051.0
2022-04-07 04:00:00	DIA	ETF	344.3	344.75	344.3	344.75	605.0
2022-04-07 06:00:00	DIA	ETF	345.15	345.18	345.06	345.06	1800.0

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

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