PREVIEW / etf_1hour / 2022-04-14

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-04-14.parquet
  size:    448 KB
  rows:    15,936

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-14 04:00:00	SPY	ETF	443.46	443.56	442.88	443.22	28411.0
2022-04-14 05:00:00	SPY	ETF	443.3	443.4	442.84	443.31	13512.0
2022-04-14 06:00:00	SPY	ETF	443.39	443.58	442.89	443.27	9865.0
2022-04-14 07:00:00	SPY	ETF	443.24	443.68	442.42	442.54	76521.0
2022-04-14 08:00:00	SPY	ETF	442.5199	444.64	442.19	442.23	223365.0
2022-04-14 09:00:00	SPY	ETF	442.2	444.7301	441.67	442.1299	7139202.0
2022-04-14 10:00:00	SPY	ETF	442.18	442.95	440.51	441.42	9290933.0
2022-04-14 11:00:00	SPY	ETF	441.41	442.27	440.565	440.78	5802860.0
2022-04-14 12:00:00	SPY	ETF	440.775	441.2	439.47	440.08	5901760.0
2022-04-14 13:00:00	SPY	ETF	440.07	441.35	439.64	441.28	5173901.0
2022-04-14 14:00:00	SPY	ETF	441.28	441.83	439.33	439.34	6354296.0
2022-04-14 15:00:00	SPY	ETF	439.34	440.0	437.68	437.87	18202477.0
2022-04-14 16:00:00	SPY	ETF	437.86	438.05	437.6	438.02	6299618.0
2022-04-14 17:00:00	SPY	ETF	438.02	438.4	437.79	438.4	228374.0
2022-04-14 18:00:00	SPY	ETF	438.23	438.42	438.0	438.2	68288.0
2022-04-14 19:00:00	SPY	ETF	438.2	438.28	437.64	437.82	66067.0
2022-04-14 04:00:00	QQQ	ETF	347.08	347.37	346.45	346.82	96026.0
2022-04-14 05:00:00	QQQ	ETF	346.53	346.85	346.28	346.7	19530.0
2022-04-14 06:00:00	QQQ	ETF	346.82	347.01	345.92	346.38	82067.0
2022-04-14 07:00:00	QQQ	ETF	346.36	346.86	345.65	345.85	145394.0
2022-04-14 08:00:00	QQQ	ETF	346.8583	348.01	345.43	345.58	465450.0
2022-04-14 09:00:00	QQQ	ETF	345.62	346.97	343.51	343.7699	7615694.0
2022-04-14 10:00:00	QQQ	ETF	343.77	344.4	341.38	342.1	9390251.0
2022-04-14 11:00:00	QQQ	ETF	342.09	343.08	341.27	341.49	5484138.0
2022-04-14 12:00:00	QQQ	ETF	341.48	341.86	340.03	340.63	5340364.0
2022-04-14 13:00:00	QQQ	ETF	340.61	341.7633	340.2701	341.69	4317723.0
2022-04-14 14:00:00	QQQ	ETF	341.69	342.18	339.56	339.59	5311970.0
2022-04-14 15:00:00	QQQ	ETF	339.6	340.23	338.21	338.4	10403930.0
2022-04-14 16:00:00	QQQ	ETF	338.42	338.52	338.01	338.39	2118736.0
2022-04-14 17:00:00	QQQ	ETF	338.5	338.5	338.25	338.35	1321573.0
2022-04-14 18:00:00	QQQ	ETF	338.43	338.43	338.18	338.2	89008.0
2022-04-14 19:00:00	QQQ	ETF	338.2	338.3	337.9	337.91	37304.0
2022-04-14 04:00:00	IWM	ETF	200.73	200.9	200.47	200.82	15092.0
2022-04-14 05:00:00	IWM	ETF	200.92	201.0	200.68	200.86	7528.0
2022-04-14 06:00:00	IWM	ETF	201.0	201.11	200.78	200.91	10184.0
2022-04-14 07:00:00	IWM	ETF	200.86	201.12	200.47	200.49	28797.0
2022-04-14 08:00:00	IWM	ETF	200.5	201.28	200.29	200.29	161280.0
2022-04-14 09:00:00	IWM	ETF	200.34	202.37	200.2	200.82	3051314.0
2022-04-14 10:00:00	IWM	ETF	200.86	201.63	199.94	200.13	2588500.0
2022-04-14 11:00:00	IWM	ETF	200.11	200.6	199.36	199.36	1893943.0
2022-04-14 12:00:00	IWM	ETF	199.34	199.82	198.95	199.41	1489725.0
2022-04-14 13:00:00	IWM	ETF	199.41	200.25	199.15	200.22	1213508.0
2022-04-14 14:00:00	IWM	ETF	200.2	200.64	199.21	199.22	2011598.0
2022-04-14 15:00:00	IWM	ETF	199.24	199.58	198.9	198.93	3592651.0
2022-04-14 16:00:00	IWM	ETF	198.93	199.04	198.76	198.88	731739.0
2022-04-14 17:00:00	IWM	ETF	198.6	198.96	198.6	198.82	1436167.0
2022-04-14 18:00:00	IWM	ETF	198.77	198.96	198.64	198.65	65855.0
2022-04-14 19:00:00	IWM	ETF	198.65	198.7	198.25	198.35	10740.0
2022-04-14 04:00:00	DIA	ETF	345.5	345.63	345.5	345.63	650.0
2022-04-14 07:00:00	DIA	ETF	346.28	346.67	345.95	346.03	3549.0

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

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