PREVIEW / etf_1hour / 2022-05-18

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-05-18.parquet
  size:    459 KB
  rows:    16,555

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-05-18 04:00:00	SPY	ETF	406.99	406.99	406.13	406.65	28449.0
2022-05-18 05:00:00	SPY	ETF	406.66	407.45	406.51	407.45	18685.0
2022-05-18 06:00:00	SPY	ETF	407.56	407.68	406.04	406.3	157905.0
2022-05-18 07:00:00	SPY	ETF	406.29	406.4	404.65	404.72	671098.0
2022-05-18 08:00:00	SPY	ETF	406.3301	407.25	403.49	403.49	778579.0
2022-05-18 09:00:00	SPY	ETF	403.54	403.9	400.87	401.16	6436026.0
2022-05-18 10:00:00	SPY	ETF	401.16	402.12	399.93	400.77	8030427.0
2022-05-18 11:00:00	SPY	ETF	400.76	400.76	396.09	396.5	10107064.0
2022-05-18 12:00:00	SPY	ETF	396.51	397.16	395.22	397.05	8271998.0
2022-05-18 13:00:00	SPY	ETF	397.05	397.05	392.46	393.01	10911529.0
2022-05-18 14:00:00	SPY	ETF	393.0	393.89	391.43	391.6851	10834227.0
2022-05-18 15:00:00	SPY	ETF	391.69	392.74	390.55	391.93	23343389.0
2022-05-18 16:00:00	SPY	ETF	391.91	392.39	390.25	391.05	6994205.0
2022-05-18 17:00:00	SPY	ETF	390.95	391.42	390.95	391.42	88179.0
2022-05-18 18:00:00	SPY	ETF	391.2	391.61	390.96	391.47	84871.0
2022-05-18 19:00:00	SPY	ETF	391.46	391.47	389.5	389.51	261018.0
2022-05-18 04:00:00	QQQ	ETF	304.66	304.96	303.75	304.27	45684.0
2022-05-18 05:00:00	QQQ	ETF	304.14	304.94	304.06	304.94	16922.0
2022-05-18 06:00:00	QQQ	ETF	305.0	305.23	303.96	304.23	100010.0
2022-05-18 07:00:00	QQQ	ETF	304.28	304.4	302.58	302.67	543207.0
2022-05-18 08:00:00	QQQ	ETF	303.7899	305.0	301.43	301.45	695182.0
2022-05-18 09:00:00	QQQ	ETF	301.5	302.25	299.61	299.8456	6842504.0
2022-05-18 10:00:00	QQQ	ETF	299.84	301.3	298.88	299.93	6538429.0
2022-05-18 11:00:00	QQQ	ETF	299.95	299.95	295.34	295.4301	7262474.0
2022-05-18 12:00:00	QQQ	ETF	295.46	295.855	293.97	295.81	6982303.0
2022-05-18 13:00:00	QQQ	ETF	295.8	295.83	291.5137	292.005	7266630.0
2022-05-18 14:00:00	QQQ	ETF	291.99	292.77	290.55	290.79	6655842.0
2022-05-18 15:00:00	QQQ	ETF	290.82	292.07	289.85	291.09	12011837.0
2022-05-18 16:00:00	QQQ	ETF	291.04	291.31	289.26	289.95	3500977.0
2022-05-18 17:00:00	QQQ	ETF	289.91	291.14	289.91	289.99	460582.0
2022-05-18 18:00:00	QQQ	ETF	290.13	290.53	289.75	290.28	312499.0
2022-05-18 19:00:00	QQQ	ETF	290.28	290.3	288.07	288.3	280212.0
2022-05-18 04:00:00	IWM	ETF	182.0	182.0	181.51	181.8	10748.0
2022-05-18 05:00:00	IWM	ETF	181.85	182.05	181.72	181.99	12966.0
2022-05-18 06:00:00	IWM	ETF	182.26	182.26	181.73	181.83	34219.0
2022-05-18 07:00:00	IWM	ETF	181.82	181.95	181.07	181.24	113922.0
2022-05-18 08:00:00	IWM	ETF	181.9	181.93	180.64	180.64	145408.0
2022-05-18 09:00:00	IWM	ETF	180.65	180.87	179.43	180.0	4369105.0
2022-05-18 10:00:00	IWM	ETF	180.0	181.41	179.93	180.88	3119352.0
2022-05-18 11:00:00	IWM	ETF	180.89	180.895	177.9	178.0	2574353.0
2022-05-18 12:00:00	IWM	ETF	177.99	178.545	177.11	178.38	2864961.0
2022-05-18 13:00:00	IWM	ETF	178.35	178.375	176.09	176.33	2328874.0
2022-05-18 14:00:00	IWM	ETF	176.31	176.8	175.34	175.46	2924871.0
2022-05-18 15:00:00	IWM	ETF	175.48	176.52	175.1	176.23	6859367.0
2022-05-18 16:00:00	IWM	ETF	176.24	176.39	175.63	176.2	1718221.0
2022-05-18 17:00:00	IWM	ETF	176.17	176.24	175.93	176.0	470876.0
2022-05-18 18:00:00	IWM	ETF	176.1	176.31	175.88	176.24	129830.0
2022-05-18 19:00:00	IWM	ETF	176.14	176.19	175.15	175.2	98459.0
2022-05-18 04:00:00	DIA	ETF	326.0	326.12	325.85	326.11	2160.0
2022-05-18 05:00:00	DIA	ETF	326.13	326.37	326.13	326.37	1890.0

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

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