PREVIEW / etf_1hour / 2022-04-13

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-04-13.parquet
  size:    452 KB
  rows:    16,020

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-13 04:00:00	SPY	ETF	440.05	441.62	440.05	441.38	17096.0
2022-04-13 05:00:00	SPY	ETF	441.37	441.44	439.57	439.57	19753.0
2022-04-13 06:00:00	SPY	ETF	439.56	440.87	439.56	440.8	89573.0
2022-04-13 07:00:00	SPY	ETF	440.82	441.26	438.83	439.07	373848.0
2022-04-13 08:00:00	SPY	ETF	439.03	441.7	437.82	437.92	938334.0
2022-04-13 09:00:00	SPY	ETF	437.94	440.25	437.5	439.05	7905892.0
2022-04-13 10:00:00	SPY	ETF	439.04	439.94	438.26	439.825	7764269.0
2022-04-13 11:00:00	SPY	ETF	439.82	441.99	439.78	441.02	6556346.0
2022-04-13 12:00:00	SPY	ETF	441.03	442.59	440.76	442.1	5372874.0
2022-04-13 13:00:00	SPY	ETF	442.1	442.84	441.53	442.02	4901745.0
2022-04-13 14:00:00	SPY	ETF	442.03	443.0	441.75	442.8	4290139.0
2022-04-13 15:00:00	SPY	ETF	442.805	444.11	442.29	443.36	13238849.0
2022-04-13 16:00:00	SPY	ETF	443.36	443.41	442.91	442.99	3952446.0
2022-04-13 17:00:00	SPY	ETF	443.0	443.31	442.98	443.1	105005.0
2022-04-13 18:00:00	SPY	ETF	443.08	443.36	442.96	443.34	105452.0
2022-04-13 19:00:00	SPY	ETF	443.39	443.41	442.98	443.02	66849.0
2022-04-13 04:00:00	QQQ	ETF	342.06	342.88	341.97	342.6	150494.0
2022-04-13 05:00:00	QQQ	ETF	342.57	342.76	340.85	340.98	82835.0
2022-04-13 06:00:00	QQQ	ETF	340.92	342.15	340.87	342.07	75397.0
2022-04-13 07:00:00	QQQ	ETF	342.06	342.53	340.39	340.51	368278.0
2022-04-13 08:00:00	QQQ	ETF	342.2269	343.22	338.83	339.8	750471.0
2022-04-13 09:00:00	QQQ	ETF	339.77	342.7	339.06	341.33	7173287.0
2022-04-13 10:00:00	QQQ	ETF	341.35	343.84	340.83	342.58	7353166.0
2022-04-13 11:00:00	QQQ	ETF	342.59	345.2	342.555	344.6801	5520464.0
2022-04-13 12:00:00	QQQ	ETF	344.67	345.86	344.06	345.5101	4533545.0
2022-04-13 13:00:00	QQQ	ETF	345.52	345.99	344.18	344.875	4576165.0
2022-04-13 14:00:00	QQQ	ETF	344.88	346.12	344.61	345.93	4250248.0
2022-04-13 15:00:00	QQQ	ETF	345.9257	347.43	345.3586	346.36	9682545.0
2022-04-13 16:00:00	QQQ	ETF	346.34	346.45	346.05	346.1	1728657.0
2022-04-13 17:00:00	QQQ	ETF	346.15	346.35	346.08	346.35	56535.0
2022-04-13 18:00:00	QQQ	ETF	346.25	346.69	346.12	346.68	146561.0
2022-04-13 19:00:00	QQQ	ETF	346.65	346.7	346.15	346.15	197490.0
2022-04-13 04:00:00	IWM	ETF	198.89	199.07	198.7	199.04	6056.0
2022-04-13 05:00:00	IWM	ETF	198.93	198.94	198.04	198.04	7785.0
2022-04-13 06:00:00	IWM	ETF	198.21	198.61	198.13	198.61	11123.0
2022-04-13 07:00:00	IWM	ETF	198.6	198.93	197.69	197.8	185671.0
2022-04-13 08:00:00	IWM	ETF	198.8	199.0	197.29	197.66	344938.0
2022-04-13 09:00:00	IWM	ETF	197.65	199.36	197.33	199.0	4030428.0
2022-04-13 10:00:00	IWM	ETF	199.03	199.37	198.06	199.14	2458726.0
2022-04-13 11:00:00	IWM	ETF	199.14	200.27	199.03	199.8	2000063.0
2022-04-13 12:00:00	IWM	ETF	199.8	200.64	199.62	200.51	1639850.0
2022-04-13 13:00:00	IWM	ETF	200.53	200.87	200.2	200.49	1081274.0
2022-04-13 14:00:00	IWM	ETF	200.5	200.88	200.36	200.73	1024444.0
2022-04-13 15:00:00	IWM	ETF	200.74	201.45	200.535	200.95	3567569.0
2022-04-13 16:00:00	IWM	ETF	200.96	200.96	197.16	200.72	1334503.0
2022-04-13 17:00:00	IWM	ETF	200.78	200.91	200.65	200.9	106126.0
2022-04-13 18:00:00	IWM	ETF	200.83	200.94	200.7	200.94	18935.0
2022-04-13 19:00:00	IWM	ETF	200.94	200.98	200.64	200.81	33686.0
2022-04-13 05:00:00	DIA	ETF	343.17	343.17	343.17	343.17	312.0
2022-04-13 07:00:00	DIA	ETF	344.2	344.2	342.5	342.5	1689.0

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

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